Join Gini von Courter for an in-depth discussion in this video What you need for this course, part of Data-Driven Presentations with Excel and PowerPoint 2016.
- [Instructor] You don't need to be an Excel or PowerPoint guru to benefit from this course, but there are a few prerequisites if you plan to work along with me. In Excel, you should know how to create and save a workbook. You should know how to format cells, text formatting, but also numeric formatting and borders and shading. You should feel comfortable selecting, copying and pasting ranges of cells. You should also know how to sort and filter data in a table.
And you should know how to create basic charts, whether it's a pie chart, a line or a column chart. If you're comfortable creating any of these charts, you have the Excel skills you'll need in this course. In PowerPoint, you should be able to create a basic presentation with text on slides, then apply a design to the presentation. You should also know how to insert objects, like pictures, smart art or charts. I also assume that you know the basics of PowerPoint animation. You should also be comfortable copying and pasting objects or text from one slide to another, and copying and pasting entire slides, as well.
These are the skills you need for Excel or PowerPoint. If at any point during or before the course, you need a refresher on any of these topics, check out the Essential Training courses for Excel and PowerPoint, then return to this course on Data Driven Presentations.
- 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.