This Advanced Excel course is designed to help learners master data handling, reporting, and automation using professional Excel techniques. From formulas to dashboards, this course prepares you for MIS, Data Analyst, Reporting, and Business Operations roles.
Excel Interface & Shortcuts
Data Types & Cell Referencing
Printing & Formatting Techniques
Logical Functions (IF, AND, OR, IFS)
Lookup Functions (VLOOKUP, HLOOKUP, XLOOKUP)
INDEX-MATCH & Advanced Lookup
Text Functions (LEFT, RIGHT, MID, FIND, TRIM)
Date & Time Functions
Statistical Functions (COUNTIF, SUMIF, AVERAGEIF, etc.)
Remove Duplicates
Find & Replace
Text-to-Columns
Power Query Basics
Flash Fill & Advanced Fill Options
Creating Pivot Tables
Grouping & Filtering
Slicers & Timelines
Pivot Charts for Reporting
Professional Charts
Conditional Formatting
Sparklines
Dashboard Designing Techniques
Data Validation
What-If Analysis (Goal Seek, Scenario Manager)
Named Ranges
Excel Tables
WhatsApp us