fbpx

Advanced Pivot Table Data Crunching

$750.00

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.

Category:

Description

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

Note:

If the number of participants does not reach 10, the money will be returned to you, as we cannot start with fewer participants.

Copyright © 2024 CreateMyExcel.

Close