Financial models are required when users need to find solutions where the variables exist under conditions of uncertainty. This course will build on the basic knowledge of the participants to formulate more complex Excel spreadsheets. Participants will first be introduced to the conceptual framework surrounding the creation of financial models. They will then be taught the various advanced functions and tools available in Microsoft Excel that are commonly used when creating financial models.
In order for participants to get the full benefits of attending this course, a basic knowledge of Microsoft Excel is required. Participants must be familiar with:
This course will be conducted in an interactive and hands-on manner. Numerous practical exercises will be provided by the instructor to illustrate and reinforce the various topics covered. Participants will be given the opportunity to develop practical skills in formulating financial models that they can use in their workplace.
Basics of Modelling
Advanced Excel Functions
Types of Models