From the course: Miss Excel’s Top Productivity Hacks

Unlock the full course today

Join today to access over 23,100 courses taught by industry experts.

The perfect pair: PivotTables and PowerPoint

The perfect pair: PivotTables and PowerPoint - Microsoft Excel Tutorial

From the course: Miss Excel’s Top Productivity Hacks

Start my 1-month free trial Buy for my team

The perfect pair: PivotTables and PowerPoint

“

- You know what goes together like peanut butter and jelly, believe it or not, it is Excel and PowerPoint. Now, let's say you have an Excel workbook, and you want to go in and add a pivot table. However, you also have a PowerPoint presentation that you want to spice up a bit. And what happens when we put these two classics together, we get a working pivot table inside of our PowerPoint slides. This is a recipe you'll want to have in your kitchen. Here, we have a pivot table made off of our condiment cells data, and we are going to be copying this pivot table and pasting it into a PowerPoint file, and essentially creating a link between the pivot table and the version of the pivot table in PowerPoint. So that way, when we update the pivot table in Excel, it will automatically update the pivot table in PowerPoint. So let's check out how this works. First thing we're going to do is highlight our pivot table. So I'm going to…

Contents