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

Go to class
Write Review

Free Online Course: Data-Driven Presentations with Excel and PowerPoint (365/2019) provided by LinkedIn Learning is a comprehensive online course, which lasts for 1-2 hours worth of material. The course is taught in English and is free of charge. Upon completion of the course, you can receive an e-certificate from LinkedIn Learning. Data-Driven Presentations with Excel and PowerPoint (365/2019) is taught by Gini von Courter.

Overview
  • 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