This course is designed to help learners of all levels build a strong foundation in

Excel formulas and use them to solve real-world problems. Whether you're a

student, a fresh graduate, or a working professional, this course teaches you

how to work smarter not harder using Excel.

You'll start from the basics and progress toward practical examples and case

studies, with a focus on speed, clarity, and efficiency.

Chapter 1: Getting Started with Excel

1.1 Course Introduction (5 mins)

1.2 Overview (3 mins)

1.3 What is Excel & Why Use It? (2 mins)

1.4 Understanding The Excel Interface (8 mins)

1.5 Workboos & Worksheets (3 mins)

1.6 Navigating Cells, Rows, and Columns (3 mins)

1.7 Selecting and Managing Ranges (3 mins)

1.8 Basic Formatting Tools (10 mins)

1.9 Saving and Organizing Your Files (3 mins)

1.10 Best Practices Before Starting Any Sheet (2 mins)

1.11 Exercise: Student Attendance Tracker (5 mins)

1.12 Getting Started With Excel - Quiz

Chapter 2: Working with Data Efficiently

2.1 Overview (4 mins)

2.2 Sorting Data (5 mins)

2.3 Filtering Data (5 mins)

2.4 Freeze Panes (3 mins)

2.5 Data Validation (5 mins)

2.6 Cleaning and Structuring Data (7 mins)

2.7 Best Practices for Readable Sheets (4 mins)

2.8 Working With Data Efficiently - Quiz

Chapter 3: Basic Formulas and Functions

3.1 Overview (3 mins)

3.2 What is a Formula in Excel? (5 mins)

3.3 Using Math Operators in Excel (3 mins)

3.4 Writing Formulas with Cell References (3 mins)

3.5 Relative & Absolute References (3 mins)

3.6 Most Common Basic Functions (5 mins)

3.7 Formula Errors and How to Avoid Them (3 mins)

3.8 Exercise: Formula-Powered Sales Report (3 mins)

3.9 Basic Formulas and Functions - Quiz

Chapter 4: Logical Functions

4.1 Overview (4 mins)

4.2 Logical Thinking in Excel (3 mins)

4.3 The IF Function (5 mins)

4.4 Combining Conditions with AND & OR (5 mins)

4.5 Using the NOT Function (3 mins)

4.6 Nested IF Statements (6 mins)

4.7 Real-World Examples of Logical Functions (2 mins)

4.8 Common Mistakes with Logical Formulas (3 mins)

4.9 Exercise: Employee Performance Evaluation (3 mins)

4.10 Logical Functions - Quiz

Chapter 5: Lookup & Reference Functions

5.1 Overview (3 mins)

5.2 Introduction to Lookup Functions (3 mins)

5.3 VLOOKUP - Vertical Lookup (5 mins)

5.4 HLOOKUP - Horizontal Lookup (3 mins)

5.5 INDEX Function (4 mins)

5.6 MATCH Function (3 mins)

5.7 Combining INDEX + MATCH for Dynamic Lookups (6 mins)

5.8 INDEX + MATCH VS. VLOOKUP (3 mins)

5.9 Exercise: Find It Like a Pro (2 mins)

5.10 Lookup & Reference Functions - Quiz

Chapter 6: Text Functions

6.1 Overview (3 mins)

6.2 Introduction to Text in Excel (3 mins)

6.3 Using LEFT, RIGHT, and MID to Extract Text (6 mins)

6.4 Finding Positions with FIND and SEARCH (3 mins)

6.5 Combining Text with TEXTJOIN, CONCAT, and & (4 mins)

6.6 Cleaning and Restructuring Text in Excel (4 mins)

6.7 Extracting & Formatting Text from Mixed Data (7 mins)

6.8 Text Functions - Quiz

Chapter 7: Date & Time Functions

7.1 Overview (3 mins)

7.2 How Excel Handles Dates & Times (4 mins)

7.3 TODAY() and NOW() Functions (3 mins)

7.4 Date Calculations with DATEDIF() and EDATE() (7 mins)

7.5 Working with Days: WORKDAY() and NETWORKDAYS() (8 mins)

7.6 Displaying Dates the Right Way (4 mins)

7.7 Real-World Applications of Date Functions (3 mins)

7.8 Exercise: Mastering Dates in the Real World (4 mins)

7.9 Date & Time Functions - Quiz7.9

Chapter 8: Error Handling

8.1 Overview (3 mins)

8.2 Recap Common Excel Errors (3 mins)

8.3 The IFERROR() Function – Handling Any Error (5 mins)

8.4 Difference Between IFERROR() vs ISERROR() vs ISNA() (6 mins)

8.5 Nesting Error Handling into Complex Formulas (3 mins)

8.6 Best Practices for Debugging Formulas (5 mins)

8.7 Error Handling - Quiz

Chapter 9: Powerful Data Analysis Tools

9.1 Overview (5 mins)

9.2 Introduction to Conditional Functions (3 mins)

9.3 SUMIF – Summing with a Single Condition (3 mins)

9.4 COUNTIF – Counting Based on a Condition (3 mins)

9.5 AVERAGEIF – Conditional Averaging (3 mins)

9.6 Understanding the Shift to IFS Versions (2 mins)

9.7 Working with SUMIFS, COUNTIFS, and AVERAGEIFS (12 mins)

9.8 Common Pitfalls and How to Avoid Them (3 mins)

9.9 Exercise: Regional Sales Summary (2 mins)

9.10 Quick Look at Pivot Tables (8 mins)

9.11 Powerful Data Analysis Tools - Quiz

Chapter 10: Building Practical Solutions

10.1 Tracker & Budget Monitor - Overview (2 mins)

10.2 Task 1: Raw Expense Data Sheet (12 mins)

10.3 Task 2: Budget Sheet (9 mins)

10.4 Task 3: Summary Sheet (12 mins)

10.5 Task 4: Charts & Visuals (17 mins)

Chapter 11: Revision Tips & Final Project

11.1 Revision and Bonus Tips (7 mins)

11.2 Final Project: Sales Tracker & Performance Dashboard (4 mins)

Thank You (1 mins)