21WA-0537: Mastering Advanced Excel Functions and Formulas (Webinar)
If you have questions about this event, please call us at 952-831-2707.
Friday, April 23, 2021
11:00am - 12:50pm Central Time
2 CPE (2 non-technical)
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.
Major subjects
-
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
Learning objective(s)
-
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
Who should take this program?
All
Fees
Our records indicate
you are a
nonmember.
If you register, you will be charged
$79.00
(Standard Nonmember Fee).
Members: Please
log in
to receive member fee.
|
Standard Member Fee |
$79.00
|
 Standard Nonmember Fee |
$79.00
|
