Financial Modelling in Excel Training

This week Prophecy team members will be in Singapore to deliver our Financial Modelling in Excel training course.

The goals of this two-day course include an introduction to Best Practice spreadsheet development as well as financial modelling tips and techniques, and Excel functions, functionality and shortcuts.

Day 1 of the course involves building a base financial modelling workbook from scratch, including reference pages, checks, contents and cover sheets.  Developing this base workbook allows us to cover-off on a range of intermediate Excel functionality as well as several key functions.  The development process also promotes Best Practice workbook structure and encourages the use of keyboard shortcuts for more efficient model development.

Another component of the Day 1 focuses on purpose-based formatting and the development of a corporate theme. This learning outcome is crucial to developing consistent, standardised spreadsheet models within your organisation, which leads to lower incidence of errors, improved user-friendliness and acceptance and lower spreadsheet model costs.  Day 1 rounds out with a module on data manipulation and incorporation, so often intergral to the development of a spreadsheet model.

Day 2 begins with the development of dynamic, three-way financial statements. Off the back of the financial statements we develop annual summaries, perform valuations, run what-if scenarios and develop presentation outputs. After an introduction to visual basic and writing macros, the course rounds-out with model auditing and finalisation tips.

 

No comments yet.

Leave a Reply


8 − = four