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.
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
Downloading free add-ins from Microsoft
Using built-in add-ins for common tasks
Identifying and using add-ins for sophisticated analysis
Business professionals who are seeking to maximize the functionality of Excel by using add-in tools. This program focuses on Excel for Windows.
Fundamental knowledge of computer operations and Microsoft Excel