Link an Excel Chart to a PowerPoint Presentation

In this post I will share with you how to link an Excel chart to a PowerPoint presentation. This is helpful when you expect changes to be made to the Excel chart and you want to have your audience view those changes from in one of your PowerPoint slides.

  1. Right click the edge of the Excel chart and select copy.excel chart copy

2. Navigate to PowerPoint slide and select the Paste Special menu from the clipboard group.

paste special powerpoint

 

3. Select Paste Link as Microsoft Excel Chart Object

paste special link as picture chart object

4. Click File >Info and then click “Edit Links to Files” which is in the bottom right corner of PowerPoint 2010, 2013, and 2016 versions. Check box for “Automatic Update” in the Links box.

automatic update powerpoint slide deck

Note: It is important that the Excel file is saved to a location in which the PowerPoint can read the link otherwise the update cannot work. Typically you would save the Excel file with the chart to a network drive that is accessible to the file from which the PowerPoint is saved.

 

Click here to download my PowerPoint shortcuts.

 

Advertisements
Posted in Excel, PowerPoint | Tagged | 2 Comments

Understanding Visio’s Glue to Shape vs Glue to Connection Point

In this post, I am going to explain how to connect Visio shapes. You can connect to the shape or to its connection point.

 

Visio glue to point or shape

Posted in Videos, Visio | Tagged | Leave a comment

Format Red Cells if the Date is Older than One Year in Excel [Video]

In this video, I will demo how to format rows with red formatting if the date has been more than a year old. I will use the DATEDIF function to work within the conditional formatting rules.

 

 

 

Posted in Excel, Videos | Leave a comment

Create a PivotTable in Excel [Video]

In this video, I will demo how to create an Excel PivotTable. This PivotTable will have Slicers and Timeline filters as well as a PivotTable chart.

 

Posted in Excel, Videos | Leave a comment

A Special Trick to Select All Cells within the Find Box [Video]

This video will share with you how to search for cells within Excel’s find command and then select all the contents simultaneously.

In the video, I show you how to delete all rows that contain the same value. I use Excel’s find (control + F), type what I want to select. Then I click “find all”). The secret is to do control + A to select all.

Posted in Excel, Videos | Leave a comment

Using the DATEDIF Function in Excel for Conditional Formatting Expired Training Dates [Video]

Posted in Excel, Videos | Tagged | 7 Comments

Create Screen Recordings with PowerPoint’s Office Mix Add-in

With PowerPoint 2013 or 2016, you can create screen recordings and then save video as an mp4 format. First you will need to get Office Mix for free.

Once you download Office Mix, your PowerPoint Ribbon Mix tab will look like this.

mix tab

Click the Screen Recording button to get started. It will give you an option to drag a selection around the portion of the screen you want to record.

video portion drag

 

Then you receive a 3-2-1 countdown. The recording will capture any mouse movements that come into the screen space you selected.

After you stop the recording, the video will be embedded into the PowerPoint slide. Right click the video and choose save media as….mp4.

save as mp4

I use this to create my video demos on my blog and then upload them to YouTube. Here is my last video I created about my favorite 6 Excel tips.

mp4 save

The Office Mix tool is one of my favorite software application tools.

Posted in PowerPoint | Tagged | 2 Comments

My Top 6 Excel Time Saving Tricks

Posted in Excel, Videos | 3 Comments

Making an Excel PivotTable, Slicers, and TimeScale Dashboard from the Reds 2016 Schedule [Video]

Posted in Excel, Videos | Leave a comment

Locate Differences From Within Two Excel Lists Using the Match Function

In this post, lets say you have a list of confirmed RSVP guests. You also have another list of actual guests who showed up. The problem is that you have some people who showed up but did not RSVP. In the graphic below can you spot out the two people that are in Column C (Actual List of Guests) but are not in Column A (Confirmed RSVP Guest Master List)? Probably, I guess it wouldn’t take that long for you find the two, but what if you had 500 or 1000 people on the list? Forget that approach. See my previous post on how to do this in Access here.

Master List vs Show Up List

The Match function returns the relative position of an item in an array that matches a specified value in a specified order is how Excel describes the Match function. That is a mouthful but let me try it in my own words. Tell Excel an item to look up. For example “Amy Woodson” from cell C2. Next tell Excel where to look to check where “Amy Woodson” is would be located from another list ($A$2:$A$10). Choose to find an exact match so type zero for the third argument (Match_type). If Excel finds “Amy Woodson” in the cross referenced list, then return what position it is in. So we will get a whole number if “Amy Woodson” is in both list. She is actually in the eight spot. That is why Excel places the value 8 next to her. Now how this is going to work is that if Excel cannot find the match, it will return an error #N/A. That is what will then tell us that we have someone that is not in both lists.

Match function

BINGO! We could then filter out all the #N/As to find out who was not on both lists. Henry Boxson and David Chapmen are not in the RSVP list in column A.

Match NA

If you liked this post you also might be interested in another post I wrote about ditching the VLookup and using the Match and Index instead to find the lookup value.

And here is my favorite PDF of  Excel Keyboard Shortcuts reference list.

 

 

 

Posted in Excel | Leave a comment