Join Gini von Courter for an in-depth discussion in this video Format elements for the presentation, part of Data-Driven Presentations with Excel and PowerPoint 2016.
- [Instructor] Our next step will be…to take charts and tables, pivot charts…and pivot tables that we've created in Excel…and copy and paste them into PowerPoint.…Before we do that, we're going to to want to look at them…really through the eyes of our audience in PowerPoint.…Tables need to be well formatted…because if I copy and paste a table,…I will often do that as a picture…and it will look in PowerPoint like it looks here.…Let's handle formatting our tables first.…
Notice that we don't have enough space for our data…in many of these columns, so I can double click…and provide enough space.…Another choice might be to move a pivot table.…Remember that you can click on a pivot table…and choose to move it to another worksheet, if you wish.…I can move the pivot table and move the chart,…give them each more space.…I shouldn't let the fact that I have both of them…on the same sheet for my convenience…make me give short shrift to the formatting…that I should be providing for my audience later on.…
Remember also that you can switch your pivot table designs…
- Identify the theme used by the default paste option.
- Recall what is embedded when you copy an Excel table and then embed the table in a PowerPoint presentation.
- Recognize the actions that may compromise data or yield incorrect results if a data table is missing descriptive labels.
- Recall the benefits of using a slicer over using a filter.
- Name a great way to illustrate the timeline and progress of a project.
- Explain what PivotTables do to tabular data.