Data-Driven Presentations with Excel and PowerPoint | 600 MB

duration : 3h 46m | Video: AVC (.mp4) 960x540 15fps | Audio: AAC 48KHz 1ch

Genre: eLearning | Level: Appropriate for all | Language: English | released : Oct 17, 2013

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