Dynamic Array Formulas are a recent innovation from Microsoft, and their impact is immediate and wide-ranging. In this session we’ll explore what a Dynamic Array Formula is, and how they can be used by regular Excel users.

We’ll look at some new functions too, which perfectly complement Dynamic Array Formulas – including UNIQUE, SORT, SORTBY and FILTER and how they can now help us to automate tasks which were previously extremely difficult.

Target audience

Intermediate and Advanced users of Excel who create formulas of any kind - aimed at those wanting to elevate skills level in Excel. 


  • What is a Dynamic Array Formula
  • What are the new functions?
    • UNIQUE
    • SORT
    • SORTBY
    • FILTER
  • How do they affect other functions?

The speaker

Chris Harvey is a Senior Technical Learning Specialist at QA.


Please enter details below to register for the free webinar.