From the Online Resource - First edition.
Part I: Data cleaning and transformation with Power Query. Tables: the portal to modern Excel
First steps in Excel Power Query
Transforming rows in Power Query
Transforming columns in Power Query
Meging and appending data in Power Query
Part II: Data modeling and analysis with Power Pivot. First steps in Power Pivot
Creating relational models in Power Pivot
Creating measures and KPIs in Power Pivot
Intermediate DAX for Power Pivot
Part III: The excel data analytics toolkit. Introducing dynamic array functions
Augmented analytics for the future of Excel
Conclusion and next steps.