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

Introduction to Computational Finance and Financial Econometrics
University of Washington via Coursera
Excel 2010
Miríadax
The Finance of Retirement & Pensions
Stanford Graduate School of Business via NovoEd
Einführung in die Wahrscheinlichkeitstheorie
Johannes Gutenberg University Mainz via iversity
Introduction to VBA/Excel Programming
Cal Poly Pomona via Open Education by Blackboard