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