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

Course Details

Date

Wednesday, October 28, 2020

9:00am – 10:40am (Registration: 8:30am)

Location

Online

Field of Study

Technology

CPE Credit

2 hours CPE credit

Level of Knowledge

Intermediate

Vendor

CalCPA

Prerequisites

Fundamental knowledge of computer operations and Microsoft Excel

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.

Highlights

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

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

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.

Registration for this course has passed.

Course Pricing

WYOCPA Member Fee
$75.00

Non-Member Fee
$101.00

Your Price
$101.00

View All Professional Development Courses