Course Duration: 4 weeks
Class Schedule: Saturdays and Sundays
Daily Class Duration: 2-3 hours
Total Class Hours: 16-24 hours

Week 1: Introduction to Excel & Basic Functions

• Day 1: Introduction to Excel

  • Overview of Excel interface (Ribbon, Workbook, Worksheet)
  • Creating, saving, and managing Excel files
  • Basic navigation and shortcuts
  • Entering and formatting data (numbers, text, dates)

• Day 2: Basic Formulas and Functions

  • Understanding cell references (relative, absolute)
  • Basic arithmetic operations (SUM, AVERAGE, MIN, MAX)
  • Introduction to the AutoSum feature
  • Using basic text functions (LEFT, RIGHT, CONCATENATE)

Week 2: Data Management & Formatting

• Day 3: Data Formatting and Conditional Formatting

  • Cell formatting (font, color, borders)
  • Number formatting (currency, percentage, date)
  • Conditional formatting basics (highlighting cells, rules)

• Day 4: Data Sorting and Filtering

  • Sorting data (single column, multiple columns)
  • Filtering data (using AutoFilter)
  • Introduction to basic charts (bar, column, pie charts)

Week 3: Working with Tables & Basic Data Analysis

• Day 5: Working with Tables

  • Creating and formatting tables
  • Sorting and filtering within tables
  • Using structured references in tables

• Day 6: Introduction to Data Analysis Tools

  • Introduction to PivotTables (creating basic PivotTables)
  • Using slicers with PivotTables
  • Basic data validation (drop-down lists)

Week 4: Final Projects & Practical Applications

• Day 7: Practical Applications

  • Budget tracking exercise (personal or project-based)
  • Simple data entry form
  • Basic reporting and summary creation

• Day 8: Final Project & Review

  • Final project: Create a basic report with summary, chart, and data table
  • Review of key concepts
  • Q&A and troubleshooting common issues