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

Webinar(CA): K2’s The How’s and Why’s of Creating User Defined Functions in Excel

Description

With approximately 500 functions Excel seems to have one for every need. But sometimes the function YOU need just simply isn’t available. For example, Excel functions can’t calculate income tax expense or depreciation. Learn to create User Defined Functions (UDFs) to meet your unique needs, in formulas and to automate complex calculations. Join us to put the power of UDFs to work!

Learning Objectives

Define the role of a User Defined Function in Excel
List the steps necessary to create and save a UDF
Differentiate between key phrases used in creating UDFs
Create formulas that incorporate UDFs

Major Topics

Examining UDFs relative to macros
Identifying the steps necessary to creating UDFs in Excel
Understanding where you should save UDFs
Key syntax when creating UDFs
Incorporating UDFs into your workbooks

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
Register Now
When
Jul 31, 2020
9:00 am - 10:40 am MDT
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 The How’s and Why’s of Creating User Defined Functions in Excel


Your browser is out-of-date!

Update your browser to view this website correctly.

Update my browser now

×