Join Gini von Courter for an in-depth discussion in this video Copy and paste content from Excel, part of Data-Driven Presentations with Excel and PowerPoint 2016.
- [Trainer] I've already opened my 27 YTD report in Excel.…This is a PowerPoint presentation, it's empty so far…and the theme here is a theme that is called Slice.…I'm going to use alt tab to swing back over to Excel…and I'm going to select a table.…Right click and copy, alt tab back to PowerPoint…and I have not three choices but five.…Let me show you what they are.…First, use the Destination Styles, not beautiful.…
Keep the source formatting nice…but not necessarily gorgeous…because we don't know that…the gold's a great match for the blue,…sort of potluck at this point.…Embed, which we will speak about in the next movie,…Paste As a Picture,…or just give me a text dump of all of the text.…Each of these is simply taking the text that we have…and placing it here.…If, for example, I choose Keep Source Formatting,…remember when I did this in an Excel workbook,…I could click on this, or double click,…and go back to my data.…
I can't do that here with these commands.…All of these commands are taking the content from Excel…
- 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.