Advanced Excel Course Syllabus
Advanced Excel is a professional-level course that teaches advanced functions, formulas, data analysis tools, PivotTables, charts, and dashboards in Microsoft Excel.
It helps learners automate tasks, create dynamic reports, and handle large data sets efficiently.
Ideal for MIS executives, analysts, and professionals in finance, accounts, and admin roles.
Module 1: Introduction to Advanced Excel
- What is Advanced Excel?
- Interface Overview and Ribbon Customization
- Differences Between Basic and Advanced Excel
Module 2: Advanced Functions & Formulas
- Text Functions: CONCATENATE, TEXTJOIN, LEFT, RIGHT, MID, LEN, TRIM, UPPER, LOWER
- Logical Functions: IF, AND, OR, NOT, IFERROR, IFS
- Lookup & Reference Functions: VLOOKUP, HLOOKUP, XLOOKUP
- Date & Time Functions: TODAY, NOW, DATEDIF, EDATE, NETWORKDAYS
- Math & Statistical Functions: SUMIFS, COUNTIFS, AVERAGEIFS, ROUND, RANK, SUBTOTAL
Module 3: Data Analysis & Reporting Tools
- Data Validation (Drop-down lists, Input Messages, Error Alerts)
- Conditional Formatting (Color Scales, Icon Sets, Custom Rules)
- Advanced Filter and Criteria Range
Module 4: Pivot Tables & Pivot Charts
- Creating Data in Pivot Tables
- Calculated Fields and Items
- Pivot Charts
Module 5: Data Tools
- Consolidate Data from Multiple Sheets
- Text to Columns
- Importing Data from Web/Text/CSV Files
- Flash Fill & Auto Fill
Module 6: Protection and Security
- Worksheet and Workbook Protection
- Cell Locking, Hiding Formulas
- Protecting Excel Files with Password
Module 7: Macros & Introduction to VBA
- Recording Macros
- Running and Editing Macros
- Basics of VBA (Optional but useful)
Module 8: Printing, Page Layout & Excel Settings
- Page Setup, Print Area, Page Break
- Headers/Footers
- Scaling Options
- Print Titles, Fit to Page