Advanced Excel
Master advanced Excel formulas, Pivot Tables, Power Query and dashboards.
Enquire Now →Eligibility
Students, beginners and anyone who wants to improve their computer skills.
Course Benefits
Build essential computer skills
Improve office productivity
Learn practical digital skills
Prepare for workplace requirements
Course Syllabus
Course Modules
Excel Fundamentals & Data Management
Workbook, worksheets, formatting, tables, data entry, sorting, filtering
Advanced Excel Formulas
IF, IFS, SUMIFS, COUNTIFS, AVERAGEIFS, XLOOKUP, INDEX-MATCH
Logical & Lookup Functions
IF, AND, OR, IFERROR, VLOOKUP, HLOOKUP, XLOOKUP, INDEX & MATCH
Data Cleaning & Text Functions
TRIM, CLEAN, LEFT, RIGHT, MID, TEXT, CONCAT, TEXTJOIN, Flash Fill
Date & Time Functions
TODAY, NOW, DATE, YEAR, MONTH, DAY, DATEDIF, WORKDAY, NETWORKDAYS
Pivot Tables & Pivot Charts
Pivot Tables, grouping, calculated fields, slicers, timelines, Pivot Charts
Data Validation & Conditional Formatting
Drop-down lists, custom validation, duplicate detection, advanced conditional formatting
Charts & Dashboard Design
Column, Bar, Line, Pie, Combo charts, KPI cards, interactive dashboards
Power Query
Import data, clean data, transform data, merge, append, remove duplicates and automate data preparation
Advanced Data Analysis
What-If Analysis, Goal Seek, Scenario Manager, Solver basics, forecasting
Excel Automation & Productivity
Named ranges, templates, advanced shortcuts, worksheet protection and productivity techniques
Real-World Projects
Sales Dashboard, MIS Report, Employee Report, Inventory Report and Business Analysis
Ready to learn Advanced Excel?
Enquire today for latest batch details, fees and available offers.