Skip to main content
Excel TrickyTricks Structured 7-level spreadsheet mastery with real-world practice workbooks and verifiable credentials.
Curriculum
AI & Labs
Company & Legal
© Excel Tricky Tricks. All rights reserved.
Cookie settings Choose which optional cookies you allow. Necessary cookies are always on because the site cannot work without them.
Strictly necessary Security, sign-in state, language, and your cookie choice. Always on. Always on Analytics Helps us understand which lessons and pages are useful. Off by default. Marketing Allows measurement of campaigns. Off by default.
Save choices
Level 7: Dashboards and Automation Build dashboards, automate tasks with VBA and Office Scripts, and complete projects.
1 course 51 modules 198 lessons Courses in this level 1 of 1 course
Level 7 Dashboards
Master Excel dashboard architecture, business reporting, KPI metrics, dynamic arrays, Power Query ETL pipelines, Power Pivot star schemas, and full-stack VBA automation with 6 comprehensive real-world capstone projects.
Show 51 modules — Excel Dashboards & Automation: Complete Basic to Advanced (Hinglish) 1 Module 1: Dashboard Architecture & Real-World MIS Overview 4 lessons 2 Module 2: Data Preparation, Hygiene & Structural Tabular Layouts
4 lessons
3 Module 3: Excel Tables (ListObject) & Structured Reference Formulas 4 lessons
4 Module 4: Foundational Dashboard Aggregations (SUM, COUNT, AVERAGE, IFS Family) 4 lessons
5 Module 5: Conditional Decision Logic (IF, IFS, AND, OR, IFERROR & SWITCH) 4 lessons
6 Module 6: Enterprise Lookups (XLOOKUP, INDEX, MATCH & Two-Way Lookups) 4 lessons
7 Module 7: Modern Dynamic Arrays (FILTER, SORT, UNIQUE, SEQUENCE & Spill Logic) 4 lessons
8 Module 8: Advanced Conditional Formatting & Exception Visuals 4 lessons
9 Module 9: Core Business Charting (Clean Visuals, Combo Charts & Formatting) 4 lessons
10 Module 10: Executive KPI Summary Cards & Metric Design 4 lessons
11 Module 11: PivotTable Architecture, PivotCache & High-Volume Performance 4 lessons
12 Module 12: PivotTable Value Field Settings, Custom Calculations & Grouping 4 lessons
13 Module 13: PivotCharts, Interactive Slicers, Timelines & Report Connections 4 lessons
14 Module 14: Form Controls vs ActiveX Controls in Excel UI Design 4 lessons
15 Module 15: Specialized Business Charts (Waterfall, Bullet, Gauge & Treemap) 4 lessons
16 Module 16: Dynamic Chart Ranges (OFFSET, INDEX & Dynamic Array Charting) 4 lessons
17 Module 17: Interactive Drill-Down & Tabbed Navigation Interfaces 4 lessons
18 Module 18: Print Layouts, Paginated Reports & One-Click PDF Generators 4 lessons
19 Module 19: Security, Worksheet Locking & Governance Architectures 4 lessons
20 Module 20: Performance Tuning, Calculation Modes & Workbook Optimization 4 lessons
21 Module 21: Power Query ETL Fundamentals & Modern Data Ingestion 4 lessons
22 Module 22: Structural Data Transformations, Unpivot & Normalization 4 lessons
23 Module 23: Multi-File Consolidation & Automated Folder Ingestion 4 lessons
24 Module 24: Power Pivot, Data Modeling & Star Schema Architecture 4 lessons
25 Module 25: DAX Fundamentals: Calculated Columns vs Explicit Measures 4 lessons
26 Module 26: DAX Evaluation Contexts: Row Context, Filter Context & CALCULATE 4 lessons
27 Module 27: DAX Time Intelligence: YTD, QTD, MTD & Prior Period Variance 4 lessons
28 Module 28: Advanced Power Query: M Language & Custom Functions 4 lessons
29 Module 29: Automated Refresh Pipelines, Scheduled Updates & Error Handling 4 lessons
30 Module 30: Hybrid Reporting: Integrating Power Query, Data Model, Formulas & UI 4 lessons
31 Module 31: VBA Developer Environment, Security & Macro Recording Architecture 4 lessons
32 Module 32: VBA Language Foundations: Variables, Data Types & Scope 4 lessons
33 Module 33: The Excel Object Model Hierarchy: Application, Workbook, Worksheet & Range 4 lessons
34 Module 34: Control Flow, Logic Gates & High-Performance Loops 4 lessons
35 Module 35: Dynamic Range Detection, Last Row Engineering & 2D Memory Arrays 4 lessons
36 Module 36: Reusable Subroutines, Custom Functions (UDFs) & Modular Architecture 4 lessons
37 Module 37: Interactive UserForms: Data-Entry GUI, Controls & Validation Engines 4 lessons
38 Module 38: Event-Driven Automation: Worksheet & Workbook Events 4 lessons
39 Module 39: Automated File Operations, Directory Scanning & Batch Archiving 4 lessons
40 Module 40: Automated PDF Publishing & Controlled Outlook Email Integration 4 lessons
41 Module 41: Defensive Programming, Robust Error Handling & Audit Logging 4 lessons
42 Module 42: Macro Performance Optimization: ScreenUpdating, Calculation & Memory Management 4 lessons
43 Module 43: External Database Integration: ADO, SQL Server & Transaction Controls 4 lessons
44 Module 44: Ribbon Customization (XML), Fluent UI & Custom Add-in Deployment (.xlam) 4 lessons
45 Module 45: Enterprise Application Maintenance, Version Control & Security Audit 4 lessons
46 Module 46: Capstone Project A: Omni-Channel Executive Sales & Margin Intelligence Dashboard 3 lessons
47 Module 47: Capstone Project B: Multi-Location Warehouse Inventory & Automated Reorder System 3 lessons
48 Module 48: Capstone Project C: Human Resources Workforce Attendance & Payroll Engine 3 lessons
49 Module 49: Capstone Project D: Corporate Financial Budget vs Actual Variance Intelligence Engine 3 lessons
50 Module 50: Capstone Project E: Automated Multi-Branch MIS Consolidation & PDF Publishing Pipeline 3 lessons
51 Module 51: Capstone Project F: Enterprise Full-Stack VBA Business Application Suite 3 lessons 
