March 29, 2021 8:00am – 9:40am Map & Directions

Webcast: K2's Extending the Power of Excel with Useful Add-Ins | 4203626F

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.

Location

Registration Time

7:30am

Fees

Member:
$75
Non-CPA Staff:
$101
Non-CPA Staff (100% club):
$75
Non-CPA Staff (sole proprietor):
$75
Non-Member:
$101
Webcast
Information Technology
2

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.

Course Level

Intermediate

Vendor

CalCPA Education Foundation More With This Vendor

Designed For




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

Prerequisites




Fundamental knowledge of computer operations and Microsoft Excel.

Highlights




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

Related Courses