Excel Modelling Fundamentals

Overview:

This four-part Excel fundamentals course provides tips and tricks for Excel model builders, gives advice on how to audit your financial models, demonstrates how to use better formulas, and shows you how to monitor and handle uncertainty using scenario planning.

Learning Objectives:

In the following four modules you will learn:

• Module 1 – Excel tips and tricks
  • Learn how to speed up your Excel modeling skills and significantly improve how you edit your worksheets
• Module 2 – Better formulas for financial modeling
• • Build flexibility into financial forecasts, break down complex calculations, minimize errors in Excel models and understand Excel function syntax
• Module 3 – Catering for uncertainty in the model
• • Learn how to perform sensitivity analysis
• Module 4 - Auditing a financial model
• • Learn how to quickly and easily find errors and audit a spreadsheet

Who Will Benefit: 

This course is designed for professionals working in equity research, investment banking, corporate development, financial planning and analysis (FP&A), and other areas of finance and accounting.