Course Content
MODULE 1: Excel Fundamentals
0/9
Lesson 1: Welcome to Your Excel Journey
Lesson 2: What is Microsoft Excel?
Lesson 3: Where is Excel Used?
Lesson 4: Excel Versions & File Types
Lesson 5: Workbook vs Worksheet
Lesson 6: Excel Interface Overview
Lesson 7: Rows, Columns & Cells
Lesson 8: Cell Referencing Basics
Lesson 9: Practice – Create Your First Worksheet
MODULE 2: Data Entry, Formatting & Productivity
0/19
Lesson 1: Why Data Accuracy Matters
Lesson 2: Understanding Student Data Types
Lesson 3: Entering Data Correctly in Excel
Lesson 4: Adjusting Rows, Columns & Alignment
Lesson 5: Formatting Text, Numbers & Dates
Lesson 6: Using Fonts, Colors & Borders
Lesson 7: Introduction to Conditional Formatting
Lesson 8: Highlighting Student Performance
Lesson 9: Data Validation – Preventing Wrong Entries
Lesson 10: Creating Dropdown Lists for Subjects
Lesson 11: Freeze Panes for Large Student Lists
Lesson 12: Sorting Student Records
Lesson 13: Filtering Student Data
Lesson 14: Copy, Paste & Paste Special
Lesson 15: Keyboard Shortcuts for Productivity
Lesson 16: Practice – Create a Student Marksheet
Lesson 16: Practice – Create a Student Marksheet
Lesson 17: Practice – Attendance Tracker
Lesson 18: Common Data Entry & Formatting Mistakes
MODULE 3: Excel Formulas & Functions
0/18
Lesson 1: Introduction to Excel Formulas
Lesson 2: Understanding Formula Structure
Lesson 3: Using the SUM Function
Lesson 4: Calculating Average Marks
Lesson 5: COUNT & COUNTA Functions
Lesson 6: Finding Highest & Lowest Marks
Lesson 7: Calculating Percentage
Lesson 8: Introduction to Logical Functions
Lesson 9: Using IF Function for Pass / Fail
Lesson 10: Assigning Grades Using IF
Lesson 11: Using Nested IF for Multiple Grades
Lesson 12: Text Functions – Cleaning Student Names
Lesson 13: Using CONCAT to Combine Text
Lesson 14: Copying Formulas Using Fill Handle
Lesson 15: Common Formula Errors
Lesson 16: Practice – Student Total & Percentage
Lesson 17: Practice – Pass/Fail & Grades
Quick Quiz – Module 3
MODULE 4: Lookup & Logical Functions
0/1
Lesson 1: Introduction to Lookup & Logical Functions
Microsoft Excel

What is data validation?

It restricts incorrect data entry.

Examples

  • Marks between 0 and 100

No text allowed in the marks column

Previous
Next