📅 Duration: 3 Months | ⏰ Timings: Weekends Only (4 Hours/Week)

🚀 Learn Excel from Basic to Advanced – Ideal for Students, Job Seekers, Professionals & Business Owners

🔸Course Highlights

• Master Excel from fundamentals to automation

• Live practical training with real-time examples

• Build MIS reports, dashboards, and dynamic templates

• Learn formulas, pivot tables, data analysis, and VBA basics

• Job-ready skills with certificate & project work

🧭 Course Structure

✅ Module 1: Excel Basics (Week 1)

• Introduction to Excel Interface

• Workbook & Worksheet Management

• Data Entry Tips and Shortcuts

• Formatting Cells: Font, Color, Borders

• Basic Formulas: SUM, AVERAGE, MIN, MAX, COUNT

• Introduction to Cell References (Relative, Absolute, Mixed)

✅ Module 2: Data Handling & Formatting (Week 2–3)

• Sorting & Filtering Data

• Number Formatting (Date, Currency, Percentage)

• Conditional Formatting (Color Scales, Icons, Custom Rules)

• Find & Replace, Go To Special

• Data Validation (Dropdown Lists, Custom Rules)

✅ Module 3: Core Excel Functions (Week 4–5)

• Text Functions: LEFT, RIGHT, MID, LEN, CONCATENATE, TEXT

• Logical Functions: IF, AND, OR, IFERROR, IFS

• Lookup Functions: VLOOKUP, HLOOKUP, XLOOKUP (New), INDEX & MATCH

• Math Functions: ROUND, SUMIF, COUNTIF, AVERAGEIF

• Date Functions: TODAY, NOW, EOMONTH, DATEDIF, NETWORKDAYS

✅ Module 4: Data Analysis & Visualization (Week 6–7)

• Charts: Column, Line, Pie, Bar, Combo Charts

• Pivot Tables & Pivot Charts

• Slicers & Timelines

• Grouping, Sorting, and Summarizing Data

• Creating Dynamic Charts

• Introduction to Excel Dashboards

✅ Module 5: Advanced Excel Tools (Week 8–9)

• What-If Analysis: Goal Seek, Scenario Manager, Data Tables

• Named Ranges

• Working with Multiple Sheets & Workbooks

• Excel Tables (Structured References)

• Power Query Basics (Data Transformation)

• Flash Fill, Remove Duplicates, Transpose

✅ Module 6: Automation with Excel (VBA Intro) (Week 10)

• Introduction to Macros

• Recording & Running Macros

• Basics of VBA Editor

• Writing Simple VBA Code

• Automating Repetitive Tasks

• Button Creation & Macro Assigning

✅ Module 7: Excel for Business & MIS Reporting (Week 11)

• Creating Interactive Dashboards

• Sales, HR, and Financial Report Examples

• Data Cleaning Best Practices

• Working with Large Datasets

• Tips for Faster Performance

✅ Module 8: Final Project & Career Support (Week 12)

• Build a Full Excel Dashboard (HR/Finance/Sales)

• Interview Questions & Answer Practice

• Resume Tips with Excel Projects

• Portfolio Building

• Certification Overview (MOS Excel etc.)