-
Introduction
-
Activity Asset Download
-
Nested IF
-
Cross-sheet Formulas
-
VLOOKUP
-
INDEX/MATCH
-
COUNTIFS
-
SUMIFS
-
Wrap-up
-
Intermediate Formulas Knowledge Check
-
Course Evaluation

Intermediate Formulas
Learn about functions like SUMIF, COUNTIF, VLOOKUP, and INDEX and MATCH
Within these lessons, you will learn about functions like Nested IF, SUMIF, COUNTIF, SUMIFS, COUNTIFS, VLOOKUP, INDEX and MATCH, as well as how to use these functions across multiple sheets.