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

Webinar(CA): K2’s Extending the Power of Excel with Useful Add-Ins

Description

There are many free or low-cost add-ins available to enhance Excel. Included are Microsoft’s Fuzzy Lookup add-in, along with countless apps from the Office Store. Additionally, tools such as RiskAMP facilitate Monte Carlo simulations; ActiveData provides users with the means to perform sophisticated audit techniques; and Analysis ToolPak streamlines a full range of statistical calculations. Join us to identify, and gain proficiency with useful Excel add-ins.

Learning Objectives

Identify five useful add-ins to extend the power and functionality of Excel
Utilize the Fuzzy Lookup add-in to match inexact data
Define Benford Analysis and why it is useful in fraud detection
Utilize the Analysis ToolPak to create sophisticated, formula-free analysis
Identify the processes associated with performing a Monte Carlo simulation on cash flow data

Major Topics

Downloading free add-ins from Microsoft
Using built-in add-ins for common tasks
Identifying and using add-ins for sophisticated analysis

Provider
California CPA Education Foundation
Course Level
Intermediate
CPE Field of Study
Computer Software and Applications
2
Who Should Attend

Business professionals who are seeking to maximize the functionality of Excel by using add-in tools. This program focuses on Excel for Windows.

Instructor(s)
Tom Stevenson
Prerequisites

Fundamental knowledge of computer operations and Microsoft Excel

Advanced Preparation

None

Location
Webinar
Event Information
When
Dec 15, 2020
9:00 am - 10:40 am 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 Extending the Power of Excel with Useful Add-Ins


Your browser is out-of-date!

Update your browser to view this website correctly.

Update my browser now

×