Join Gini von Courter for an in-depth discussion in this video Create data and charts directly in PowerPoint, part of Data-Driven Presentations with Excel and PowerPoint 2016.
- [Instructor] There is one more way…to get Excel content into a PowerPoint presentation,…put it directly into PowerPoint.…If we choose Insert, one of our choices under Table…is to insert an Excel spreadsheet.…And this is exactly as advertised,…an Excel spreadsheet where I could type in information.…I have the ability to do all of the same formatting…I would do in Excel.…For all intents and purposes, I am in Excel…so if I wanted to format this as a table,…for example, easy enough to do.…
Just like this.…Click out, I'm in PowerPoint, double-click…and I'm still in Excel.…I've clicked Undo and that removes that table.…What else can we do this with?…Check it out, Chart.…I'd like to insert a column chart.…Click OK and we have a chart and its underlying table.…In my case, I actually only need Series 1,…and Series 1 is called Sales and I have some regions.…
Notice that as I'm modifying the information,…the chart itself is changing.…And I slide this back so we have a single series.…And as I enter my numeric information,…
- 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.