Module 1: Introduction to Excel

• Introduction to Spreadsheet
• Excel Interface & Components
• Workbook, Worksheet, Rows & Columns
• Data Entry (Text, Number, Date)
• Saving, Opening & Managing Files

Module 2: Basic Operations

• Select, Copy, Cut, Paste, Undo, Redo
• Insert / Delete Rows & Columns
• Formatting Cells (Font, Size, Bold, Alignments)
• Borders & Cell Shading
• Number & Date Formats

Module 3: Data Formatting & Editing

• AutoFill & Flash Fill
• Wrap Text & Merge Cells
• Find & Replace
• Sort (A→Z, Z→A) & Filter (Basic Filter)
• Freeze Panes & Split Window

Module 4: Formulas & Functions

• Formula Structure (=, Cell References)
• Relative, Absolute & Mixed References ($)
• Basic Functions:
• SUM(), AVERAGE(), MAX(), MIN(), COUNT()
• Text Functions:
• LEFT(), RIGHT(), MID(), LEN(), TRIM(), CONCAT()
• Logical Functions:
• IF(), AND(), OR(), NOT()
• Date Functions:
• TODAY(), NOW(), DAY(), MONTH(), YEAR()

Module 5: Data Analysis Tools

• Conditional Formatting
• Data Validation (Drop-down List)
• Remove Duplicates
• Goal Seek
• Flash Fill (Smart Fill)
• What-If Analysis

Module 6: Charts & Graphs

• Insert Column, Bar, Line, Pie, Combo Charts
• Chart Layout & Design Formatting
• Sparklines

Module 7: Tables & Reporting

• Convert Data to Table
• Table Styles & Totals Row
• Subtotal Reports
• Basic Pivot Table
• Basic Pivot Chart

Module 8: Printing & Page Setup

• Page Layout, Margins & Orientation
• Header & Footer
• Fit to Page & Print Preview

Module 9: Practical Office Projects

• Attendance Sheet
• Salary Sheet with Formula
• Stock & Inventory Record
• Student Marksheet & Result Calculation
• Monthly Expense Sheet