Module 1: Introduction to Modern Excel
Module 2: Excel Tables and Structured References
Module 3: Data Types and Data Quality
Module 4: Modern Excel Data Management
Module 5: Formula Foundations
Module 6: Modern Logical Functions
Module 7: Modern Aggregation Functions
Module 8: Modern Lookup Functions
Module 9: Modern Text Functions
Module 10: Modern Date and Time Functions
Module 11: Error Handling and Formula Auditing
Module 12: Excel Data Preparation Project
Module 13: Dynamic Array Fundamentals
Module 14: FILTER Function
Module 15: SORT and SORTBY
Module 16: UNIQUE Function
Module 17: TAKE, DROP, CHOOSECOLS and CHOOSEROWS
Module 18: VSTACK, HSTACK, TOROW and TOCOL
Module 19: EXPAND, WRAPROWS, WRAPCOLS and Array Utilities
Module 21: LAMBDA Custom Functions
Module 22: MAP, REDUCE, SCAN and MAKEARRAY
Module 23: BYROW and BYCOL
Module 24: Dynamic Formula Engineering
Module 25: Modern Formula-Based Reporting Project
Module 26: Introduction to Power Query
Module 27: Power Query Editor Interface
Module 28: Importing Data from Excel
Module 29: Importing CSV and Text Files
Module 30: Importing Data from Folders
Module 31: Power Query Data Types
Module 32: Removing Unnecessary Data
Module 33: Filtering and Sorting in Power Query
Module 34: Text Transformation
Module 35: Number and Date Transformation
Module 36: Fill, Replace, Group and Aggregate
Module 37: Pivot and Unpivot
Module 39: Append Queries
Module 40: Power Query Fundamentals Project
Module 41: M Language Fundamentals
Module 42: M Data Structures and Types
Module 43: M Functions and Parameters
Module 44: Advanced Table Transformations
Module 45: List and Record Operations
Module 46: Custom Columns and Conditional Logic
Module 47: Custom Reusable Power Query Functions
Module 48: Dynamic File and Folder Pipelines
Module 49: Parameters and Configuration
Module 50: Web and External Data Sources
Module 51: Error Handling and Data Quality
Module 52: Query Folding and Performance
Module 53: Privacy, Credentials and Data Sources
Module 54: Refresh, Dependencies and Maintenance
Module 55: Advanced Power Query Project
Module 56: Power Query with Modern Excel Formulas
Module 57: Power Query with PivotTables and Dashboards
Module 58: Power Pivot, Data Model and DAX Introduction
Module 59: Modern Excel Automation Ecosystem
Module 60: Office Scripts Fundamentals
Module 61: Power Automate and Excel Integration
Module 62: Refreshable Business Reporting System
Module 63: Sales and Inventory Analytics Project
Module 64: Finance and HR Reporting Project
Module 65: Final Enterprise-Style Capstone
