Skip to content

Microsoft Excel Essentials

🔵 Module 1: Excel Fundamentals

Lesson 1: Basics of Excel- Layout and Spreadsheet Structure Sample Lesson

Lesson 1 Quiz – 🧠 Test Your Understanding

Lesson 2 – Entering and Managing Data in Excel Cells

Lesson 2 Quiz – 🧠 Test Your Understanding

Lesson 3: How to Use Formulas and Understanding Cell References

Lesson 3 Quiz – 🧠 Test Your Understanding

Lesson 3.1: Understanding Cell References (Relative, Absolute & Cross-Sheet Referencing)

Lesson 3.1 Quiz – 🧠 Test Your Understanding

Lesson 4: Introduction to Functions — SUM, AVERAGE, MAX, MIN, COUNT

Lesson 4 Quiz – 🧠 Test Your Understanding

Lesson 4.1: How to Handle Formula Errors with the IFERROR() Function

Lesson 4.1 Quiz – 🧠 Test Your Understanding

Lesson 5 – Formatting Text, Numbers, and Cells in Excel

Lesson 5 Quiz – 🧠 Test Your Understanding

🟢 Module 2: Data Visualization & Output

Lesson 6 -How to Create Charts in Excel

Lesson 6 Quiz – 🧠 Test Your Understanding

Lesson 7: How to Print, Publish, Share, and Save

Lesson 7 Quiz – 🧠 Test Your Understanding

🟡 Module 3: Data Management & Analysis

Lesson 8: How Excel Calculates ( Order of Operations )

Lesson 8 Quiz – 🧠Test Your Understanding

Lesson 9 – How Excel Stores and Handles Dates and Times

Lesson 9 Quiz – 🧠 Test Your Understanding

Lesson 10 – Conditional Formatting in Excel – Highlight Key Data Instantly

Lesson 10 Quiz – 🧠 Test Your Understanding

Lesson 11 – How to Use Filters in Excel to Focus Your Data

Lesson 11 Quiz – 🧠 Test Your Understanding

Lesson 12 – How to Create Dynamic Filters with the FILTER Function

Lesson 12 Quiz – 🧠 Test Your Understanding

Lesson 13 – How to Use the XLOOKUP Function in Excel

Lesson 13 Quiz – 🧠 Test Your Understanding

Lesson 14 – Pivot Tables in Excel – How to Organize & Analyze Data

Lesson 14 Quiz – 🧠 Test Your Understanding

Lesson 15 – How to Sort Data Effectively in Excel

Lesson 15 Quiz – 🧠 Test Your Understanding

🟠 Module 4: Data Cleaning & Automation

Lesson 16: How to Split Text into Separate Columns in Excel

Lesson 16 Quiz – 🧠 Test Your Understanding

Lesson 17 – How to Clean Data Fast with the TRIM Function in Excel

Lesson 17 Quiz – 🧠 Test Your Understanding

Lesson 18 – How to Speed Up Your Data Entry with Flash Fill Tool in Excel

Lesson 18 Quiz – 🧠 Test Your Understanding

Lesson 19 – How to Use Data Validation to Control User Input in Excel

Lesson 19 Quiz – 🧠 Test Your Understanding

Lesson 20 – How to Organize and Summarize Your Data in Excel Using Grouping and Subtotals

Lesson 20 Quiz – 🧠 Test Your Understanding

🟣 Module 5: Productivity Enhancers

Lesson 21 – How to Use Macros in Excel: A Step-by-Step Beginner’s Guide

Lesson 21 Quiz – 🧠 Test Your Understanding

Lesson 22 – How to Keep Headers Visible ( Freeze & Split in Excel )

Lesson 22 Quiz – 🧠 Test Your Understanding

Lesson 23: How to Protect Data and Control Editing in Excel

Lesson 23 Quiz – 🧠 Test Your Understanding

Lesson 24: How to Create Dynamic Reports with 3D Formulas in Excel

Lesson 24 Quiz – 🧠 Test Your Understanding

Lesson 25: Excel Shortcuts for Quick Formatting & Selection

Lesson 25 Quiz – 🧠 Test Your Understanding

Lesson 26 – How to Create an Easy Data Entry Forms in Excel

Lesson 26 Quiz – 🧠 Test Your Understanding

Lesson 1: Basics of Excel- Layout and Spreadsheet Structure

Microsoft Excel Essentials
Lesson 1: Basics of Excel- Layout and Spreadsheet Structure

Lesson Content

Lesson 1 Quiz – 🧠 Test Your Understanding

Cart (0)

Savings

$145.06

Subtotal

$0.00

Checkout ($0.00)

Login

Accessing this course requires a login. Please enter your credentials below!

Username or Email Address

Password

Remember Me

Lost Your Password?

Register

Don't have an account? Register one!

Register an Account