Loading Events

« All Events

  • This event has passed.

Extending the Power of Excel with Useful Add-ins

December 7 @ 9:55 am - 11:35 am EST

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 the Analysis ToolPak streamlines a full range of statistical calculations. This session will identify and demonstrate useful add-ins to improve Excel functionality and your productivity.

• 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

Details

Date:
December 7
Time:
9:55 am - 11:35 am
Event Category:

Other

CPE Credits
2
Prerequisites
None
NASBA Category
Computer Software and Applications
Instructor
Tommy Stephens
Delivery Method
Live
K2 Event ID
20653
Event Duration
1:40
Event Location
Franklin, TN
Conference Title
TN Technology Conference

Venue

Franklin Marriott Cool Springs
700 Cool Springs Blvd.
Franklin, TN 37067 United States
+ Google Map