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

Webinar(CA): K2’s Mastering Advanced Excel Functions and Formulas

Description

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.

Learning 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

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
California CPA Education Foundation
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)
Tom Stevenson
Prerequisites

Fundamental knowledge of hardware, software, and technology trends

Advanced Preparation

None

Location
Webinar
Event Information
When
Feb 15, 2021
1:00 pm - 2:40 pm MST
Location
Webinar
Total CPE Credits
2
Format
Webinar

MEMBER


$ (% off)
$75.00

NON-MEMBER


$ (% off)
$101.00
Become A Member

Register for this Event

Webinar(CA): K2’s Mastering Advanced Excel Functions and Formulas


Your browser is out-of-date!

Update your browser to view this website correctly.

Update my browser now

×