Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Learn Microsoft Excel 2010 Advanced Course
Chapter 1 - Basic Steps for Charts & Graphs
Introduction to Advanced Excel 2010 (3:10)
Four Basic Steps When Creating Charts/Graphs (10:58)
Additional Features to Help Create Charts/Graphs (14:56)
Additional Features to Help Create Charts/Graphs Part 2 (14:28)
Chapter 2 - Layout Tab
Detailed Formatting for Charts/Graphs (13:03)
Formatting Legends within Charts/Graphs (14:48)
Formatting Axes and Gridlines within Charts/Graphs (15:47)
Chapter 3 - Trends
Trends within Charts and Graphs (11:24)
Complex Trends within Charts and Graphs (14:41)
Trends over Time within Charts and Graphs (15:28)
Chapter 4 - Differences
Showing Differences Using Bar Charts (15:11)
Showing Differences Using Pie Charts (15:30)
Limitations with Pie Charts & How to Correct (16:20)
Alternative Ways to Show Differences (13:28)
Chapter 5 - Relationships
Using Charts & Graphs to Show Relationships (15:23)
Using Charts & Graphs to Show Relationships Part 2 (15:34)
Chapter 6 - Stock
Charting & Graphing Financial Information (15:15)
Charting & Graphing Financial Information Part 2 (11:06)
Specific Charts for Finance Information (14:36)
Setting Up Live Charts (14:38)
Chapter 7 - Sparklines
Using Sparklines for Data Visualization (14:26)
Chapter 8 - Data Bars
Using and Formatting Data Bars, Color Scales & Icon Sets (17:08)
Chapter 9 - Pivot Tables
Setting Up Pivot Tables/Charts (14:32)
Setting Up Pivot Tables/Charts Part 2 (14:30)
Filtering Pivot Tables/Charts (13:04)
New Features for PIvot Tables/Charts (13:20)
Chapter 10 - Graphics
Graphics Tools (15:07)
Graphics Tools Part 2 (13:32)
Chapter 11 - Exporting
Exporting Charts and Graphs (15:09)
Exporting Charts and Graphs Part 2 (14:59)
Course Quiz and Certificate of Completion
Additional Features to Help Create Charts/Graphs
Complete and Continue