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 2016

via LinkedIn Learning

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Learn to create information-rich, visually compelling PowerPoint presentations driven by Excel data.

Learn to create information-rich, visually compelling PowerPoint presentations driven by Excel data. The presentations you generate in this course are easy to use, easy to understand, and—best of all—easy to update. Gini von Courter 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. Next, she shows how to use several different methods, including copying and pasting, linking, and embedding, to import your work into PowerPoint. She then shows 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, this course is for you.

Syllabus

Introduction
  • Welcome
  • What you need for this course
  • Using the exercise files
1. Using Copy and Paste with Excel and PowerPoint
  • Office themes: The basics
  • Copy and paste content from Excel
  • Link and embed data and objects
  • Create data and charts directly in PowerPoint
2. Format and Clean Up Excel Data for Presentations
  • Format a range as a table
  • Restore missing data
  • Display large values compactly
3. Dynamic Data: Slicers
  • Add a slicer for a table
  • Set slicer options
4. Create Charts for Presentations
  • Build an infographic with a picture fill
  • Build a Gantt Chart from a stacked bar
  • Illustrate trends with sparklines
5. Highlight Data with Conditional Formatting
  • Highlight high-value cells
  • Use data bars
6. Summarize Data with PivotTables
  • Create and format a PivotTable
  • Add a timeline for the PivotTable
  • Use other summary functions
  • Create a PivotChart
  • Format elements for the presentation
7. Finalize in PowerPoint
  • Paste Excel elements into PowerPoint
  • Animate a chart
  • Options for animating tables
Conclusion
  • Next steps

Taught by

Gini von Courter

Reviews

Start your review of Data-Driven Presentations with Excel and PowerPoint 2016

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.