Extract data from almost any source. Speed up and simplify the process of cleaning and transforming that data, ready for analysis in Excel, Power Pivot or Power BI.
Harness the power of Pivot Tables to quickly summarise and analyse large amounts of data. Transform data into meaningful reports that are easy to update and change.
Designed to take you from zero to hero in Excel. Covering advanced topics like array formulas, named ranges, dynamic array functions, advanced functions, conditional formatting, macros and more.