To provide the knowledge and skills required to make efficient use of the Power Query, Power Pivot and 3D Map features in Excel.
Basic knowledge of Excel.
- Power Query: importing data, modifying and transforming data via the request editor, request duplication and merge, combine tables and data pivoting, introduction to language M
- Power Pivot: connecting to data sources, data modeling, dynamic cross tables and graphs, creating new calculated fields and PowerPivot formulas, using segments and chronology
- 3D Map: creating a geospatial map, customizing a guided tour, using layers, recording an animated video of the map