Data-Driven Presentations with Excel and PowerPoint (365/2019)

1h 45mIntermediate2020-09-28

Authors

Gini von Courter

Teaching computer classes on Microsoft Office for 20+ years

Course details

Learn how to create high-impact, data-rich presentations using PowerPoint and Excel together. Follow along with Gini von Courter as she shows how to create presentations that are easy to use, easy to understand, and—best of all—easy to update. It all starts in Excel. Gini begins with an example spreadsheet featuring typical business data. She uses conditional formatting to highlight important information, PivotTables to summarize data, and sparklines and charts to create illustrations. She also shows how to use several different methods, including copying and pasting, linking, and embedding, to import your work into PowerPoint. She then demonstrates how to use PowerPoint animation features to animate Excel charts and tables and focus the viewer's attention. If you've wondered how to create expressive but low-maintenance presentations to showcase your data—no matter how often it changes—this course is for you.

Topics include:
Copying and pasting content
Linking and embedding data and objects
Formatting Excel data
Building an infographic
Illustrating trends with sparklines
Highlighting data with conditional formatting
Summarizing data with PivotTables and PivotCharts
Finalizing your presentation in PowerPoint
Animating charts and tables

Skills covered

PowerPointMicrosoft OfficePresentationsOffice 365SpreadsheetsMicrosoft ExcelBusiness Software and ToolsMicrosoftDeep Dive (X:Y)

Concepts

0. Introduction

01 - Create information-rich, visually compelling presentations
02 - What you need

1. Getting Excel Content into PowerPoint

03 - Office themes - The basics
04 - Copy and paste content from Excel
05 - Link and embed data and objects
06 - Create charts and tables in PowerPoint

2. Clean Up and Format Excel Data for Presentations

07 - Restore missing data
08 - Work with tables
09 - Display large values compactly

3. Craft Graphics for Presentations

10 - Add a slicer for a table
11 - Build an infographic with a picture fill
12 - Build a Gantt chart from a stacked bar
13 - Create a treemap chart
14 - Illustrate trends with sparklines
15 - Map geospatial data with a filled map

4. Highlight Data with Conditional Formatting

16 - Highlight high-value cells
17 - Use data bars

5. Summarize Details with Pivots

18 - Create a PivotTable
19 - Format a PivotTable
20 - Create a PivotChart
21 - Review and format Excel objects

6. Finalize in PowerPoint

22 - Paste Excel content into PowerPoint
23 - Use the PowerPoint Designer
24 - Animate a chart
25 - Options for animating tables
26 - Linking to a table or chart

Conclusion

27 - Next steps