First, you can download the Full Course here from the Microsoft website, or watch the videos online:
1 – Advanced IF Function
Before we get started with advanced IF functions, let’s do a quick IF function refresher first. Watch this video for some examples.
2 – Nested IF Function
Nested IF functions, meaning one IF function inside of another, allow you to test multiple criteria and increases the number of possible outcomes.
3 – IF Function with AND & OR Nested
Watch this video to see how to extend the functionality of the IF function by nesting AND and OR functions.
4 – Working with COUNTIFS and SIMIFS
COUNTIFS applies criteria to cells across multiple ranges and counts the number of times all criteria are met. SUMIFS adds the cells in a range that meet multiple criteria.
5 – IFERROR and AVERAGEIFS
AVERAGEIFS returns the average of all cells that meet multiple criteria. IFERROR returns the value specified if AVERAGEIFS evaluates to an error.
Source: From Microsoft’s Online Course Page