Description

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.

Details

10/09/2026 09:00:0010/09/2026 13:00:00America/Los_AngelesMICROSOFT EXCEL LEVEL 3 – FORMULAS & FUNCTIONS (WEBINAR)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.
Reno, NV
Event StartsEvent Ends
10/09/202610/09/2026
All Day Event
9:00am1:00pm
Register Here