Description
The Advanced Pivot Table Data Crunching learning experience is designed for daily Excel users who do substantial data analysis. This course will dive deep into Pivot Tables and how to generate even more insights using Excels tools.
This course is structured topically around the built in formula & functions with time spent on building effective formulas, harnessing the power of functions, building business formulas, and using functions to build business models.
Sessions Overview:
Pivot Tables Primer (Sessions 1 – 3)
- Pivot Table Fundamentals
- Customizing Pivot Tables
- Grouping, Sorting & Filtering
Analyzing Data with Pivot Tables (Sessions 4 – 6)
- Performing Calculations in Pivot Tables
- Using Pivot Charts
- Analyzing disparate data sources
Pivot Tables as a Business Tool (Sessions 7 – 13)
- Sharing Dashboards with Power BI
- Using cube formulas & data models
- Data Models & Power Pivot
- Using 3D Maps
- Macros & Pivot Tables
- Visual Basic & Pivot Tables
Pivot Tables Next Level (Sessions 14 – 18)
- Avoid GetPivotData
- Pivot Tables in Excel Online
- Dynamic arrays & Power Query
- Unpivoting in Power Query
Use discount code “BrionHurley” to save 10% OFF
