Module 1: Dashboard Architecture & Real-World MIS Overview
Module 2: Data Preparation, Hygiene & Structural Tabular Layouts
Module 3: Excel Tables (ListObject) & Structured Reference Formulas
Module 4: Foundational Dashboard Aggregations (SUM, COUNT, AVERAGE, IFS Family)
Module 5: Conditional Decision Logic (IF, IFS, AND, OR, IFERROR & SWITCH)
Module 6: Enterprise Lookups (XLOOKUP, INDEX, MATCH & Two-Way Lookups)
Module 7: Modern Dynamic Arrays (FILTER, SORT, UNIQUE, SEQUENCE & Spill Logic)
Module 8: Advanced Conditional Formatting & Exception Visuals
Module 9: Core Business Charting (Clean Visuals, Combo Charts & Formatting)
Module 10: Executive KPI Summary Cards & Metric Design
Module 11: PivotTable Architecture, PivotCache & High-Volume Performance
Module 12: PivotTable Value Field Settings, Custom Calculations & Grouping
Module 13: PivotCharts, Interactive Slicers, Timelines & Report Connections
Module 14: Form Controls vs ActiveX Controls in Excel UI Design
Module 15: Specialized Business Charts (Waterfall, Bullet, Gauge & Treemap)
Module 16: Dynamic Chart Ranges (OFFSET, INDEX & Dynamic Array Charting)
Module 17: Interactive Drill-Down & Tabbed Navigation Interfaces
Module 18: Print Layouts, Paginated Reports & One-Click PDF Generators
Module 19: Security, Worksheet Locking & Governance Architectures
Module 20: Performance Tuning, Calculation Modes & Workbook Optimization
Module 21: Power Query ETL Fundamentals & Modern Data Ingestion
Module 22: Structural Data Transformations, Unpivot & Normalization
Module 23: Multi-File Consolidation & Automated Folder Ingestion
Module 24: Power Pivot, Data Modeling & Star Schema Architecture
Module 25: DAX Fundamentals: Calculated Columns vs Explicit Measures
Module 26: DAX Evaluation Contexts: Row Context, Filter Context & CALCULATE
Module 27: DAX Time Intelligence: YTD, QTD, MTD & Prior Period Variance
Module 28: Advanced Power Query: M Language & Custom Functions
Module 29: Automated Refresh Pipelines, Scheduled Updates & Error Handling
Module 30: Hybrid Reporting: Integrating Power Query, Data Model, Formulas & UI
Module 31: VBA Developer Environment, Security & Macro Recording Architecture
Module 32: VBA Language Foundations: Variables, Data Types & Scope
Module 33: The Excel Object Model Hierarchy: Application, Workbook, Worksheet & Range
Module 34: Control Flow, Logic Gates & High-Performance Loops
Module 35: Dynamic Range Detection, Last Row Engineering & 2D Memory Arrays
Module 36: Reusable Subroutines, Custom Functions (UDFs) & Modular Architecture
Module 37: Interactive UserForms: Data-Entry GUI, Controls & Validation Engines
Module 38: Event-Driven Automation: Worksheet & Workbook Events
Module 39: Automated File Operations, Directory Scanning & Batch Archiving
Module 40: Automated PDF Publishing & Controlled Outlook Email Integration
Module 41: Defensive Programming, Robust Error Handling & Audit Logging
Module 42: Macro Performance Optimization: ScreenUpdating, Calculation & Memory Management
Module 43: External Database Integration: ADO, SQL Server & Transaction Controls
Module 44: Ribbon Customization (XML), Fluent UI & Custom Add-in Deployment (.xlam)
Module 45: Enterprise Application Maintenance, Version Control & Security Audit
Module 46: Capstone Project A: Omni-Channel Executive Sales & Margin Intelligence Dashboard
Module 47: Capstone Project B: Multi-Location Warehouse Inventory & Automated Reorder System
Module 48: Capstone Project C: Human Resources Workforce Attendance & Payroll Engine
Module 49: Capstone Project D: Corporate Financial Budget vs Actual Variance Intelligence Engine
Module 50: Capstone Project E: Automated Multi-Branch MIS Consolidation & PDF Publishing Pipeline
Module 51: Capstone Project F: Enterprise Full-Stack VBA Business Application Suite
