Course Name:	Advance Excel Course
Course Short Name:	Advance Excel Course
Course Code::	AMCEC/206
Course Type:	Certificate
Duration:	3 Month
Eligibility:	10th Pass
Total Subjects:	8

. Excel Basics & Formatting

• Cell Formatting
• Conditional Formatting
• Data Validation
• Custom Formatting

2. Advanced Formulas & Functions

• IF, Nested IF
• IFS, SWITCH
• VLOOKUP, HLOOKUP
• XLOOKUP
• INDEX + MATCH
• SUMIF, SUMIFS
• COUNTIF, COUNTIFS
• TEXT Functions (LEFT, RIGHT, MID, CONCAT)
• DATE & TIME Functions

3. Data Management

• Sorting
• Filtering
• Advanced Filter
• Remove Duplicates
• Text to Columns

4. Pivot Table & Pivot Chart

• Pivot Table Creation
• Pivot Chart
• Slicers
• Dashboard Reports

5. Data Analysis

• What-If Analysis
• Goal Seek
• Scenario Manager
• Data Tables

6. Charts & Dashboards

• Column Chart
• Line Chart
• Pie Chart
• Dynamic Charts
• Interactive Dashboard

7. Lookup & Database Functions

• VLOOKUP
• XLOOKUP
• INDEX-MATCH
• OFFSET
• INDIRECT

8. Power Query

• Data Import
• Data Cleaning
• Data Transformation
• Multiple Files Merge

9. Macros & VBA (Advanced Level)

• Macro Recording
• VBA Basics
• Automation
• Report Generation

10. MIS Reporting

• Daily MIS Report
• Production Report
• Inventory Report
• Sales Report
• Attendance Report