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
Upcoming Courses
-
Surgent's Perplexing Financial and Economic Issues for the CFO/Controller
April 22, 2024
-
MBAexpress: Effective Change Management - V 2.0
April 22, 2024
-
Auditing Digital Assets, Part I
April 22, 2024
View all upcoming courses