Webinar

K2's Mastering Advanced Excel Functions and Formulas Webcast | 4204363C

  • Monday, November 23, 2020

    11:00am – 12:40pm
    (Registration: 10:30am)
  • 2
    CREDITS
    Computer Software and Applications




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.

Objectives




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

Highlights




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

Additional Information

Designed For




Busy accounting and financial professionals who want to improve their personal and organizational productivity

Vendor

CalCPA

Advanced Preparation

None.

Credits

2.00 Computer Software and Applications

Prerequisite




Fundamental knowledge of hardware, software, and technology trends

Course Number

204204363C

Level of Knowledge

Update

Add to Cart

View All Courses