Module 1: Excel Basics (3 Hours)

📌 Objective: Build foundation & fluency in Excel environment

• Introduction to Excel interface (Ribbon, Workbook, Worksheet, Cells)

• Entering & Editing Data (manual entry, autofill, copy-paste tricks)

• Formatting Cells (number, text, borders, styles)

• Basic Operations (shortcuts, navigation, productivity hacks)

• Managing Files (save, open, templates, multiple sheets)

• Hands-on Exercise: Create a formatted attendance sheet

Module 2: Formulas & Functions (4 Hours)

📌 Objective: Learn Excel’s calculation engine & logical functions

• Difference: Formula vs Function

• Arithmetic Operations (+, −, ×, ÷)

• Common Functions → SUM, AVERAGE, MIN, MAX

• Text Functions → LEFT, RIGHT, CONCATENATE, LEN

• Logical Functions → IF, AND, OR (nested examples)

• Lookup Functions → VLOOKUP, HLOOKUP, XLOOKUP

• Practice: Salary calculator, marksheet with grade classification

• Mini Case Study: Product sales lookup using VLOOKUP & XLOOKUP

Module 3: Data Management (3 Hours)

📌 Objective: Manage, clean, and validate datasets effectively

• Sorting & Filtering data

• Data Validation (drop-down lists, restrictions)

• Removing Duplicates & Data Cleaning

• Find & Replace (advanced options)

• Conditional Formatting (duplicates, top values, formulas)

• Hands-on: Clean a messy dataset (employees, sales, or students)

• Mini Case Study: Validate and highlight errors in student marks

Module 4: Charts & Visualization (2 Hours)

📌 Objective: Present data visually for better analysis

• Creating Charts: Column, Bar, Line, Pie

• Advanced Charts: Combo, Scatter

• Formatting Charts (legends, labels, design)

• Smart use of Sparklines

• Practice: Build a sales report dashboard with 3 different charts

Module 5: Pivot Tables & Pivot Charts (3 Hours)

📌 Objective: Analyze & summarize data like a professional

• Creating Pivot Tables from datasets

• Summarizing & Grouping Data (dates, numbers)

• Applying Filters & Slicers

• Pivot Charts for dynamic dashboards

• Hands-on Practice: Sales by region → filter & analyze

• Mini Case Study: Monthly sales dashboard using Pivot + Pivot Chart

Module 6: Macros (2 Hours)

📌 Objective: Automate repetitive tasks easily

• What are Macros?

• Recording & Running Macros

• Assigning Macros to Buttons

• Automating Formatting & Data Cleaning

• Practice: Create a macro for report formatting

Module 7: VBA Basics (3 Hours)

📌 Objective: Introduction to coding with VBA for automation

• Introduction to VBA Editor

• Writing Simple VBA Code

• Variables & Loops in VBA

• Automating Reports with VBA

• Safety & Best Practices in VBA

• Mini Project: Automate a monthly sales report (import → clean → format → chart)