Print
Print
|
Introduction
This hands-on, application driven 4-day programme leads delegates through numerous specialised Excel functions and procedures pertinent to the construction of project financial models, explaining the function or procedure and their uses. In essence, it is a combination of the 2-day Advanced Excel Spreadsheet Techniques course and the 2-day Project Financial Modelling course Days 1 and 2 will be spent on demonstrating various advanced Excel techniques, interspersed with short hands-on exercises to reinforce the functions, techniques and concepts presented. Days 3 and 4 then move on to cover good project model structure, and ways of maintaining the integrity of the model using the features provided by Excel. The course assumes that delegates are involved in the financial sector or in corporate financial activities, have a working background of project modelling and evaluation and are familiar with commonly used financial terms. It focuses on the basic nuts & bolts of project financial model preparation and structure, and provides the delegate with useful modelling techniques that can be immediately applied in the work place in the project evaluation environment. Participants will build a complete project model, from first principles, in various stages over the last two days. The program covers what should be done once the model is complete, including sensitivity analysis, data tables and the creation and comparison of scenarios. Teaching method Delegates are guided through the course by a highly-experienced course director. Once a certain principle, technique, or function has been worked through in class, delegates tackle a practical exercise pertinent thereto. The course is non-threatening and relaxed, the course director always being on hand to help and guide where necessary. Delegates are provided with a comprehensive set of notes designed to be used as a reference manual after the course, as well as a CD containing all the worked and unworked examples referred to in the notes, and all the exercises and solutions for the work done in class 
Who Should Attend
Pre Requisite(s)
Delegates should be familiar with Microsoft Excel (though not necessarily expert in the use thereof, as any relevant Excel function pertinent to an exercise will be discussed prior to tackling the exercise). Excel knowledge required:
Outline
The first two days will be spent on demonstrating various advanced Excel techniques, interspersed with short hands-on exercises to reinforce the functions, techniques and examples presented. The last two days of the course we will discuss various aspects of project financial modelling using Excel spreadsheet techniques, covering most of the useful features so far as they affect the everyday preparation of models. Participants will pick up a number of useful tips and some interesting techniques to aid in their own endeavours.
Outcomes
On completion of this practical, hands-on training course, delegates will:
Course Content
Day 1 Some Useful Tips to speed up your spreadsheet skills Identifying and Protecting data in spreadsheets Naming Cells, Ranges & Formulas Creating your own Formats (and the uses thereof) Conditional Formats
Multiple sheet models - Working across sheets Drilling Down
Hands-on exercise - Pivot table reports Day 2 Lookups
Row(S) and Column(S) functions Using "Masks" The SUMPRODUCT function String functions Data Tables
Creating Views Indirect Addressing
Consolidating data from different files Recording macros Assigning macros to buttons & icons Setting up "Controls" (Drop-Down Boxes, Option buttons, Spinners) Appendix
Days 3 and 4 Structuring your model Model Structure The integrity of the model Model 1 Building a 20-year project model
Background to the New Product Project model
|