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
EANE MEMBERS | $180 Per person
FUTURE MEMBERS | $225 Per person
Register 3 or more participants at the same time for the same class and save 10%