๐ข 1. BEGINNER LEVEL – Getting Started
๐ What is Excel?
Excel is a spreadsheet tool used for:
- Data entry
- Calculations
- Analysis
- Reporting
๐งฑ Excel Structure
- Workbook → Entire file
- Worksheet → Sheet inside workbook
- Cell → Intersection (e.g., A1)
- Row → Horizontal (1,2,3…)
- Column → Vertical (A,B,C…)
✍️ Entering Data
- Text → Names
- Numbers → Scores
- Dates → 16/04/2026
⚡ AutoFill (VERY IMPORTANT)
Drag the small square to:
- Continue numbers (1,2,3…)
- Copy formulas
- Fill dates
๐ก 2. BASIC FORMULAS (FOUNDATION)
➕ Arithmetic
=A1 + B1
=A1 - B1
=A1 * B1
=A1 / B1
๐ Common Functions
=SUM(A1:A10)
=AVERAGE(A1:A10)
=MAX(A1:A10)
=MIN(A1:A10)
=COUNT(A1:A10)
๐ฏ Example Table
| Item | Cost | Selling | Profit |
|---|---|---|---|
| Pen | 50 | 100 | =C2-B2 |
๐ 3. INTERMEDIATE LEVEL
๐ IF Function (Decision Making)
=IF(A1>=50, "Pass", "Fail")
๐ VLOOKUP (VERY POWERFUL)
=VLOOKUP(A2, A1:C10, 3, FALSE)
๐ Use it to:
- Find student results
- Retrieve prices
- Match records
๐ CONCATENATION
=A1 & " " & B1
๐ Combine First Name + Last Name
๐จ Conditional Formatting
Highlight automatically:
- Fail scores (red)
- High scores (green)
๐ต 4. DATA MANAGEMENT
๐ฝ Sorting
- A → Z
- Highest → Lowest
๐ Filtering
Show only:
- Passed students
- Specific department
๐ Data Validation
Restrict input:
- Only numbers
- Dropdown list
๐ด 5. ADVANCED LEVEL
๐งฎ Pivot Tables (๐ฅ VERY IMPORTANT)
๐ Used for:
- Summaries
- Reports
- Dashboards
Example:
- Total sales by department
- Student performance summary
๐ Charts
Types:
- Bar Chart
- Pie Chart
- Line Chart
๐ Convert data into visuals
๐ Advanced Functions
INDEX + MATCH (Better than VLOOKUP)
=INDEX(C1:C10, MATCH(A2, A1:A10, 0))
COUNTIF / SUMIF
=COUNTIF(A1:A10, "Pass")
=SUMIF(A1:A10, "Pen", B1:B10)
⚙️ 6. AUTOMATION (ADVANCED)
๐น Flash Fill
Auto-completes patterns
๐น Macros (Intro)
- Record repetitive tasks
- Automate work
๐น Power Query (Advanced Users)
- Clean large data
- Import data
๐ง๐ซ 7. TEACHING FLOW (FOR YOUR CLASS)
๐ข Day 1:
- Excel Interface
- Data Entry
- AutoFill
๐ก Day 2:
- Formulas & Functions
๐ต Day 3:
- IF, VLOOKUP
- Data Validation
๐ด Day 4:
- Pivot Tables
- Charts
๐ฏ 8. PRACTICAL CLASS WORK
✅ Task 1:
Create student result sheet:
- Name
- Score
- Grade (IF)
✅ Task 2:
Create business sheet:
- Cost price
- Selling price
- Profit/Loss
✅ Task 3:
Filter:
- Only students who passed
✅ Task 4:
Create chart for results๐ก REAL-LIFE APPLICATION (VERY IMPORTANT)
You can use Excel for:
School results- Financial records
- Attendance tracking
- Registry operations (very relevant to your training ๐ฅ)
๐ PRO TEACHING TIP (FOR YOU)
When teaching:
๐ Don’t explain too much
๐ Let them DO more practicals
