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.
Key topics include
- Setting up the model
- Formatting conventions
- Scenario management
- Creating the working sheet/sub-models/outputs
- Auditing, outputs and more
Format
In-person, London
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. His experience ranged from systems implementation, credit assessment of the highly risky construction industry customers, heading up the finance functions to successfully turning the business around and then selling the company through a trade sale. He later joined Commercial Union in the investment back-office function, reengineering the investment back-office and later headed up a team that implemented a new investment management system for both the back office and the front office. His career then spanned over 12 years in the Venture Capital and Private Equity arena, where he has gained a vast amount of experience in the corporate analysis and valuation field.
Andre is a specialist in developing and training finance-related courses, including corporate credit-related topics, financial modelling including valuations, leveraged buyouts and M&A, and accounting (with a focus on IFRS ) courses. His training experience spans a period of more than twenty years.
