We also offer courses and publications in: UK Flag London US Flag New York
  • Join us for the latest updates, tips and course dates!

Excel - Module 2: Introducing Modeling

Excel gives you the edge whenever you want to do something new with financial models, something never seen before in instrument pricing, and something that none of your competitors has ever done.
Delivered via Virtual Classroom you will be able to engage with the instructor and other participants, share screens, ask questions without leaving your office or your home, city or country.

Description

inancial modelling is generally carried out in most investment banks in a generic standard way, usually based upon the three main financial statements produced each year by corporate accountants. This module builds up a basic model foundation, cleans the raw data, and then performs various modelling techniques to enhance that basic data. 

• Applying styles
• Customizing number formats
• Balance sheet, income statement, cash flow statement
• Linking key data points
• Circular references
• Iteration
• Extending data into future
• Modelling scenarios
• Choose, Offset, Match, and Index functions
• Sensitivity analysis