📘 Module 1: Basic Excel Foundation

Topics:

• Excel Interface, Ribbon & Toolbar
• Workbook, Worksheet, Rows, Columns Management
• Data Entry & Editing, Autofill, Series, Flash Fill
• Formatting (Font, Borders, Number, Alignment)
• Conditional Formatting (Basic Rules)
• Basic Formulas: SUM, AVERAGE, COUNT, MAX, MIN
• Text Functions: LEFT, RIGHT, MID, CONCAT, PROPER, UPPER, LOWER
• Page Setup, Print Area, Header/Footer, Page Breaks

Practice Project: Attendance Sheet + Basic Expense Tracker

📗 Module 2: Intermediate Excel

Objective: Data Management & Logical Function mastery

Topics:

• Cell Referencing (Relative, Absolute, Mixed)
• Logical Functions: IF, IFS, AND, OR, NOT, XOR
• Lookup Functions: VLOOKUP, HLOOKUP, INDEX-MATCH
• Mathematical Functions: SUMIF, COUNTIF, AVERAGEIF, ROUND, CEILING, FLOOR
• Text & Information Functions: LEN, FIND, SEARCH, REPLACE, ISERROR, ISBLANK
• Data Validation (Dropdown, List, Error Alerts)
• Conditional Formatting (Custom Formula Rules)
• Data Sorting & Multi-Level Filtering
• Using Excel Tables & Structured References

Practice Project: Employee Data Management Sheet

📙 Module 3: Advanced Excel Formulas & Analysis

Topics:

• Advanced Lookup: XLOOKUP, XMATCH, CHOOSE, OFFSET
• Dynamic Array Functions: UNIQUE, SORT, FILTER, SEQUENCE
• Statistical Functions: RANK, LARGE, SMALL, PERCENTILE, QUARTILE
• Financial Functions: PMT, NPV, IRR, FV
• Date Functions: EDATE, EOMONTH, DATEDIF, NETWORKDAYS
• Advanced Conditional Formatting (Formula-based)
• Pivot Table (Advanced Grouping, Calculated Fields)
• Pivot Chart + Slicer, Timeline

Practice Project: Sales Performance Report (Pivot-based)

📒 Module 4: Business Analytics & Dashboard

Objective: Interactive Dashboard & MIS Reports

Topics:

• Dashboard Planning & Design Principles
• Chart Mastery: Combo Chart, Waterfall, Funnel, Gauge, Dynamic Charts
• Form Controls: Drop-down, Scroll Bar, Check Box, Option Button
• Data Visualization with KPI Indicators
• Creating Dynamic Dashboards (Region & Product Based)
• Power Query (Data Cleaning, Transformation)
• Power Pivot (Data Model, Relationships)
• Power View & Power Map Introduction

Practice Project: Interactive Business Dashboard

📕 Module 5: Automation & VBA

Objective: Automation & Macro Programming

Topics:

• Introduction to Macros & Developer Tab
• Recording & Editing Macros
• VBA Basics: Variables, Loops, Conditions, MsgBox, InputBox
• Automating Tasks (Reports, Formatting, Copy-Paste)
• Event-Driven Macros
• Creating Custom Excel Functions (UDFs)
• Form Controls with VBA
• Creating Custom Message Boxes & Buttons
• Protecting VBA Project

Practice Project: Invoice Automation with VBA

📔 Module 6: Data Analytics + Professional Projects

Objective: Real-World Excel Application & MIS Reporting

Topics:

• Data Import from CSV, Access, SQL
• Data Cleaning with Power Query
• Data Consolidation (Across Workbooks)
• Advanced Chart Linking with Formulas
• Report Automation (Monthly / Yearly)
• Excel Integration with Word, PowerPoint & Outlook
• Advanced Protection & Encryption
• Excel Dashboard Final Project (Real Dataset)
• Interview Preparation (MIS / Analyst Roles)

Final Project:

Create a Corporate MIS Dashboard for Sales, HR, and Finance.

🏆 Learning Outcome:

✅ Excel from Basic to Expert

✅ Data Analysis & Business Dashboard

✅ Power Query, Power Pivot & VBA Automation

✅ Suitable for MIS Executive, Data Analyst, Accountant, Manager roles