The ability to create and understand financial models is one of the most valued skills in business and finance today. Microsoft Excel and macros programming has been the dominant vehicle used by finance and corporate professionals in the preparation and utilization of the full range of financial models and other applications.

However, as a result of the so called '95/5' rule it can be concluded that 95% of Excel users probably only use a mere 5% of the program's power. Most users know that they could be getting more out of Excel especially by using advanced techniques which would result in them being able to build more flexible, dynamic and professional models. Stress testing to deal with uncertainty and risk in Financial ModellingThis intensive 3 day workshop starts with basics and progresses in a logical step by step manner to the more complex and rewarding tools needed to build more robust models that save time, reduce unnecessary human errors and customize applications

Delegates will need some basic knowledge of Excel but not of professional modeling or programming.

Some of the topics that will be discussed include:

 The 40 Excel functions that financial modelers use the most

 Best practice in modeling forecasted financial statements (Balance Sheet, Income Statement and Cash Flow Statement)

 The powerful combination of arrays, the offset function, the match function and drop down menus

 The danger of using IRR in isolation and possible solutions

 Modeling and automating ratio analysis in Excel

 Various Optimization solutions using Excel Solver (cash and inventory management, capacity planning and capital budgeting)

 Pivot Tables

 Record, write and edit powerful macros that will perform routine tasks in no time.

 Scenarios and sensitivity analysis

 Learn different methods of what-if and scenario analysis in Excel using:

Who Should Attend?

By the end of the program, participants will be able to:

 Boost Excel reporting expertise in business, finance, and accounting.

 Perform automated reconciliation for speedy weekly and monthly reporting.

 Link their Excel with PowerPoint for dynamic data update.

 Develop dynamic business dashboards and scorecards to assist professionals in measuring performance and enhancing decision making.

 Leverage their Excel expertise to new and advanced levels.

 Link-up Excel and import data from different sources.

 Perform data analysis techniques to produce timely and accurate reports.

 Design outstanding visualization charts and dashboards.

 Develop master level report solutions.

 Record, write and edit powerful macros that will perform routine tasks in no time.

All Excel Users particularly:

- Financial Analysts

- CEO's / CFO's

- Portfolio managers

- Corporate accountants

- Credit analysts

- Private equity managers

- Venture capitalists

- Risk managers

- Board members

- Investment bankers

- Regulators

- Financial government officials

- Strategic planners

- Trustees

- Compliance officers/Internal Auditors

- Management consultants

The course material includes extensive use of Excel and participants will gain the maximum benefit from this course if they are already competent spreadsheet users.

It is designed for users who do use Excel on a regular basis, and are comfortable with using its tools and functions. At minimum, it is assumed that participants will know how to:

• Navigate confidently in Excel
• Use absolute cell references (e.g. =$A$1)
• Create and use Excel functions on a regular basis Course Content
• Financial Modeling Theory and Best Practice
• Advanced Financial Modeling Techniques
• Advanced Financial Modeling Tools and Functions
• Bullet-proofing Your Model
• Stress testing to deal with uncertainty and risk in Financial Modeling
• Scenarios and sensitivity analysis
• Practical Financial Modeling
• Tiering Tables
• Financial Model Critique