Course
It
Features
Courses
How it works
Pricing
Start learning
Start learning
Satish Dhawale · 15h 07m · 79 lessons
Learn Full Excel Course from Basic to Advanced with AI | Excel AI Masterclass 2026
Already know some of this? A 2-minute test skips the lessons you know.
Take the placement test
The plan
9 days at 90 min a day
Day 1
(today)
Day 2
Day 3
Day 4
Day 5
Day 6
Day 7
Day 8
Day 9
Day 1
8 lessons · 1h 42m
Today
1
Excel Introduction & Interface Overview
Understand the Excel welcome screen, workbook vs worksheet, ribbon tabs/groups, Quick Access Toolbar, Name Box, Formula Bar, Status Bar, sheet navigation, and basic view modes.
10m
Notes and quiz
2
Data Entry Basics & Essential Shortcuts
Enter and edit data efficiently using Fill Handle, Ctrl+D/Ctrl+R, Flash Fill, and shortcuts like Shift+F11 for new sheets; adjust column widths with double-click.
20m
Notes and quiz
3
Basic Formulas: SUM, AVERAGE, MAX, MIN, COUNT, COUNTA
Apply essential statistical formulas (SUM, AVERAGE, MAX, MIN, COUNT, COUNTA) using AutoSum and shortcuts (Alt+=), and understand relative references.
20m
Notes and quiz
4
IF Formula Logic & Nesting (part 1 of 4)
Build logical conditions with IF, nest multiple IFs for complex grading/promotion logic, and use IFS for cleaner multi-condition formulas in newer versions.
10m
Notes and quiz
5
IF Formula Logic & Nesting (part 2 of 4)
Build logical conditions with IF, nest multiple IFs for complex grading/promotion logic, and use IFS for cleaner multi-condition formulas in newer versions.
10m
Notes and quiz
6
IF Formula Logic & Nesting (part 3 of 4)
Build logical conditions with IF, nest multiple IFs for complex grading/promotion logic, and use IFS for cleaner multi-condition formulas in newer versions.
10m
Notes and quiz
7
IF Formula Logic & Nesting (part 4 of 4)
Build logical conditions with IF, nest multiple IFs for complex grading/promotion logic, and use IFS for cleaner multi-condition formulas in newer versions.
10m
Notes and quiz
8
Conditional Formatting Deep Dive (part 1 of 5)
Highlight cells using rules (Greater Than, Less Than, Between, Text Contains, Date Occurring, Duplicate), manage rules, apply Color Scales, Icon Sets, and Data Bars for visual analysis.
12m
Notes and quiz
Learn Full Excel Course from Basic to Advanced with AI | Excel AI Masterclass 2026 · CourseIt