1. Introduction to Excel

• Excel क्या है?
• Workbook & Worksheet
• Excel Interface
• Rows, Columns, Cells
• Ribbon, Tabs & Groups
• File Create, Save, Save As
• Open, Close, Exit
• Basic Shortcut Keys

2. Data Entry Basics

• Text, Number, Date Entry
• Edit, Delete, Clear
• AutoFill, Flash Fill (Basics)
• Copy, Cut, Paste
• Paste Special Basics
• Insert Row/Column
• Delete Row/Column

3. Formatting in Excel

• Font size, style, color
• Cell alignment
• Wrap Text
• Merge & Center
• Cell Borders & Shading
• Number Formatting:
• General
• Number
• Currency
• Date
• Percentage
• Decimal settings

4. Working with Worksheets

• Insert, Delete, Rename Sheet
• Move or Copy Sheet
• Tab Color Change
• Freeze Panes
• Split Window
• Hide/Unhide Rows, Columns, Sheets

5. Basic Calculations

• Addition (+)
• Subtraction (–)
• Multiplication (*)
• Division (/)
• Percentage Calculation
• Average Calculation
• Basic Arithmetic Examples

6. Basic Formulas & Functions

✔ Most Important Basic Functions:

• SUM
• AVERAGE
• MAX
• MIN
• COUNT
• COUNTA
• COUNTBLANK
• ROUND

7. Relative, Absolute & Mixed Cell Reference

• Relative Reference (A1)
• Absolute Reference ($A$1)
• Mixed Reference (A$1, $A1)
• Dollar Sign का उपयोग

8. Sorting & Filtering

• Simple Sorting A–Z, Z–A
• Number Sorting
• Date Sorting
• AutoFilter
• Multiple column filter

9. Basic Charts & Graphs

• Column Chart
• Bar Chart
• Pie Chart
• Line Chart
• Chart Elements Basics
• Title
• Axis
• Legend

10. Basic Data Tools

• Data Validation (Basics)
• Remove Duplicates
• Text to Columns
• Flash Fill

11. Page Layout & Printing

• Page Setup
• Page Margins
• Scaling (Fit to Page)
• Header & Footer
• Print Area Set
• Gridlines print settings

12. Excel Security

• Protect Sheet (Basics)
• Protect Workbook
• Password to Open File

13. Practical Excel Tasks

• Marksheet बनाना
• Attendance Sheet
• Daily Expense Sheet
• Simple Invoice
• Student Fee Record
• Small Business Record