K2's Mastering Advanced Excel Functions and Formulas - On Demand (2 CPD Hours)

K2's Mastering Advanced Excel Functions and Formulas - On Demand (2 CPD Hours)

  • $79.00


Course Description

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 Covered

  • 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 Objectives

    Upon completing this course, you should be able to:

    • 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 Attend: Accountants and finance professionals who want to become more productive in using Excel

      Course Level: Intermediate

      CPD Credits: 2 Hours Computer Software and Applications  

      Prerequisites: Good working knowledge of Excel

      Advance Preparation: None

      Instructional Delivery Method: QAS on-demand learning, including review and final exam questions. To earn credit, participants must pass the final exam with a score of 70% or better within one year of registering for this course. Participants may attempt take the final exam up to 10 times.