What You Will learn

Hour 1: Excel Fundamentals (Foundation Layer)

• Excel Interface (Ribbon, Sheets, Cells)

• Data Types (Text, Number, Date)

• Basic Formatting (Font, Borders, Alignment)

• Sort & Filter (super practical)

• Freeze Panes (real-world lifesaver)

Hour 2: Core Formulas (The Money Skills)

• Basic Formulas: SUM, AVERAGE, COUNT

• Logical: IF

• Lookup: VLOOKUP (must teach)

• Conditional: COUNTIF, SUMIF

Hour 3: Data Handling & Cleaning

• Text to Columns

• Remove Duplicates

• Data Validation (Dropdowns)

• Conditional Formatting

Hour 4: Pivot Tables + Charts (Advanced Core)

• Pivot Tables (MOST IMPORTANT)

• Pivot Charts

• Slicers (interactive filtering)

Hour 5: Advanced + Real-World Use Cases

• XLOOKUP (modern replacement for VLOOKUP)

• INDEX + MATCH (for interviews 💼)

• Basic Dashboard Design

• Real-world case study