Zenler Player
Your course is loading. Hang tight.
Excel for Beginners
Back to curriculum
0% Complete
0% Complete
Welcome to the course
Writing simple formulas and copying them
What is absolute and relative referencing?
Introduction to IF Statements
Nested IF statements for multiple conditions
Aggregate based on a condition using SUMIF
Creating simple lists
Creating dependent lists
Finding related data using VLOOKUP
Two way lookup using INDEX & MATCH
Creating Pivot Tables
Recommended Pivot Tables
Adding interactivity with Slicers
Creating column charts
Creating pie-charts
Creating stacked charts
Highlight cells based on their values
Highlight top or bottom values
Creating data bars
Creating colour scales
Making simple forecasts
Quiz - Excel for Beginners
Assignment
Welcome
Welcome to the course
Excel Foundation
Writing simple formulas and copying them
What is absolute and relative referencing?
Introduction to IF Statements
Nested IF statements for multiple conditions
Aggregate based on a condition using SUMIF
Creating simple lists
Preview
Creating dependent lists
Analysis & Visualization
Finding related data using VLOOKUP
Two way lookup using INDEX & MATCH
Creating Pivot Tables
Preview
Recommended Pivot Tables
Adding interactivity with Slicers
Creating column charts
Creating pie-charts
Creating stacked charts
Highlight cells based on their values
Highlight top or bottom values
Creating data bars
Creating colour scales
Making simple forecasts
Wrap-up & Review
Quiz - Excel for Beginners
Assignment
×
This is an unpublished lesson. This lesson will not be shown for students unless you set it as Public.
Back to Dashboard
No contents are available in this lesson!
No lessons available!
Back to Dashboard
Lesson contents locked
Enroll to unlock this lesson.
Enroll to unlock
Mark Complete