Spreadsheets are used throughout financial institutions for financial calculations, budgeting, forecasting, projects and data analysis. Many institutions do not establish a formal review process for operational spreadsheets and it is assumed that the analysts check their own work. Yet there are many recorded instances of spreadsheet failures and the costs and losses involved.
This workshop aims to show delegates a number of tried and tested techniques in a practical one-day workshop that will immediately prove useful and offer rapid payback. It does not matter whether the delegates are involved in accounting or project finance, the techniques in the workshop can be applied to all kinds of spreadsheets. Anybody using Excel to make financial decisions should be confident about the accuracy of their models and this workshop will certainly improve delegates modelling expertise.
The workshop is highly practical and each session begins with a discussion of each technique followed by practical exercises. The models become more complex during the day culminating with a final case study to include all the elements.
The programme is taught using formal lectures combined with practical and interactive case studies and exercises to reinforce the concepts covered in each teaching session. Emphasis is placed on delegates gaining practical, hands-on experience of the design and auditing of financial models in Excel.
Comprehensive product notes and modelling software will be provided for future reference. Delegates receive a full pack of Excel software and templates for future reference as part of the course materials.
This is a course for analysts and practitioners who want to use Excel as a tool to assist with the decision making process. Senior financial professionals using Excel spreadsheets who should attend include:
Delegates will be expected to have finance knowledge and a working knowledge of Excel, including:
Exercise: reconstructing a model
Exercise: reviewing spreadsheet types and planning an audit
Exercise: checking a multi-page spreadsheet
Exercise: finding errors in multiple spreadsheets
Exercise: auditing macros in existing model
Exercise: using software for auditing
Exercise: presenting full audit and report