After a turbulent period we’re pleased to announce that this course will be held face to face. We look forward to bringing people together physically to benefit from our content delivered by industry leaders and to give delegates the opportunity to network and make lasting relationships. We will be following guidelines to ensure the safety of our delegates. We look forward to seeing you soon - The BVCA training team
Course overview
This course will further develop you and your team’s understanding of accounting and Excel to create robust financial modelling skills that will deliver increased efficiency, flexibility and effectiveness. Key skills will be covered in the course such as scenario management techniques, switches and text wings to make models clear and flexible, and data validation to control inputs.
View the course agenda
Key topics include
- Setting up the model
- Formatting conventions
- Scenario management
- Creating the working sheet/sub-models/outputs
- Auditing, outputs and more
What will delegates take away?
- A clear method for building rigorous, flexible financial models
- Knowledge to build an integrated balance sheet and cash flow forecasting model
Course Director

Andre Lanser
Andre has delivered courses for banks around the world in the areas of Credit, Corporate Finance, Private Equity, Valuation and Financial Modelling. Andre qualified as a Chartered Accountant, completing articles with PricewaterhouseCoopers. He started his career with a subsidiary of Commercial Union, involved in the steel manufacturing industry.
Read more...
CPD accreditation
This course is CPD accredited by the CPD Certification Service for 13 hours. By attending this course, you will receive a digital certificate from Diplomasafe. This certificate allows you to share and save your new CPD accredited qualification on LinkedIn, adding instantly verifiable credentials and strengthening your professional profile.
Further information
Course frequency
Twice a year
Alternative date
February
Audience
Basic level Excel and accounting is required.
More experienced modellers will also
benefit.
Group size
8 - 18 people