C-3.9

Power Tools, Tables and Arrays in Excel

Excel’s Power Tools can efficiently analyse virtually an unlimited amount of data in a greatly reduced time. Previous delegates have reported cutting the time spent on month-end reporting in half by using Power Query and Power Pivot. The aim of this course is to equip delegates to use Excel’s Power Tools, table functionalities and array calculations to streamline calculations and applications in their vast datasets and financial models. New dynamic array functions are constantly being added by Excel developers, and this course is updated with the latest in dynamic array functions, bringing you the cutting edge ways to analyse