Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Provider Logo

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

via LinkedIn Learning

Overview

Learn to create information-rich, visually compelling PowerPoint presentations driven by Excel data.

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.

Syllabus

Introduction
  • Create information-rich, visually compelling presentations
  • What you need
1. Getting Excel Content into PowerPoint
  • Office themes: The basics
  • Copy and paste content from Excel
  • Link and embed data and objects
  • Create charts and tables in PowerPoint
2. Clean Up and Format Excel Data for Presentations
  • Restore missing data
  • Work with tables
  • Display large values compactly
3. Craft Graphics for Presentations
  • Add a slicer for a table
  • Build an infographic with a picture fill
  • Build a Gantt chart from a stacked bar
  • Create a treemap chart
  • Illustrate trends with sparklines
  • Map geospatial data with a filled map
4. Highlight Data with Conditional Formatting
  • Highlight high-value cells
  • Use data bars
5. Summarize Details with Pivots
  • Create a PivotTable
  • Format a PivotTable
  • Create a PivotChart
  • Review and format Excel objects
6. Finalize in PowerPoint
  • Paste Excel content into PowerPoint
  • Use the PowerPoint Designer
  • Animate a chart
  • Options for animating tables
  • Linking to a table or chart
Conclusion
  • Next steps

Taught by

Gini von Courter

Related Courses

Reviews

0.0 rating, based on 0 reviews

Start your review of Data-Driven Presentations with Excel and PowerPoint (365/2019)

Never stop learning Never Stop Learning!

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free