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
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/
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.