Advanced Formulas

This set of advanced Excel formulas is all you need to solve complex lookup problems. When we’re pressed for time, we solve our problems by copying & pasting formulas from Excel forums or our colleague’s files but we rarely take the time to understand the engine behind the formula. In this session you will learn a handful of Excel formulas that will enable you to work faster & smarter:

  • INDEX MATCH & Offset for Flexible Lookups
  • SUMPRODUCT for the Experts
  • Solve complex tasks with Dynamic Arrays
Data Modelling & Formulas