EXCEL - FORMULAS, FORMULAS, FORMULAS
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 | $196 Per person
FUTURE MEMBERS | $245 Per person
Register 3 or more participants at the same time for the same class and save 10%
Contact Us
To find out more about the services we offer, or to speak with a specialist about your specific needs, complete this form and one of our experts will reach out to you shortly.
Can’t wait? Call us now at 877.662.6444