Lynda - Excel 2013: Pivot Tables
Join Curt Frye as he explains how to leverage PivotTables to summarize, sort, count, and chart your data in Microsoft Excel. Curt shows you how to navigate the complexity of PivotTables while taking advantage of their power. 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.
Table of Contents
Introduction1. Creating and Pivoting PivotTables2. Summarizing PivotTable Data3. Sorting and Filtering PivotTable Data4. Formatting PivotTables5. Applying Conditional Formats to PivotTables6. Creating and Manipulating PivotCharts7. Printing PivotTables8. Manipulating PivotTables Using Macros9. Starting with PowerPivot and the Data Model10. Introducing Data Analysis Expressions (DAX)11. Visualizing Power View Data Using Matrices, Cards, and Tiles12. Visualizing Power View Data Using Charts and MapsConclusion
Coktum |
