- IF statements and Nested IF Statements
- IFERROR formula
- SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIFS, and MAXIFS
- Evaluate formulas to see how values are calculated. Useful for correcting formula if they are not working correctly
- UNIQUE and Transpose Formulas
- Using wildcard characters in formulas
The course relies heavily on teaching through various business scenarios, so that it is easy to understand the concept. This approach also allows you to intuitively relate to your own work setting and accelerate application of these concepts at work.