Excel Course (15 Hours – Beginner to Advanced with Macros & VBA)

Module 1: Excel Basics (2 Hours)

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

• Entering & editing data, formatting cells

• Basic operations (copy, paste, autofill, shortcuts)

• Saving, opening, and managing files

Module 2: Formulas & Functions (3 Hours)

• Understanding formulas vs. functions

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

• Common functions: SUM, AVERAGE, MIN, MAX

• Text functions: LEFT, RIGHT, CONCATENATE, LEN

• Logical functions: IF, AND, OR

• Lookup functions: VLOOKUP, HLOOKUP, XLOOKUP

Module 3: Data Management (2 Hours)

• Sorting & Filtering data

• Data Validation (drop-down lists, restrictions)

• Removing duplicates, Find & Replace

• Conditional formatting rules

Module 4: Charts & Visualization (2 Hours)

• Creating charts: Column, Bar, Line, Pie

• Advanced charts: Combo, Scatter

• Formatting charts for reports

• Smart use of Sparklines

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

• Creating pivot tables from datasets

• Summarizing & grouping data

• Applying filters & slicers

• Pivot charts for dynamic reporting

Module 6: Macros (2 Hours)

• What are Macros?

• Recording & running macros

• Assigning macros to buttons

• Automating repetitive tasks

Module 7: VBA Basics (2 Hours)

• Introduction to VBA editor

• Writing simple VBA code

• Variables & loops in VBA

• Automating reports with VBA

• Safety & best practices in VBA