Learn special tricks in Excel and PowerPoint designed specifically for presenting to "numbers people".
What you'll learn
Requirements
Basic knowledge of PowerPoint and Excel is recommended.
Description
This course is designed for individuals who want to combine the data analysis tools of Microsoft Excel with the presentation capabilities of Microsoft PowerPoint. You will learn how to uncover the key values for your business, turn those values into well designed, user friendly charts, and incorporate those charts into a professional PowerPoint Presentation. Make your next financial presentation easier and clearer.
Overview
Section 1: MS Office Topics
Lecture 1 Course Topics & Exercise Files
Lecture 2 Automatic Subtotals
Lecture 3 Pivot Tables
Lecture 4 Pivot Charts
Lecture 5 Proper Chart Selection
Lecture 6 Creating Data Charts
Lecture 7 Formatting Charts
Lecture 8 Conditional Formatting
Lecture 9 Inserting Sparklines
Lecture 10 Linking Excel Charts in PowerPoint
Lecture 11 Animating Charts
Anyone who presents data.
Screenshots