Data-Driven Presentations with Excel and PowerPoint

with Gini Courter
please wait ...
Data-Driven Presentations with Excel and PowerPoint
Video duration: 0s 3h 46m Intermediate

Viewers:

Learn how to drive your Microsoft PowerPoint presentations with data straight from the source—Excel. Gini Courter first shows you how to use conditional formatting to highlight important data, summarize data with PivotTables, and visualize your data with sparklines and charts. Then learn how to leverage the linking and embedding features of Office to bring Excel tables and charts into PowerPoint. Gini then uses SmartArt to provide a conceptual framework in PowerPoint and animates the results. Finally, learn to create links from PowerPoint to Excel to fire up a workbook directly from a presentation. If you've wondered how to create compelling, data-driven presentations that always stay up to date, this course is for you.

Topics include:
  • Using Excel themes
  • Formatting tables
  • Highlighting data with conditional formatting
  • Creating pie, column, and combination charts
  • Creating PivotTables
  • Pasting and linking charts and tables
  • Creating SmartArt diagrams
  • Animating charts, tables, and SmartArt
  • Finalizing your presentation
Subjects:
Business IT
Software:
Excel PowerPoint Office 365
Author:

Welcome

- [Voiceover] Welcome to Data Driven Presentations with Excel and Powerpoint. In this course, I'm going show you how to use Excel data to drive your Powerpoint presentations. We'll begin with some typical organizational data that we have stored in Excel and use conditional formatting and other tools to highlight important data, pivot tables to summarize data, and spark lines and charts to create various illustrations. We'll leverage the linking and embedding features of Office to copy our Excel tables and charts, and paste them into PowerPoint.

We'll use some SmartArt, a tool available in both applications, to provide a conceptual framework, and we'll use Powerpoint's animation features to animate all of this. Finally, we'll create some links from Powerpoint directly to Excel, so you can see how to fire up a workbook directly in the middle of a presentation. If you've ever wondered how to create compelling presentations that don't take quite as much to maintain as you might imagine, then I've designed this course for you. Let's get started.

please wait ...