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

3 alternatives to building cascading drop-downs in SharePoint – SharePoint Maven

In this article, I share three options for building cascading, menu-driven drop-downs in SharePoint Online/Office 365.

Option 3: Customize in PowerApps

OK, for the real cascading menu, you will need to use Power Apps. It is not something that you can do quickly or easily, like with the options above. You will need to get familiar with Power Apps and some minor coding. Since this falls outside of the “out of the box” solution, I would like to share the technique documented by others who are true experts in this area.

 

Source: 3 alternatives to building cascading drop-downs in SharePoint – SharePoint Maven

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

Remove title header on SharePoint Online – SharePoint Tricks

When creating a new page a header with the title of the page will be shown to the user. In the current days, it’s not possible to remove that header from the page using the SharePoint interface. Today, we will share a PowerShell that allows you to remove that area from the page and some article that you can use with different options.

Replace the variable below with your own and you will have a page without the title header.

$PageName = "PageName"
$LoginUrl = "https://contoso.sharepoint.com/sites/siteName"

Connect-PnPOnline -Url $LoginUrl -UseWebLogin
Set-PnPClientSidePage -Identity $PageName -LayoutType Home

If you intend to remove from all the SitePages use this code, but before you do to all of the Site Pages, I would recommend making some backup. You can use the approach of this article for this.

$LoginUrl = "https://contoso.sharepoint.com/sites/siteName"
Connect-PnPOnline -Url $LoginUrl -UseWebLogin

$pages = (Get-PnPListItem -List SitePages).FieldValues
foreach($page in $pages){
    Set-PnPClientSidePage -Identity $page.FileLeafRef -LayoutType Home
}

 

Source: Remove title header on SharePoint Online – SharePoint Tricks

Posted on Leave a comment

list – How to make a filtered lookup field – SharePoint Stack Exchange

In addition to your “Deactivated” field, create a Calculated field named “ActiveTitle” (or whatever you want to call it). Use the following formula:

=IF(Deactivated,"",Title)

The ActiveTitle field will be empty when the Deactivated field is set. When you configure your lookup column, tell it to use the value from ActiveTitle instead of Title. Empty values will not show up in your lookup list, so you will end up with only the values that are not Deactivated. Let me know if you have any trouble.

Source: list – How to make a filtered lookup field – SharePoint Stack Exchange

Posted on Leave a comment

FIX: SharePoint 2013 Workflow recursion prevention – Part 2 | Microsoft Docs

FIX: SharePoint 2013 Workflow recursion prevention – Part 2

Following FIX: SharePoint 2013 Workflow recursion prevention – Part 1, this post will walk you through the processes of designing your workflow that creates a list item on another list and invokes the workflow associated with that list using the new REST APIs released through SharePoint 2013 May 2014 CU as pointed out in part 1 of this series.  If you haven’t read through part 1 of this series I suggest you do to get some background that will help you appreciate this post.

The scenario:

List1 has a workflow Workflow1 associated with it.

Workflow1 can be set to auto-start on item adding/updating or set to manually start or both, it doesn’t matter.

Source: FIX: SharePoint 2013 Workflow recursion prevention – Part 2 | Microsoft Docs