- This event has passed.
Mastering Advanced Excel Functions and Formulas
December 2, 2020 @ 9:55 am - 11:35 am
Excel now has approximately 500 functions, many of which are unused by most accounting and finance professionals. This two-hour session will put you on the path to improved Excel productivity by introducing you to powerful and timesaving, but little used, Excel functions. If you want to improve your knowledge and efficiency with Excel, this session is a must for you.
List the three Excel functions for computing payments, payment interest, and principal write down Differentiate between the GETPIVOTDATA and CUBEVALUE functions
Recognize similarities in using the SUBTOTAL and AGGREGATE functions
Identify the steps necessary to create array formulas using ordinary Excel functions