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

PowerPoint 2016 Foundation Training Course | Office 365
Udemy
The Easiest Beginners Guide to Microsoft Excel
Udemy
PowerPoint 2010 Essential Training
LinkedIn Learning
Microsoft PowerPoint Essentials
The Great Courses Plus
PowerPoint Animations and Video for Online Instructors
Udemy