Data analysis

You will learn:

• how to combine the IF-function with SUM, AVERAGE and COUNT.
• how to make nested IF-functions.
• how to use the AND- and OR-functions to analyze simple conditions.

We will go through 16 exercises where you will learn to analyse datasets. A typical question you will learn to answer is:

How many units of "Product 1" did "Region West" sell during "Sales Campaign XYZ" in "October"?

This is part of The Complete Excel Blueprint. You'll have a 30-day Full Refund.