Data-Driven Presentations with Excel and PowerPoint 2013
Offered By: LinkedIn Learning
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
- Creating a data-driven presentation
- Using Excel data in PowerPoint
- How themes impact presentation data
- Formatting a range as a table
- Setting table options
- Changing a table to a range
- Dividing large numbers
- Understanding conditional formatting
- Formatting a cell based on its contents
- Using data bars
- Using icon sets
- Editing a conditional format
- 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
- Creating and formatting a PivotTable
- Filtering items in a PivotTable
- Creating a PivotChart
- 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
- Creating a SmartArt diagram
- Repurposing lists as diagrams
- Creating an organization chart with photos
- Converting SmartArt to shapes
- Animating charts
- Removing animation
- Focusing your audience with emphasis effects and shapes
- Modifying animation order
- Animating SmartArt
- Animating large tables and objects
- Documenting your presentation
- Saving your presentation as a template
- Next steps
Taught by
Gini von Courter
Related Courses
Using Covid-19 Data to Make Supply Chain Logistics Decisions in SpreadsheetsCoursera Project Network via Coursera Analyze Data with Microsoft Excel
Codecademy Conditional Formatting, Tables and Charts in Microsoft Excel
Coursera Project Network via Coursera Data for Business Analysts Using Microsoft Excel
Microsoft via Coursera Create Charts and Dashboards Using Microsoft Excel
Coursera Project Network via Coursera