Tips & Tricks for Analysis & Reporting using dynamic arrays
In this session you will learn the best Excel tips & tricks for Analysis & Reporting by using dynamic array formulas. You will see how to apply these examples in your business.
- How to create a dynamic Top N Reports based on different tables using functions TAKE – DROP – FILTER – SORT
- Break Monthly Sales Forecast into Weekly Forecast
- Select all employees and accompanying columns who earn more than a predetermined amount using one formula
- Allocating External Contractor Costs to the following months based on variable start date, end date, hourly rates and working dates
- Summarizing data using GROUPBY and PIVOTBY
Other Sessions
With Brian Egger, Global Head of Financial Modeling, Bloomberg Intelligence
Discover how timeless modelling techniques can make you shine - only now with the added power of Python in Excel.
Explore how Excel powers financial modelling in the City of London, and where to access real-world best practice despite industry paywalls.
Throughout his career, Ian Schnoor has worked with thousands of Excel users as they climb from novice to expert. During this session, he will describe the hardest part of the journey (Hint: it's not a lookup, LET or LAMDA).
.png)
.png)
.png)
%20-%20GES2026.png)
.png)
%20-%20GES2026.png)
.png)
.png)
%20-%20GES2026.png)
Join the Master Club
Your exclusive all-access pass to our entire digital learning experience for a whole year.
.png)