Short-what?: The Newest Excel Tips and Tricks - American Institute of CPAs
The accreditors of this session require that you periodically check in to verify that you are still attentive.
Please click the button below to indicate that you are.
This hands-on session will focus on Excel tools. We will explore new or updated or recommended formulas and functions which advance participants’ ability to quickly manipulate data and understand statistical inferences. We will explore applications of these formulas/ functions to analyze data for both valuation and investigative purposes. Participants will have the ability to work through multiple real-world FVS use-cases using financial and non-financial data during the session.
Learning Objectives:
Identify and be able to use relevant and up-to-date formulas/ functions in excel for Office 365.
Apply these formulas/ functions and other ones to generate more flexible and dynamic valuation models.
Use these formulas/ functions and other ones to generate statistical models to identify and investigate anomalies.
Kane
Porter,
CPA, CA, CBV, ABV, CFF, CAMS, CFE,
Vice President of Compliance (Privacy Officer & Chief Anti-Money Laundering Officer),
Peoples Trust Company