In this instructor-led course you will learn how to up your formula knowledge in Excel. These formulas will allow you to make your spreadsheets more dynamic. We will discuss the importance of absolute cell addressing and then move to these exciting formulas.
| XLOOKUP/VLOOKUP | FILTER | SORT |
| INDEX/MATCH COMBO | SUMIFS/COUNTIFS | COMBINATION FORMULAS UTILIZING AND/OR/NOT |
| IFERROR | IFNA | RANK |
| SEQUENCE | LARGE/SMALL (TOP/BOTTOM) | CEILING/FLOOR |
| DAYS | NETWORKDAYS | EDATE |
| EOMONTH | COUNTBLANK |
Who Should Attend
Prerequisite: Excel Level 1
Registration Fee 2026
EANE MEMBERS | $240 Per person
FUTURE MEMBERS | $280 Per person
Register 3 or more participants at the same time for the same class and save 10%