Excel Genius 2: Conditional Stat Functions
Excel Genius 2: Conditional Stat Functions
Description:
This class covers how to take the basic logic from Class 1 and use it to create functions that process data based on conditions. Topics include SUMIF/AVERAGEIF/COUNTIF and SUMIFS/AVERAGEIFS/COUNTIFS.
Skills Required:
Be able to write a basic formula and function
Be able to write Relative and Absolute cell references
Have Taken Class 1 or understand the material covered in it
Prerequisites:
Beginner and Intermediate Excel, Excel Genius Class 1
Class Handout: