Posted on Leave a comment

How to Clear Notes from PowerPoint Before Sharing

If you plan on sharing your PowerPoint Slideshows, its best to leave out your added notes that you wrote while constructing the presentation since there might be information you might not want disclosed.

Before Sharing, make a copy of the presentation so you can retain your original copy if you need to access your notes again. To do this, click File > Save As.

image

Give the presentation a new name and click Save:

image

After saving the presentation, click File again then click Info.

image

Under Prepare for Sharing, click the Check for Issue button then click Inspect Document.

image

This will launch the Document Inspector dialog.

image

Click the Inspect button at the bottom of the window. This will run a quick scan and check for information within the notes area.

image

As you can see in the above screenshot, we do have some Presentation notes, click the Remove All button to clear out this information, the click Close. You can go ahead and share your presentation now.

Source: How to Clear Notes from PowerPoint Before Sharing

Posted on Leave a comment

How To Merge Videos in Windows 10 Using Photos App

Since Windows Movie Maker was officially discontinued at the beginning of 2017, for those who is on Windows 10 Microsoft has finally provided an alternative solution. Windows 10 Photos app lets you to combine and merge videos and save the result to a new file.

A big number of free utilities available to edit video files. But you will be happy to know that you can merge video files using one of the built-in apps! All you need is to install the latest Windows 10 Fall Creators Update version.

The Photos app comes with plenty of tools to edit your photos and videos. It is possible to use the Photos app to combine videos on your Windows 10 PC.

Before proceeding, ensure you are on the Fall Creators Update. Open the ‘About Windows’ app: Press the Win + R keys and type winver.exe in the Run dialog. Windows 10 Fall Creative Update was released to the public on October 17, 2017.

Merge Videos in Windows 10 with Photos App

  1. Open the Photos app and click on the Create button.
  2. Select the Video Project entry in the menu.Combine Videos Windows 10 Step 1
  3. Select the video files you need to combine into a single file.Combine Videos Windows 10 Step 2
  4. Name the project and click on ‘Create Video’.Combine Videos Windows 10 Step 3
  5. The app will go to the video editor mode, where you can trim the added videos if required.  Click Done after you finish.
  6. Click ‘click Export or share’.Combine Videos Windows 10 Step 4

Source: How To Merge Videos in Windows 10 Using Photos App

Posted on Leave a comment

MS Excel 2016: How to Change Data Source for a Pivot Table

Steps to Change the Data Source of a Pivot Table

To change the data source of an existing pivot table in Excel 2016, you will need to do the following steps:

  1. Select any cell in the pivot table to reveal more pivot table options in the toolbar. In this example, we have selected cell A1 on Sheet2.

    You now should see 2 new tabs appear in the toolbar called Analyze and Design.

    Microsoft Excel

  2. Select the Analyze tab from the toolbar at the top of the screen. In the Data group, click on Change Data Source button and select “Change Data Source” from the popup menu.

    Microsoft Excel

  3. When the Change PivotTable Data Source window appears, change the Table/Range value to the new data source that you want for your pivot table and then click on the OK button.

    Microsoft Excel

    In this example, we want to change the range from Sheet1!$A$1:$F$16 to Sheet1!$A$1:$F$17 because we have added one more row to our data in Sheet1.

    Microsoft Excel

  4. Now when you return to your pivot table, it should automatically refresh the pivot table and display the information from the new data source.

    Microsoft Excel

MS Excel 2016: How to Change Data Source for a Pivot Table

Source: MS Excel 2016: How to Change Data Source for a Pivot Table

Posted on Leave a comment

Excel Tips

Combine Text and Formatted Numbers

Here are a few examples of using the TEXT function to format numbers.

NOTE: There are more examples of Custom formats on the Microsoft websitego to top

combine text number format

  • Format a date as month/day/year:
    •   =”Payment is due ” & TEXT(A2,”mm/dd/yyyy”)
  • Format a number as currency:
    •   =”Amount due: ” & TEXT(A3,”$#,##0.00″)& ” USD”
  • Format a number as a percentage:
    •    =”Your score is ” & TEXT(A4,”0.00%”)
  • Format a number as a fraction:
    •    =”Hours worked: ” &TEXT(A5,”# ?/?”)

Easy steps – how to combine cells in Excel, with text and number format. Add text to formulas, show formatted numbers. Free Excel file, video, written steps

https://www.contextures.com/xlCombine01.html

Posted on Leave a comment

Organisation Chart in O365/ SharePoint – Microsoft Tech Community – 242582

We’re currently looking at having an organisational chart for our company, which display the structure of teams etc. and individual staff info.

 

Ideally we want this to be accessible via our SharePoint intranet, either as a link or embedded frame.

 

Does anyone know of an ‘out of the box’ solution for this? I know there is the O365 People app, which is basically pulling from AD/ the address book, however it doesn’t show a chart when you click on an individual.

 

So if there is an O365 solution that would be good, or if anyone knows a 3rd party software that does the job that would also be good to know.

 

Any help would be much appreciated!

 

If you by chance have Teams deployed, the Who App has an org chart tab that does this.

 

Source: Organisation Chart in O365/ SharePoint – Microsoft Tech Community – 242582