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.


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


Share →

Leave a Reply

Your email address will not be published.

For More Information

Call us to 1-800-819-6307 or email: