Excel now has approximately 500 functions, many unused by accounting and finance professionals. This two-hour session will improve your Excel productivity, by introducing powerful and timesaving functions. This session is a must for Excel Users.
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
Using financial functions to calculate loan payments, depreciation, and cash flows
Retrieve summarized data with the GETPIVOTDATA and CUBEVALUE functions
Making sophisticated calculations with array formulas
Busy accounting and financial professionals who want to improve their personal and organizational productivity
Fundamental knowledge of hardware, software, and technology trends
None