2013
Lynda
Gini Courter
3h 46m
English
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.
Introduction 5m 42s
Welcome 1m 6s
What you should know before watching this course 2m 20s
Using the exercise files 2m 16s
1. Data-Driven Presentations: The Basics 18m 21s
Creating a data-driven presentation 2m 11s
Using Excel data in PowerPoint 8m 47s
How themes impact presentation data 7m 23s
2. Formatting Excel Tables for Presentations 18m 49s
Formatting a range as a table 8m 57s
Setting table options 3m 53s
Changing a table to a range 2m 47s
Dividing large numbers 3m 12s
3. Highlighting Data with Conditional Formatting 28m 6s
Understanding conditional formatting 2m 41s
Formatting a cell based on its contents 7m 21s
Using data bars 4m 47s
Using icon sets 4m 50s
Editing a conditional format 8m 27s
4. Using Charts to Illustrate Data 33m 37s
Choosing the right chart 7m 4s
Creating a pie chart 2m 52s
Creating a column chart 4m 34s
Building an infographic using a picture fill 5m 39s
Creating a 100% chart 3m 54s
Creating a combination chart 2m 27s
Creating charts in PowerPoint 7m 7s
5. Summarizing with PivotTables and PivotCharts 14m 1s
Creating and formatting a PivotTable 6m 45s
Filtering items in a PivotTable 2m 17s
Creating a PivotChart 4m 59s
6. Taking Excel to PowerPoint 41m 20s
Copying data and charts in Excel 5m 50s
Pasting charts and tables from the Office Clipboard 6m 24s
Linking data and objects 8m 42s
Copying tables and pasting pictures 7m 44s
Building a data-driven presentation directly in PowerPoint 7m 40s
Using sparklines in presentations 5m 0s
7. Using SmartArt in Data-Driven Presentations 21m 15s
Creating a SmartArt diagram 3m 37s
Repurposing lists as diagrams 1m 58s
Creating an organization chart with photos 3m 40s
Converting SmartArt to shapes 12m 0s
8. Animating Charts and Data 35m 34s
Animating charts 8m 11s
Removing animation 1m 7s
Focusing your audience with emphasis effects and shapes 7m 25s
Modifying animation order 1m 16s
Animating SmartArt 8m 11s
Animating large tables and objects 9m 24s
9. Finalizing Your Presentation 8m 3s
Documenting your presentation 4m 20s
Saving your presentation as a template 3m 43s
Conclusion 1m 49s
Next steps 1m 49s
www.lynda.com/Excel-tutorials/Data-Driven-Presentations-Excel-PowerPoint/139994-2.html
Download File Size:791.96 MB
|
