Excel Formulas and Functions 2018

Topics

• How to use selected Text functions to extract and manipulate character and numerical data for sorting and analytical purposes
• How to look up information in tables and reconcile different lists using the VLOOKUP function; for specialized lookup needs, learn to use the MATCH and INDEX functions
• How to harness the power gained from using multiple functions in a nested fashion
• How to build 3-D formulas to tabulate data totals from multiple worksheets
• How to use the powerful IF function and the related AND and OR functions for programming-like capability
• How and when to use the expanded capabilities of the COUNTF family of functions and newer functions -AGGREGATE, ARABIC, ISFORMULA, and FORMULATEXT

Who should Attend

Any Excel user who Needs to go Beyond the Basics of using Formulas or Simply wants to become more Comfortable and Productive in using Excel formulas and functions.