Do you want to learn Financial Modelling?

This fully day hands-on course is designed for business professionals who need to explore the practical usage of advanced Excel functions in a financial model. By creating your own user-friendly financial model, you will learn to translate business concepts into a structured format to identify weaknesses and predict future performance.

You Will:

• Discover how to measure and interpret the performance of your company using Excel modelling
• Create your own effective and reliable model and identify weaknesses and predict future performance
• Gain an in-depth understanding of how to build a business case
• Master key steps to get the most out of Excel functionality to improve your financial modelling
• Learn how to enhance the decision-making process
• Maximise your analytical abilities by learning conventional and new approaches of modelling
• Translate business concepts into logically structured models and formats

Learning Objectives

During the course, participants will create their own financial model to take away and use for future reference. You will learn how to design and create a user-friendly model which can then be used by anyone with limited knowledge of excel.

You will learn how to:
• Build a financial model from scratch, or modify and improve an inherited model • Mitigate errors by building in error checks
• Prevent incorrect use of your model by protecting worksheets
• Validate data entry by setting data entry parameters
• Create a navigation page to help users find their way around your model
• Create drop-down boxes which enable a model to produce a series of results depending on scenario variable selected
• Mitigate liability by providing assumptions
• Write instructions for use
• Present findings in a concise and meaningful way

Other Courses Offered:

Budgeting and Forecasting for Organisations is a two day practical course which covers issues such as using budgets to measure staff performance, linking budgets to the strategic planning process and a comparison of budgeting techniques. We explore the difference between budgets and forecasts, and you will learn how to create your own budget, rolling forecast, variance report and budget scenarios in Excel.