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
Logical Tests & Conditional Statements
You don’t have access to this lesson
Please register or sign in to access the course content.
Take course
Sign in
Previous
Next