Advanced Excel Mastery

Module 1 - Excel Basics and Core Fundamentals

Module 2 - Data Handling and Efficiency Techniques

Module 3 - Data Transformation and Analysis Tools

Module 4 - Mastering Pivot Tables and Power Pivot

Module 5 - Advanced Lookup and Reference Formulas

Module 6 - Statistical, Text, and Financial Insights

Project 1 - Practice With Industry Level Projects

Advanced Power Query Mastery

Module 1 - Introduction to Power Query

Module 2 - Data Appending & Merging

Module 3 - Data Grouping & Summarization

Module 4 - Data Transformation & Manipulation

Module 5 - Advanced Power Query & Real-World

Scenarios

Project 1 - Practice With Industry Level Projects

Excel VBA Mastery

Module 1 – Introduction to VBA

Module 2 – Logic and Conditional Statements

Module 3 – Loops and Iterations

Module 4 – Practical Loop Projects

Module 5 – Message Box and Input Box

Module 6 – Worksheet Automation with Loops

Module 7 – Understanding Objects and Classes

Module 8 – Collections and For Each Loops

Module 9 – Workbook Management Automation

Module 10 – Nested Loops and Assignments

Module 11 – Working with Arrays in VBA

Module 12 – Text, Date, and Excel Functions

Module 13 – User Defined Functions and Lookups

Module 14 – Designing Interactive UserForms

Module 15 – Email Automation with Outlook

Module 16 – Web Scraping and Data Extraction

Module 17 – Event-Based Programming in VBA

Module 18 – Advanced Projects and Add-ins

Module 19 – Assignments and Interview Practice

Dashboard Mastery

Module 1 – Pivot Tables & Charts

Module 2 – Excel Charts & Visuals

Module 3 – Dashboards & Reporting

Module 4 – Advanced Dashboards

Module 5 – Time & Project Dashboards

Office 365 Mastery

Module 1 – Filter, Sort, and Aggregate Formulas

Module 2 – XLOOKUP Formula Advanced Techniques

Module 3 – Dynamic Formulas and Data Analysis

Module 4 – Office 365 Assignments with Solutions

Module 5 – Advanced Array and Automation Formulas