Course Syllabus :

Module 1: Introduction to Advanced Excel

• Excel interface & shortcuts
• Worksheet management
• Data cleaning & formatting
• Advanced copy-paste techniques

Module 2: Advanced Formulas & Functions

Logical Functions

• IF, AND, OR, NOT
• Nested IF statements

Lookup & Reference

• VLOOKUP
• HLOOKUP
• XLOOKUP
• INDEX + MATCH
• OFFSET

Text Functions

• LEFT, RIGHT, MID
• CONCAT, TEXTJOIN
• TRIM, LEN, LOWER, UPPER

Date & Time Functions

• TODAY, NOW, DATEDIF
• NETWORKDAYS, EOMONTH

Math & Statistical Functions

• SUMIF, SUMIFS
• COUNT, COUNTIF, COUNTIFS
• AVERAGE, MAX, MIN

Module 3: Pivot Tables & Pivot Charts

• Creating pivot tables
• Sorting, filtering, grouping
• Pivot charts & slicers
• Dynamic data analysis

Module 4: Data Validation & Data Protection

• Dropdown lists
• Data entry restrictions
• Duplicate prevention
• Protecting cells & sheets

Module 5: Excel Charts & Dashboards

• Column, bar, line, pie charts
• Waterfall, donut, combo charts
• Sparklines
• KPI dashboards
• Interactive dashboards using slicers

Module 6: Data Analysis Tools

• What-If Analysis
• Goal Seek
• Scenario Manager
• Consolidation of data

Module 7: Power Tools (If applicable)

• Power Query (Basic)
• Power Pivot (Introduction)

Module 8: Macros & Basic VBA

• Recording macros
• Running macros
• Introduction to VBA editor
• Automating routine tasks

Module 9: Excel for Office & MIS Jobs

• Professional reporting
• Salary sheets
• Attendance sheets
• Inventory management
• Sales reports
• GST formulas (basic)

Module 10: Final Project

Students create:

• 1 interactive dashboard
• 1 MIS report
• 1 business data analysis file

🛠 Software Tools Covered

• Microsoft Excel (Latest Version)
• Power Query (optional)
• Power Pivot (optional)
• VBA Macro tools