» » » Data-Driven Presentations with Excel and PowerPoint

Information of news
26-10-2013, 16:42

Data-Driven Presentations with Excel and PowerPoint

Category: Tutorials » Other

Data-Driven Presentations with Excel and PowerPoint
Data-Driven Presentations with Excel and PowerPoint
English | .MP4 | Software: Excel 2013, PowerPoint 2013, Office 365 | Duration: 3h 46m | 808 MB
Level: Intermediate | elearning
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 presentationIntroduction

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





Site BBcode/HTML Code:

Tags to an Article: Data, Driven, Presentations, with, Excel

Dear visitor, you went to the site as unregistered user.
We recommend you Sign up or Login to website under your name.
Would you like to leave your comment? Please Login to your account to leave comments. Don't have an account? You can create a free account now.