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)
Interested in mastering Microsoft Excel? Register for all four sessions and get discounted pricing. Learn more here.
