K2's Mastering Advanced Excel Functions and Formulas
Earn 2 CPE Credits!
Exam price $89.
OR

All of our materials/exams are NASBA and the AICPA approved the revisions to the Statement on Standards for Continuing Professional Education (CPE) Programs (Standards).

Your Exam purchase includes

  • Course materials (video & PDF version)
  • Unlimited attempts to complete exam
  • Instant grading & certificate of completion
  • One year access to complete your CPE
  • Instructor discussion forum



Overview

Excel has more than 400 functions, many of which are unused by most accounting and finance professionals. Some of these little used functions can be used to calculate depreciation, mortgage interest and principal reduction, cash flow analysis over unequal periods, and trap errors. It's time for you to break out of your Excel cocoon. This two-hour session will put you on the path to improved Excel productivity by introducing you to powerful and time saving but little used Excel functions. Among other topics, you will learn about logical and conditional formulas, including using Boolean operators; advanced financial formulas such as XNPV and XIRR; innovative uses for Excel's date functions, and SUMPRODUCT, GETPIVOTDATA, and INDIRECT.

  • Use Excel's financial functions to compute depreciation, calculate mortgage interest and principal reduction, and perform conventional cash flow analysis
  • List three Excel functions for making conditional calculations that can evaluate multiple conditions
  • Explain the general process of entering an array formula in Excel
  • Describe the benefits of using GETPIVOTDATA for extracting summarized data from a PivotTable
  • None
  • Good working knowledge of Excel
  • Intermediate
  • 103648

No Reviews