Basic: Excel Fundamentals
Basic: Edit a Workbook
Basic: Basic Formulas
Basic: Basic Formatting
Basic: Insert Objects
Basic: View and Manage Worksheets
Intermediate: Charts
-
Create Charts (4:46)
-
Move and Resize (4:15)
-
Chart Types (2:02)
-
Layout and Style (2:59)
-
Titles and Legends (4:48)
-
Gridlines, Labels, and Data Tables (2:44)
-
Emphasize Chart Data (3:49)
-
Modify Chart Data (3:24)
-
Filter Charts (2:12)
-
Trendlines (4:14)
-
Dual Axis Charts (4:34)
-
Chart Templates (3:04)
-
Sparklines (3:13)
Intermediate: Print and Distribute
Intermediate: Intermediate Formulas
Intermediate: Manage Data
Intermediate: Tables
Intermediate: Intermediate Formatting
Intermediate: Collaborate with Excel
Advanced: PivotTables
-
Create PivotTables (7:46)
-
Add Multiple PivotTable Fields (4:38)
-
Change a PivotTable's Calculation (3:51)
-
Add Calculated Fields (3:25)
-
The GETPIVOTDATA Function (3:00)
-
Filter PivotTables (2:46)
-
Timelines (3:15)
-
PivotTable Layout (2:47)
-
Group Values (2:00)
-
Refresh a PivotTable (3:39)
-
Format a PivotTable (2:25)
Advanced: PivotCharts
Advanced: Troubleshoot Formulas
Advanced: Advanced Formatting
Advanced: Advanced Formulas
Advanced: Analyze Data
Advanced: Macros
