Level 3 · Advanced
Excel Mastery
Advanced Excel skills
Go deep on PivotTables, Power Query, the data model and modern formulas, then automate the work you repeat every month.
Log in to open this level
Students log in to see their lessons and progress.
What is inside
1PivotTables in depth0/5
- M-1-1Layout, design and report optionsComing soon
- M-1-2Show values as and value field settingsComing soon
- M-1-3Grouping and calculated fieldsComing soon
- M-1-4Slicers and timelinesComing soon
- M-1-5Refreshing and managing large sourcesComing soon
2Advanced charts0/5
- M-2-1Combination charts and secondary axesComing soon
- M-2-2Designing charts for clarityComing soon
- M-2-3Dynamic charts driven by tablesComing soon
- M-2-4PivotChartsComing soon
- M-2-5Waterfall, funnel and map chartsComing soon
3Modern formulas0/5
- M-3-1LET: name your calculationsComing soon
- M-3-2LAMBDA and custom functionsComing soon
- M-3-3MAP, REDUCE, BYROW and BYCOLComing soon
- M-3-4GROUPBY and PIVOTBYComing soon
- M-3-5Legacy array formulas you will still meetComing soon
4Auditing and speed0/5
- M-4-1Tracing precedents and dependentsComing soon
- M-4-2Evaluate Formula and common error patternsComing soon
- M-4-3Calculation modes and slow workbooksComing soon
- M-4-4Documenting a modelComing soon
- M-4-5Reviewing an inherited workbookComing soon
5Power Query0/5
- M-5-1Connecting to files, folders and the webComing soon
- M-5-2Cleaning and shaping dataComing soon
- M-5-3Merging and appending queriesComing soon
- M-5-4Unpivoting and reshapingComing soon
- M-5-5Parameters and refreshingComing soon
6The data model and Power Pivot0/5
- M-6-1Why use a data modelComing soon
- M-6-2Building relationshipsComing soon
- M-6-3DAX measuresComing soon
- M-6-4Time intelligence basicsComing soon
- M-6-5PivotTables built on the data modelComing soon
7Automating with macros and scripts0/5
- M-7-1Recording a macroComing soon
- M-7-2Reading and editing recorded codeComing soon
- M-7-3Office Scripts for Excel on the webComing soon
- M-7-4Power Automate flows with ExcelComing soon
- M-7-5Macro security and sharingComing soon
8VBA foundations0/5
- M-8-1The VBA editorComing soon
- M-8-2Variables, conditions and loopsComing soon
- M-8-3Working with ranges and worksheetsComing soon
- M-8-4Debugging and error handlingComing soon
- M-8-5Project: a one click monthly reportComing soon