Fundamental Microsoft Excel Skills
0 of 17 lessons complete (0%)
Exit Course
Course Assessment
Course Assessment
1 lesson, 1 quiz
Fundamental MS Excel Skills
Learning Outcomes
Lesson Summary
Conclusion
The FILTER function
UNIQUE, SORT and SORTBY
Dynamic Arrays – Pivot table Alternatives
Basic Points on Dynamic Arrays
Pivot Table Overview
Working with Tables
XLOOKUP
INDEX and MATCH
VLOOKUP
Sum with Criteria
IF Statements
Logical Tests & Conditional Statements
Introduction
16 lessons
Fundamental MS Excel Skills
VLOOKUP
You don’t have access to this lesson
Please register or sign in to access the course content.
Take course
Sign in
Previous
Next