Excel Advanced 2: Advanced Formulas
Class Details
Length of class: three hours
Price per person: $149
Version covered: for Office 365
Description
In this three-hour session for Windows and Mac users, you will learn how to write complex formulas using Excel's advanced built-in functions. You will expand your library of functions to include lookup and reference functions, conditional logic, and dynamic array functions. You will also become expert at using mixed references to make copying formulas horizontally and vertically work the way it should.
Prerequisites
This class is ideally suited for those who have attended the Excel Beginning 2: Simple Formulas class or who are already comfortable creating basic formulas like SUM, AVERAGE, COUNT, LEFT, MID, RIGHT and PMT.
Outline
Lookup and Reference Functions
- VLOOKUP and HLOOKUP to fetch values from a list
- nesting functions inside functions
- absolute references and mixed references
- conditional formatting
- lookups in tables, and structured references
- range lookups
- range names
- INDEX and MATCH for more versatile lookups
- creating in-cell drop-down menus
- XLOOKUP function
Logical Functions
- IF function to construct conditional logic
- AND and OR functions for multiple conditions
- IFS function
- IFERROR function
- COUNTIF, COUNTIFS, SUMIF, SUMIFS
Dynamic Array Formulas
- SEQUENCE function
- SORT and FILTER functions
- UNIQUE function
Upcoming Dates
Tuesday, May 21, 2024
8:00 AM - 11:00 AM
Monday, July 8, 2024
12:00 PM - 3:00 PM
Saturday, July 27, 2024
8:00 AM - 11:00 AM
Thursday, August 15, 2024
12:00 PM - 3:00 PM