Data-Driven Presentations with Excel and PowerPoint 2013

Introduction

• Welcome
• What you should know before watching this course
• Using the exercise files

1. Data-Driven Presentations: The Basics

• Creating a data-driven presentation
• Using Excel data in PowerPoint
• How themes impact presentation data

2. Formatting Excel Tables for Presentations

• Formatting a range as a table
• Setting table options
• Changing a table to a range
• Dividing large numbers

3. Highlighting Data with Conditional Formatting

• Understanding conditional formatting
• Formatting a cell based on its contents
• Using data bars
• Using icon sets
• Editing a conditional format

4. Using Charts to Illustrate Data

• Choosing the right chart
• Creating a pie chart
• Creating a column chart
• Building an infographic using a picture fill
• Creating a 100% chart
• Creating a combination chart
• Creating charts in PowerPoint

5. Summarizing with PivotTables and PivotCharts

• Creating and formatting a PivotTable
• Filtering items in a PivotTable
• Creating a PivotChart

6. Taking Excel to PowerPoint

• Copying data and charts in Excel
• Pasting charts and tables from the Office Clipboard
• Linking data and objects
• Copying tables and pasting pictures
• Building a data-driven presentation directly in PowerPoint
• Using sparklines in presentations

7. Using SmartArt in Data-Driven Presentations

• Creating a SmartArt diagram
• Repurposing lists as diagrams
• Creating an organization chart with photos
• Converting SmartArt to shapes

8. Animating Charts and Data

• Animating charts
• Removing animation
• Focusing your audience with emphasis effects and shapes
• Modifying animation order
• Animating SmartArt
• Animating large tables and objects

9. Finalizing Your Presentation

• Documenting your presentation
• Saving your presentation as a template

Conclusion

• Next steps