Thanksgiving Holiday Library Hours

The Library will close at 5PM on Wednesday, Nov. 27, and will be closed on Thursday, Nov. 28, and Friday, Nov. 29.  Happy Thanksgiving!

Excel Master Class: Conditional Stat Functions

Program Type:

Classes & Workshops, Featured, Technology & STEM

Age Group:

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

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.