Course Syllabus
Advanced MS Excel Course Syllabus
1. Excel Advanced Basics
- Excel Interface & Shortcuts
- Workbook & Worksheet Management
- Advanced Formatting Techniques
2. Advanced Formulas & Functions
- IF, Nested IF
- VLOOKUP, HLOOKUP
- XLOOKUP
- INDEX & MATCH
- SUMIF / SUMIFS
- COUNTIF / COUNTIFS
- Logical Functions
3. Data Management
- Sorting & Filtering
- Advanced Filter
- Data Validation
- Remove Duplicates
- Text to Columns
4. Pivot Table & Pivot Chart
- Creating Pivot Tables
- Pivot Charts
- Data Analysis using Pivot
- Grouping Data
5. Data Analysis & Visualization
- Charts & Graphs
- Conditional Formatting
- Dashboard Creation
6. Power Query
- Data Import
- Data Cleaning
- Data Transformation
7. Macros & Automation
- Introduction to Macros
- Record Macro
- Edit Macro
- Automating Tasks
8. Excel for Business
- MIS Reports
- Financial Reports
- Sales & Inventory Reports
9. Excel with AI Tools
- AI for Data Analysis
- ChatGPT with Excel
- Excel AI Add-ins
- Smart Data Insights
✅ Course Duration: 2–3 Months
✅ Mode: Practical Training
✅ Projects: Real Business Data Practice
Bestseller
