All 2020 CPE and networking events have been moved online. Visit our updated catalog »

K2’s Mastering Advanced Excel Functions and Formulas (On-Demand) 2020

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.

Format: 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.

Learning Objectives

Upon completing this session, 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
Major Topics
  • 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
Provider
K2 Enterprises, LLC
Course Level
Update
CPE Field of Study
Computer Software and Applications
2
Who Should Attend

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

Instructor(s)
Mac McClelland
Prerequisites

Fundamental knowledge of hardware, software, and technology trends

Purchase Now
When
Available 24/7
Location
Online
Total CPE Credits
2
Format
On-Demand

MEMBER


$ (% off)
$79.00

NON-MEMBER


$ (% off)
$103.00
Become A Member

Purchase This Program

K2’s Mastering Advanced Excel Functions and Formulas (On-Demand) 2020


Your browser is out-of-date!

Update your browser to view this website correctly.

Update my browser now

×