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
4.3 Sales Report Analysis With Pivottables
Lesson content will be unlocked within 30 minutes.
Teachable is working on this bug.
No further action will be required on your part
.
Thank you for your patience