Data-Driven Presentations with Excel and PowerPoint
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.
- 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
- [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.
Developing Cross-Cultural Intelligence28,057 Views
Excel 2010: Pivot Tables in Depth1,366,390 Views
How to Start a Business with Family and Friends47,742 Views
Moodle 3.0 First Look10,116 Views
Capturing Audio for Video 03: Real World Solutions6,419 Views
Illustrator CC 2013 One-on-One: Fundamentals1,678,359 Views
Excel 2013 Essential Training6,279,953 Views
Access 2013 Essential Training2,711,788 Views
Illustrator CC 2013 One-on-One: Mastery302,647 Views
Excel 2013: Pivot Tables in Depth1,335,480 Views