Lynda - 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.

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

Table of content:

 

0.       Introduction

            Welcome

            What you should know before watching this course

            Using the exercise files

1.       Data-Driven Presentations: The Basics

            Creating a data-driven presentation

            Using Excel data in PowerPoint

            How themes impact presentation data

2.       Formatting Excel Tables for Presentations

            Formatting a range as a table

            Setting table options

            Changing a table to a range

            Dividing large numbers

3.       Highlighting Data with Conditional Formatting

            Understanding conditional formatting

            Formatting a cell based on its contents

            Using data bars

            Using icon sets

            Editing a conditional format

4.       Using Charts to Illustrate Data

            Choosing the right chart

            Creating a pie chart

            Creating a column chart

            Building an infographic using a picture fill

            Creating a 100% chart

            Creating a combination chart

            Creating charts in PowerPoint

5.       Summarizing with PivotTables and PivotCharts

            Creating and formatting a PivotTable

            Filtering items in a PivotTable

            Creating a PivotChart

6.       Taking Excel to PowerPoint

            Copying data and charts in Excel

            Pasting charts and tables from the Office Clipboard

            Linking data and objects

            Copying tables and pasting pictures

            Building a data-driven presentation directly in PowerPoint

            Using sparklines in presentations

7.       Using SmartArt in Data-Driven Presentations

            Creating a SmartArt diagram

            Repurposing lists as diagrams

            Creating an organization chart with photos

            Converting SmartArt to shapes

8.       Animating Charts and Data

            Animating charts

            Removing animation

            Focusing your audience with emphasis effects and shapes

            Modifying animation order

            Animating SmartArt

            Animating large tables and objects

9.       Finalizing Your Presentation

            Documenting your presentation

            Saving your presentation as a template

Download Links

Fileparadox

1. http://bit.ly/Me6yb2
2. http://bit.ly/1feZQ1y
3. http://bit.ly/1fBpS9W

Cloudzer

1. http://clz.to/ex6e4hjf
2. http://clz.to/ujinjvd7
3. http://clz.to/e7qqcfw0