Microsoft 365 Excel
Course Practice Files All Excel files used in topics and labs — download in one place
Access All Files
Microsoft Certified Trainer Microsoft 365 English · LTR

Microsoft 365
Excel

A structured, hands-on course covering Excel from the ground up. Each topic builds on the last — formulas, conditional logic, lookup functions, and beyond — with practice files you work through as you go.

Start the Course Leave Feedback
12
Topics
6
Labs
✓
Practice files
365
Excel version
EN
Language

What you'll learn

Write formulas using cell references, named ranges, and table syntax
Apply COUNTIF and SUMIF for conditional calculations
Format data dynamically with rules, formulas, and visual scales
Look up data with VLOOKUP, XLOOKUP, and INDEX / MATCH
Handle bracket lookups for tax rates and discount schedules
Filter entire datasets using logical conditions and operators
Build two-dimensional dynamic lookups that adapt to any input
Know when each function is the right tool — and why

Course Outline

Foundations
3 topics · 2 labs
Topic 01 Basic Rules Topic 02 Advanced Formulas Lab 02 profit.xlsx Lab Topic 03 Conditional Formatting Lab 03 CF Practice Lab
Lookup Functions
5 topics · 1 lab
Topic 04 VLOOKUP Topic 05 XLOOKUP Topic 06 VLOOKUP Approximate Topic 07 FILTER Topic 08 MATCH & INDEX Lab Lookup Practice Lab
Advanced & Errors
4 topics · 3 labs
Topic 09 Data Validation Lab 09 DV Practice Lab Topic 10 Logical Functions Lab 10 Logical Lab Lab Topic 11 Protection Lab 11 Protection Lab Lab Topic 12 Excel Errors New

Your Trainer

A
Ahmed Farouk
Microsoft Certified Trainer · Doha, Qatar
MCT Microsoft 365 Power BI Google Workspace askfarouk.net