YoVDO

Data-Driven Presentations with Excel and PowerPoint 2013

Offered By: LinkedIn Learning

Tags

Microsoft Excel Courses Presentation Skills Courses PivotTables Courses SmartArt Courses

Course Description

Overview

Drive your PowerPoint presentations with Excel data.

Syllabus

Introduction
  • Welcome
  • What you should know before watching this course
  • Using the exercise files
1. Data-Driven Presentations: The Basics
  • Creating a data-driven presentation
  • Using Excel data in PowerPoint
  • How themes impact presentation data
2. Formatting Excel Tables for Presentations
  • Formatting a range as a table
  • Setting table options
  • Changing a table to a range
  • Dividing large numbers
3. Highlighting Data with Conditional Formatting
  • Understanding conditional formatting
  • Formatting a cell based on its contents
  • Using data bars
  • Using icon sets
  • Editing a conditional format
4. Using Charts to Illustrate Data
  • Choosing the right chart
  • Creating a pie chart
  • Creating a column chart
  • Building an infographic using a picture fill
  • Creating a 100% chart
  • Creating a combination chart
  • Creating charts in PowerPoint
5. Summarizing with PivotTables and PivotCharts
  • Creating and formatting a PivotTable
  • Filtering items in a PivotTable
  • Creating a PivotChart
6. Taking Excel to PowerPoint
  • Copying data and charts in Excel
  • Pasting charts and tables from the Office Clipboard
  • Linking data and objects
  • Copying tables and pasting pictures
  • Building a data-driven presentation directly in PowerPoint
  • Using sparklines in presentations
7. Using SmartArt in Data-Driven Presentations
  • Creating a SmartArt diagram
  • Repurposing lists as diagrams
  • Creating an organization chart with photos
  • Converting SmartArt to shapes
8. Animating Charts and Data
  • Animating charts
  • Removing animation
  • Focusing your audience with emphasis effects and shapes
  • Modifying animation order
  • Animating SmartArt
  • Animating large tables and objects
9. Finalizing Your Presentation
  • Documenting your presentation
  • Saving your presentation as a template
Conclusion
  • Next steps

Taught by

Gini von Courter

Related Courses

Using Covid-19 Data to Make Supply Chain Logistics Decisions in Spreadsheets
Coursera Project Network via Coursera
Microsoft Excel - Excel from Beginner to Advanced
Udemy
Excel Shortcuts, Excel Tips, Excel Tricks - Excel Skills!
Udemy
Learn Excel 2016 Intermediate Level - Beyond the Basics
Udemy
Microsoft Excel Mastery: From Beginner to Pro
Udemy