32 TONY DE JONKER The Best Excel Tips & Tricks to speed up your Reporting and Analysis

As a financial professional, you spend a lot of time crunching the numbers to build all kind of different reports.
In this session you will discover solutions to practical questions I have encountered using existing and new features in Excel:
Create self-updating charts using dynamic array formulas
Allocate budget amounts to remaining months
Applications of using range names in Power Query
Allocate contract amounts to appropriate date slots based on start and end date of contract