Creating Formulas and Working with Built-In Functions Including Lookup
Excel Level 3 is a four-hour instructor-led class taking participants to an advanced level using formulas and functions, including the following:
- IF, AND, OR, NOT Logic Functions
- Creating Nested Functions
- VLOOKUP, HLOOKUP, XLOOKUP
- Date/Time & Text Functions
- SUMIF, SUMIFS, AVERAGEIF, COUNTIF, and Variants
- Formula Auditing Tools
- 3D References
- Subtotals
By the end of the class, participants will be able to manipulate large data sets quickly using a variety of advanced functions, including logical and lookup functions.
Date: Friday, October 9, 2026
Time: 9:00am – 1:00pm
Presented by: Data Creative
Cost: $199 (members) / $299 (non-members)
This session requires participants to be comfortable with basic formulas, cell references, and working with data ranges or tables. Excel Levels 1 and 2 is strongly encouraged. Access to Microsoft Excel (Microsoft 365, Excel 2021, or Excel 2019) on a Windows PC or Mac is required to participate in this training.
