29/07/2026
Dear all
Class on line August 2026
Week 1 – Excel Formulas
XLOOKUP vs VLOOKUP
INDEX + MATCH Combination
SUMIFS for Multiple Criteria
COUNTIFS for Advanced Analysis
IFERROR Formula Explained
TEXT Functions (LEFT, RIGHT, MID)
Top 10 Essential Excel Formulas
Week 2 – Data Analysis
Pivot Table Basics
Advanced Pivot Table Tricks
Pivot Charts for Reporting
Slicers and Timelines
Conditional Formatting Secrets
Data Validation Techniques
Remove Duplicates Like a Pro
Week 3 – Automation & Dashboards
Introduction to Power Query
Automate Reports with Power Query
Dynamic Dashboard Creation
Interactive Charts in Excel
Named Ranges for Better Reports
Excel Templates for MIS Reporting
Automating Daily Reports
Week 4 – Professional Excel Skills
Excel Shortcuts Every Professional Should Know
Working with Large Datasets
Advanced Filtering Techniques
What-If Analysis
Goal Seek & Solver
Excel Tips for Sales Reporting
Excel Tips for MIS Executives
Common Excel Mistakes and Solutions
Excel Skills That Help Career Growth
