By the end of this course, you will be able to determine which of the two tools, PivotTables and PowerPivot, is most effective for your analysis needs. In the context of PowerPivot, you will be able to consider teamwork strategies to centralise your data for analysis. Participants in this course should have a good analytical mind and master the calculation and sorting/filtering tool of Microsoft Excel.

Excel 2019/365 Power Query – Level 1
18/1, 08/3, 10/5, 05/7, 11/1 ...
Forget VBA and discover Power Query to automate your data collection. This tool allows you to create complex queries without…