Module 1: Introduction to PivotTables (Core Concepts & Business Purpose)
Module 2: Understanding Raw Business Data (Granularity, Grain & Tabular Hygiene)
Module 3: Preparing Data for PivotTables (Cleaning, Deduplication & Validation)
Module 4: Excel Tables as PivotTable Sources (Dynamic Expansion & ListObjects)
Module 5: Creating Your First PivotTable (Layout, Fields Pane & Interpretation)
Module 6: PivotTable Field Areas in Detail (Rows, Columns, Values, Filters & Nesting)
Module 7: Value Field Settings (Sum, Count, Average, Min, Max & Distinct Count)
Module 8: Sorting and Filtering PivotTables (Top 10, Label Filters & Value Filters)
Module 9: PivotTable Layout and Formatting (Tabular Form, Styles & Subtotals)
Module 10: PivotTable Foundations Capstone Project (Comprehensive Regional Sales Report)
Module 11: Working with Dates (Grouping, Hierarchies & Fiscal Periods)
Module 12: Time-Based Analysis (Monthly Trends, QoQ, YoY & Pacing)
Module 13: Show Values As (% of Total, Running Totals, Differences & Ranks)
Module 14: Calculated Fields and Items (Syntax, Rules & Limitations)
Module 15: Distinct Counts and Unique Entities (Unique Customers & Invoices)
Module 16: Ranking and Top-N Analysis (Revenue vs Profit Pareto Filters)
Module 17: Variance and Target Analysis (Actual vs Budget & Threshold Formatting)
Module 18: Customer Analysis (Frequency, AOV, Repeat Buyers & Concentration)
Module 19: Product and Category Analysis (Product Mix, Contribution & Margin)
Module 20: Advanced Analysis Capstone Project (Comprehensive Sales Performance Engine)
Module 21: Multiple PivotTable Reports
Module 25: Drill-Down and Details
Module 26: GETPIVOTDATA Function
Module 27: PivotTable Dashboard Design
Module 28: Refresh and Source Management
Module 29: Troubleshooting PivotTables
Module 30: Interactive Dashboard Capstone Project
Module 31: Business Data Grain and Dimensionality
Module 32: Sales Analysis
Module 33: Profit & Margin Analysis
Module 34: Customer & Order Analytics
Module 35: Inventory Analysis
Module 36: Procurement & Supplier Analysis
Module 38: Attendance & Workforce Productivity
Module 39: Finance & Expense Analysis
Module 40: Operations & Production Analytics
Module 41: Project Management Analytics
Module 42: Marketing & Campaign Analytics
Module 43: Customer Service & Support Analytics
Module 44: Reconciliation & Audit Analytics
Module 45: Real-World MIS Reporting Capstone Project
Module 46: Multiple Related Tables
Module 47: Data Model Fundamentals
Module 48: Power Pivot Introduction
Module 49: DAX Fundamentals
Module 50: Advanced Data Model Analysis
Module 51: Power Query for PivotTables
Module 52: Large Dataset Analysis
Module 53: Reporting Automation
Module 54: Advanced Calculations and Modeling
Module 55: Executive Storytelling
Module 56: Capstone Project One: Sales Analytics
Module 57: Capstone Project Two: Inventory & Procurement
Module 58: Capstone Project Three: HR & Attendance
Module 59: Capstone Project Four: Finance & Operations
Module 60: Final Professional Analytics Capstone
