K2's Extending The Power of Excel With Useful Add-Ins

Description

There are many free or low-cost add-ins available to overcome the limitations of Excel. For example, the free Fuzzy Lookup add-in from Microsoft allows users to match inexact data. Ever try that with VLOOKUP? RiskAMP allows users to perform Monte Carlo simulations for capital budgeting; ActiveData provides users with the means to do sophisticated Benford Analysis and other CAATS techniques; and the Analysis ToolPak provides a full range of statistical analyses useful in budgeting and forecasting. This session will identify and demonstrate useful add-ins to improve Excel functionality and your productivity.

Highlights

• Excel Add-ins
• Lookup add-in to match inexact data
• Benford Analysis
• Linear regression using the Analysis ToolPak
• Monte Carlo simulation

Objectives

• Identify five useful add-ins to extend the power and functionality of Excel
• Use the Fuzzy Lookup add-in to match inexact data
• Explain Benford Analysis and why it is useful in fraud detection
• Perform linear regression using the Analysis ToolPak
• Describe the process of performing a Monte Carlo simulation on cash flow data

Designed For

CPAs and financial professionals.