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.
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.