Introduction
This course shows how to build PivotTables from single or multiple data sources, add calculated fields, filter your results, and format your layout to make it more readable. Plus, learn how to enhance PivotTable with macros, DAX expressions, and the PowerPivot add-in for analyzing millions of rows of data.
Course Outline
1. Introduction
2. Summarizing PivotTable Data
3. Sorting and Filtering PivotTable Data
4. Formatting PivotTables
5. Applying Conditional Formats to PivotTables
6. Creating and Manipulating PivotCharts
7. Printing PivotTables
8. Manipulating PivotTables Using Macros
9. Starting with PowerPivot and the Data Model
10. Introducing Data Analysis Expressions (DAX)
11. Visualizing Power View Data Using Matrices, Cards, and Tiles
12. Visualizing Power View Data Using Charts and Maps
Introduction
This course shows how to build PivotTables from single or multiple data sources, add calculated fields, filter your results, and format your layout to make it more readable. Plus, learn how to enhance PivotTable with macros, DAX expressions, and the PowerPivot add-in for analyzing millions of rows of data.
Course Outline
1. Introduction
2. Summarizing PivotTable Data
3. Sorting and Filtering PivotTable Data
4. Formatting PivotTables
5. Applying Conditional Formats to PivotTables
6. Creating and Manipulating PivotCharts
7. Printing PivotTables
8. Manipulating PivotTables Using Macros
9. Starting with PowerPivot and the Data Model
10. Introducing Data Analysis Expressions (DAX)
11. Visualizing Power View Data Using Matrices, Cards, and Tiles
12. Visualizing Power View Data Using Charts and Maps