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

LinkedIn Learning

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

via LinkedIn Learning

Overview

Prepare for a new career with $100 off Coursera Plus
Gear up for jobs in high-demand fields: data analytics, digital marketing, and more.
Learn to create information-rich, visually compelling PowerPoint presentations driven by Excel data.

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

Reviews

4.7 rating at LinkedIn Learning based on 364 ratings

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

Never Stop Learning.

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

Someone learning on their laptop while sitting on the floor.