The Library is closed due to ongoing flood remediation.

All programs scheduled for this week will be either cancelled or relocated. If you have registered for a class or program this week, you will soon be receiving an email indicating either a change of venue or cancellation notice from the program coordinators.

Please check back soon for more updates. Our digital library is always open.   

 

Excel Master Class: Conditional Stat Functions

Primary tabs

Age Group:

Adults
Please note you are looking at an event that has already happened.
Registration for this event is no longer open.

Program Description

Event Details

Excel Master Class comprises classes designed for students who have completed the Beginner and Intermediate Excel courses or possess a solid foundational understanding of Excel.

 Each class will explore a specific topic thoroughly, followed by exercises that allow students to apply their newfound knowledge to real-world scenarios.

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.

Required Skills:

  • Be able to write a basic formula and function

  • Be able to write Relative and Absolute cell references

Upcoming class Topics include: Charts & Sparklines, Pivot Tables, LOOKUP and INDEX/MATCH, Array Formulas, Tables, and Data Validation, LOOKUP and INDEX MATCH, and Creating a Dashboard.