Gini von Courter – Data-Driven Presentations with Excel and PowerPoint 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.

Contents:

Introduction

1. Data-Driven Presentations: The Basics

2. Formatting Excel Tables for Presentations

3. Highlighting Data with Conditional Formatting

4. Using Charts to Illustrate Data

5. Summarizing with PivotTables and PivotCharts

6. Taking Excel to PowerPoint

7. Using SmartArt in Data-Driven Presentations

8. Animating Charts and Data

9. Finalizing Your Presentation

Conclusion

Author:

Gini von Courter has taught computer classes on Microsoft Office for 20+ years and has authored 30+ books.

Gini has been providing computer classes and seminars on Microsoft Office and related products for more than 20 years at public and private companies, state and federal agencies, educational institutions, and not-for-profit organizations, and has consulted and trained on the use of Microsoft SharePoint since the first SharePoint product was launched in 2001. A founder and managing partner of TRIAD Consulting, Gini is also the author of books such as Beginning SharePoint with Excel, as well as a number of lynda.com movies on SharePoint, SharePoint Designer, InfoPath, and other software titles. Gini’s passion is helping clients use SharePoint and Microsoft Office applications to create solutions that increase efficiency and collaboration while improving the quality of people’s work lives. She is a graduate of the University of Michigan with an M.B.A. from Oakland University.