EVENT DESCRIPTION

This course provides tips and tricks for Excel model builders to speed up their process.

The course includes recap of the basics of navigation, cell editing and formatting, as well as information on how to use advanced Excel tools to create better models. The course also explores data table, goal seek, and scenarios to perform sensitivity analysis and cater for uncertainty.

LEARNING OBJECTIVES:

By the end of this course, you will be able to:

  • build flexibility into financial forecasts
  • break down complex calculations
  • use effective shortcuts, formulas and functions
  • monitor and handle uncertainty using scenarios planning
  • audit an Excel model and uncover errors