Course Syllabus
Month 1: Excel Basics
- Interface, Workbook/Worksheet
- Cell & Number Formatting
- Data Entry Rules
- Basic Formulas: SUM, AVG, COUNT, MAX, MIN
- Basic Charts (Bar/Line/Pie)
- Basic Data Validation
Month 2: Formulas & Data Handling
- Logical: IF, AND, OR, NOT
- Lookup: VLOOKUP, HLOOKUP, XLOOKUP
- Text: LEFT, RIGHT, MID, TRIM, CONCAT, LEN
- Date: TODAY, NOW, DATEDIF
- Advanced Sort & Filter
- Conditional Formatting
Month 3: Advanced Excel Tools
- Pivot Table & Pivot Chart
- Dashboard Basics
- What-If Analysis (Goal Seek, Scenario)
- Data Consolidation
- Power Query (Basic)
- Flash Fill, Remove Duplicates
- Sheet/Workbook Protection
- Page Setup & Printing
- Final Project
Bestseller
