Course curriculum
-
1
Welcome to the course!
- Instructor bio - John Bura
- Key pointers for this program
- Joining the Alumni Community
-
2
Introduction to the Course
- Segment - 01 - Introduction to the Course
- Segment - 02 - Why should you learn Pivot Tables
- Segment - 03 - Introduction of the Instructor
- Segment - 04 - Course Requirements (what software, experience)
- Source File
-
3
PivotTables Fundamental Projects
- Segment - 05 - What will we learn in this section
- Segment - 06 - What is a Pivot Table
- Segment - 07 - Pivot Table Basics
- Segment - 08 - Pivot Table Compilant Data Sources
- Segment - 09 - Build a Basic Pivot Table
- Segment - 10 - Section Summary
- Segment - 11 - Challenge
- Source File
-
4
Format Pivot Tables
- Segment - 12 - What will we learn in this section
- Segment - 13 - Introduction to Formatting Pivot Tables
- Segment - 14 - Build an Expense Report
- Segment - 15 - Format the Expense Report Pivot Table
- Segment - 16 - Finalize the Expense Report Pivot Table
- Segment - 17 - Section Summary
- Segment - 18 - Challenge
- Source File
-
5
Excel Tables
- Segment - 19 - What will we learn in this section
- Segment - 20 - What are Excel Tables
- Segment - 21 - Sales Report Analysis
- Segment - 22 - Complete the Sales Report Analysis
- Segment - 23 - Format the Sales Report
- Segment - 24 - Modify Source Data
- Segment - 25 - Section Summary
- Segment - 26 - Challenge
- Source File
-
6
Slice and Dice Your Data
- Segment - 27 - What will we learn in this section
- Segment - 28 - What is Slicing Data
- Segment - 29 - Slicing Data Project
- Segment - 30 - Data Slicer Tools
- Segment - 31 - Links Slicer to Multiple Pivot Tables
- Segment - 32 - Section Summary
- Segment - 33 - Challenge
- Source File
-
7
Connect to Databases
- Segment - 34 - What will we learn in this section
- Segment - 35 - Connect to Databases
- Segment - 36 - Import Data Sources
- Segment - 37 - Use Pivot Tables to Refine Data
- Segment - 38 - Consolidate your Data Table
- Segment - 39 - Format Large Data Sets
- Segment - 40 - Slicer and Timeline in Large Data Sets
- Segment - 41 - Refresh and Drill Down from Databases
- Segment - 42 - Section Summary
- Segment - 43 - Challenge
- Source File