Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Introduction to PivotTables in Excel
Intro to Mammoth Interactive
00 About Mammoth Interactive (1:05)
01 How to Learn Online Effectively (13:39)
01. Introduction to the Course
1.1 Introduction To The Course (3:43)
1.2 Why Should You Learn Pivottables (3:17)
1.3 Introduction Of The Instructor (3:17)
1.4 Course Requirements (what Software, Experience) (6:10)
01 Source Files
02. PivotTables Fundamental Projects
2.1 What We Learn In This Section (1:21)
2.2 What Is A Pivot Table (2:01)
2.3 Pivottables Basics (2:52)
2.4 Pivottable Compliant Data Sources (2:12)
2.5 Build A Basic Pivottable (4:17)
2.6 Section Summary (2:12)
2.7 Challenge (1:23)
02 Source Files
03. Format PivotTables
3.1 What Will We Learn In This Section (1:01)
3.2 Introduction To Formatting Pivottables (3:29)
3.3 Build An Expense Report (6:03)
3.4 Format The Expense Report Pivottable (4:18)
3.5 Finalize The Expense Report Pivottable (5:40)
3.6 Section Summary (2:12)
3.7 Challenge (1:04)
03 Source Files
04. Excel Tables
4.1 What Will We Learn In This Section (8:45)
4.2 What Are Excel Tables (7:23)
4.3 Sales Report Analysis With Pivottables (9:21)
4.4 Modify Source Data (3:58)
4.5 Format The Sales Report (8:38)
4.6 Complete The Sales Report Analysis (3:38)
4.7 Section Summary (3:03)
4.8 Challenge (1:46)
04 Source Files
05. Slice and Dice Your Data
5.1 What Will We Learn In This Section (1:23)
5.2 What Is Slicing Data (3:41)
5.3 Slicing Data Project (5:40)
5.4 Data Slicer Tools (14:09)
5.5 Link Slicers To Multiple Pivottables (8:03)
5.6 Section Summary (2:32)
5.7 Challenge (2:04)
05 Source Files
06. Connect to Databases
6.1 What Will We Learn In This Section (2:30)
6.2 Connect To Databases (2:06)
6.3 Import Data Sources (3:58)
6.4 Use Pivottables To Refine Data (4:41)
6.5 Consolidate Your Data Table (3:17)
6.6 Format Large Data Sets (4:51)
6.7 Slicer And Timeline In Large Data Sets (4:36)
6.8 Refresh And Drill Down From Databases (4:46)
6.9 Section Summary (4:01)
6.10 Challenge (2:01)
06 Source Files
1.2 Why Should You Learn Pivottables
Complete and Continue