Skip to content

Excel Blackbelt: Calculations with an eye on the future: 2D blocks and when to use them

Webinar · Recording · 16 July 2019

Webinar by John Yeldham

The function library of Excel keeps developing, and it can be challenging to stay on top of which changes are relevant in your particular situation. Learning more about the latest development enables you to get more out of Excel in general, and also to understand any potential issues your clients or other stakeholders may have with the new functionality due to compatibility issues

This session is focused primarily on topics relevant for professional involved in the development of financial models, but it will also be relevant for anyone working day to day in Excel and who want to know more about recent developments. It focuses on look-up functions, and how to use the latest Corality methodology to choose and apply the latest look-up functions in real-world models.

Learning benefits:

  • Learn more about the latest version of Excel functions to ake the most of them in your analysis
  • Clarify the distinction between old and new versions of Excel and the major differences
  • Understand that implications of using new versions of function in regards to compatibility for clients and model users
  • Develop a consistent set of functions to use for look-ups in your models.

This is an extract from the Corality Academy – click here for our Global Course Schedule (opens in a new tab)

Learn financial modelling in a room

Hands-on courses in person and online, taught to more than 20,000 people on one modelling standard.

Best Practice Project Finance Modelling

Build and sensitise robust cashflow models from scratch, faster in Excel. Hands-on, practitioner-led, in person or online. See dates and book your place.

View full course details: Best Practice Project Finance Modelling

Advanced Project Finance Modelling

Debt sizing, covenant monitoring, DSRAs and integrated three-way statements. Hands-on, practitioner-led training, in person or online. See dates and book.

View full course details: Advanced Project Finance Modelling

Financial Model Review

Error classes, testing technique and where AI-assisted financial model review earns its place. 1-day course from our award-winning Model Audit team.

View full course details: Financial Model Review

Browse all training courses

Learn to build these models yourself

We run public and in-house courses across the full financial modelling curriculum.