Join Gini von Courter for an in-depth discussion in this video Using the exercise files, part of Data-Driven Presentations with Excel and PowerPoint 2016.
- [Instructor] If you have access to the exercise files for this course, you can download them to your desktop as I've done here. The exercise files are in this folder, and there is a folder for each chapter. So for example when we begin with chapter one, if I open this particular file 2017 YTD Report in Excel, a banner will appear on the screen that shows you the name of this file, and you can come to this folder and find it. If you don't have access to the exercise files that's okay.
You can still follow along either by using your own spreadsheets and presentations or by watching how I use the exercise files. Let's get started.
- 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.