Module 1: Excel Basics

·      Day 1: Introduction to Excel, Interface, Workbook vs Worksheet

·      Day 2: Rows, Columns, Cells, and Basic Navigation

·      Day 3: Data Entry, AutoFill, Series

·      Day 4: Formatting Cells – Numbers, Dates, Alignment, Colors

·      Day 5: Practice Sheet 1

·      Day 6: Sorting & Filtering Data

·      Day 7: Introduction to Basic Formulas – SUM(), AVERAGE(), MIN(), MAX()

·      Day 8: COUNT(), COUNTA(), ROUND(), INT(), RANK()

·      Day 9: Practice Sheet 2

·      Day 10: Excel Basics Test

Module 2: Intermediate Excel

·      Day 11: Conditional Formatting

·      Day 12: Data Validation – Drop-downs, Error Alerts

·      Day 13: Text Functions – LEN(), LEFT(), RIGHT(), MID(), TRIM()

·      Day 14: CONCAT(), TEXT(), UPPER(), LOWER()

·      Day 15: Date & Time Functions – TODAY(), NOW(), DATEDIF()

·      Day 16: Logical Functions – IF(), AND(), OR(), NOT()

·      Day 17: Lookup Functions – VLOOKUP(), HLOOKUP()

·      Day 18: Practice Sheet 3

·      Day 19: Intermediate Excel Test

·      Day 20: Revision & Practice

Module 3: Advanced Excel

·      Day 21: INDEX(), MATCH(), XLOOKUP()

·      Day 22: Nested IF, IFERROR(), ISBLANK(), ISNUMBER()

·      Day 23: Named Ranges, Absolute References

·      Day 24: Pivot Tables – Creation, Filters, Values

·      Day 25: Charts – Bar, Pie, Line, Combo

·      Day 26: Advanced Filters & Subtotals

·      Day 27: Data Consolidation & Grouping

·      Day 28: Project – Sales Report with Charts

·      Day 29: Practice Sheet 4

·      Day 30: Advanced Excel Test

Module 4: Excel Dashboards

·      Day 31: Dashboard Concepts & Layout

·      Day 32: Creating KPI Metrics with Formulas

·      Day 33: Using Pivot Charts in Dashboards

·      Day 34: Slicers, Timeline Controls

·      Day 35: Project – Mini Dashboard (Sales/Attendance/HR)

Module 5: Excel with AI Tools

·      Day 36: Introduction to AI in Excel – Concepts

·      Day 37: Excel Ideas (Data Insights with AI)

·      Day 38: Flash Fill (AI-powered autofill)

·      Day 39: Using ChatGPT to Write Excel Formulas

·      Day 40: Creating Charts using AI Tools

·      Day 41: Using AI Templates (Job Tracker, Budget, Invoices)

·      Day 42: Power Query Basics

·      Day 43: Power Query Basics -2

·      Day 44: Practice Day – AI Tools in Action

·      Day 45: AI + Excel Quiz + Review

Final Assessment + Project Work

·      Day 46: Final Project – Dashboard with AI-Powered Excel Features

·      Day 47: Final Practical Test – Formula + Pivot + Dashboard

·      Day 48: Viva + Doubt Clearing

·      Day 49: Certification Preparation

·      Day 50: Certificate Distribution + Feedback Session