This two-day Excel Modelling Workshop is designed to build a robust and informative model. The workshop uses a logical consistent approach and builds the cash flow model through a series of practical stages. Delegates will receive a comprehensive understanding of advanced modelling, as well as how they can apply each technique to their own models.
On completion of this highly practical, hands-on training course, attendees will:
be able to build an advanced financial model from a blank sheet
be able to design transparent models which minimise errors
be able to write robust models which can be understood by others and maintained in the future
be able to develop models with advanced techniques such as risk, sensitivity and forecasting
This programme will be delivered through a practical and interactive case study and worked examples, demonstrating how and why each technique is used. Emphasis is placed on the delegates gaining practical, hands-on experience of the design and construction of financial models in Excel. Delegates will also benefit from formal lectures and group discussions.
The course starts with a discussion of ideal modelling techniques, standards and methods and agrees the objectives for a cash flow model. Each session reviews the next stage of the model in terms of the financial theory, modelling techniques and potential difficulties and delegates then have the time to build each section in stages under supervision. This is an intensive course and delegates will be spending most of the time on practical model building tasks. With the help of the Course Director and through a proven step-by-step approach, delegates will leave this intensive two-day course with the confidence and ability to apply advanced modelling techniques in Excel effectively.
Day One – Introduction and Model Build
Module 1 – Modelling and Model Planning
Overview of the course – building a model from a blank sheet
"Very good and well presented course." Tim Buss, VAT for Accounts Payable course
Kathy Greenwell Ellis Patents
"Everything was excellent - from enquiry to delivery of the course."
Salma Mohamed Pen International
"Jacqueline was fantastic. Best course I have ever been on. Brilliant." Jacqueline Williams, Accounting Principles course
Heather Barker British Land
"Small class and opportunity to discuss made course worthwhile."
Baldish Mandair Specsavers Optical Superstores
"It was well-pitched and gave good references for further information. Example questions were good." Peter Hughes, IFRS Update course
Daniel Lally Bouygues UK
"I would just like to say that I thoroughly enjoyed the course and found it extremely useful and informative. Steve Giles was extremely knowledgeable and very approachable so please do pass on my thanks. In addition, the lunch was fabulous!!" Steve Giles, Role of Non-Executive Directors course
Jayne Stokes Port of London Authority
"The course was exactly as expected and really helped my understanding." Gwen Ryder, VAT 1 and 2 courses
Antonia Jones The Motor Fuel Group
"Very good presenter. Good overview." Peter Hughes, Tax in Company Accounts IFRS course