Excel Reporting Mastery
Course Content
1 Welcome Video
-
1.1 Welcome Video
00:00 -
1.2 Setup Instructions
00:00
2 Reporting Foundations
-
2.1 Loading Data
00:00 -
2.2 Cleaning Raw Data – Excel
00:00 -
2.3 Cleaning Raw Data – Power Query M
00:00 -
2.4 Excel Table Foundations
00:00 -
2.5 Excel Table Row Formulas
00:00 -
2.6 Fixed Cell Refence Vs. Dynamic Cell Reference
00:00 -
2.7 Named Ranges
00:00
3 Lookups
-
3.1 Why Lookups are Key
00:00 -
3.2 Vlookups
00:00 -
3.3 Limitation of Lookups
00:00 -
3.4 IndexMatchLookup
00:00 -
3.5 Handling Errors in Lookups
00:00 -
3.6 Xlookup
00:00
4 Aggregate Functions
-
4.1 Why we aggregate data
00:00 -
4.2 Sum IF
00:00 -
4.3 SUM IFS
00:00 -
4.4 CountIfCountIfs
00:00 -
4.5 AverageIfAverageIfs
00:00 -
4.6 Operators Video
00:00
5 Build a Full Reporting Table
-
5.1 If
00:00 -
5.2 Ifs
00:00 -
5.3 IfAndOr
00:00 -
5.4 Put it All Together
00:00 -
5.5 Pros and Cons
00:00
6 Conditional Formatting
-
6.1 Why Conditional Formatting Matters
00:00 -
6.2 Core Conditional Formatting Rules
00:00 -
6.3 Formula-Based Conditional Formatting for Dynamic Insights and Best practices
00:00
7 Dropdown Interactivity
-
7.1 From Static Reports to Dynamic, User-Driven Reporting
00:00 -
7.2 Creating Controlled Inputs with Dropdowns
00:00 -
7.3 Where this approach works and where it breaks
00:00
7 Pivot Table Fundamentals
-
7.1 What are Pivot Tables
00:00 -
7.2 Building First Pivot Table
-
7.3 How Pivot Tables Work + Core Features
00:00 -
7.4 Rapid Aggregation
00:00 -
7.5 Grouping Data (Dates & Categories)
00:00 -
7.6 Basic Design
00:00 -
7.7 Pros and Cons
00:00
8 Pivot table Advanced
-
8.1 Pivot table analysis on multiple tables – data model
00:00 -
8.2 Pivot tables Multiple Tables
00:00 -
8.3 Why Pivot Tales Break – Choosing Fields for Rows, Columns and Filters
00:00 -
8.4 Slicers
00:00 -
8.5 Timelines
00:00
10 Pivot Tables – Power Pivot
-
10.1 Introduction to Power Pivot DAX
00:00 -
10.2 Measures
00:00 -
10.3 Sum Vs SumX
00:00 -
10.4 Introduction to Calculate Module
00:00 -
10.5 Calculate Filter Function
00:00 -
10.6 Calculate All Function
00:00 -
10.7 Working With Dates
00:00 -
10.8 Date Function
00:00 -
10.9 Date Function Continued
00:00