2013
Lynda
Curt Frye
4:15
English
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.
Introduction 2m 33s
Welcome 1m 2s
What you should know before watching this course 52s
Using the exercise files 39s
1. Creating and Pivoting PivotTables 29m 7s
Introducing PivotTables 3m 14s
Formatting data for use in a PivotTable 3m 2s
Creating a PivotTable 2m 37s
Creating a Recommended PivotTable 2m 6s
Pivoting a PivotTable 3m 13s
Configuring a PivotTable 3m 17s
Connecting to an external data source 1m 53s
Consolidating data from multiple sources 5m 52s
Managing PivotTables 3m 53s
2. Summarizing PivotTable Data 23m 37s
Managing subtotals and grand totals 4m 7s
Changing the data field summary operation 5m 35s
Summarizing more than one data field 2m 0s
Creating a calculated field 3m 8s
Grouping PivotTable fields 2m 40s
Using PivotTable data in a formula 3m 59s
Drilling down to the underlying data 2m 8s
3. Sorting and Filtering PivotTable Data 29m 39s
Sorting PivotTable data 3m 41s
Creating a custom sort order 3m 52s
Filtering a PivotTable field by selection 3m 13s
Filtering a PivotTable by rule 2m 30s
Filtering a PivotTable using a search filter 3m 18s
Filtering a PivotTable using slicers 3m 25s
Formatting slicers 3m 7s
Filtering with report filter fields 4m 26s
Clearing and reapplying PivotTable filters 2m 7s
4. Formatting PivotTables 14m 31s
Applying a PivotTable style 2m 36s
Creating a PivotTable style 4m 27s
Changing the PivotTable layout 4m 52s
Changing the data field number format 2m 36s
5. Applying Conditional Formats to PivotTables 30m 20s
Highlighting cells by applying a rule 3m 57s
Highlighting the top or bottom values in a PivotTable 5m 48s
Formatting cells using data bars 3m 28s
Formatting cells using color scales 3m 19s
Formatting cells using icon sets 4m 10s
Editing a conditional formatting rule 3m 55s
Controlling how multiple rules are applied 3m 21s
Deleting a conditional formatting rule 2m 22s
6. Creating and Manipulating PivotCharts 20m 21s
Creating a PivotChart 2m 34s
Pivoting a PivotChart 2m 24s
Filtering a PivotChart 2m 48s
Formatting a PivotChart 3m 38s
Changing a PivotChart's layout 3m 28s
Changing a PivotChart's chart type 2m 29s
Adding a trendline to a PivotChart 3m 0s
7. Printing PivotTables 9m 26s
Printing a PivotTable 2m 53s
Printing headers at the top of each printed page 2m 44s
Printing each item on its own page 2m 35s
Printing a PivotChart 1m 14s
8. Manipulating PivotTables Using Macros 10m 29s
Recording and reviewing an Excel macro 3m 11s
Running an Excel macro 4m 4s
Creating a simple PivotTable presentation kit 3m 14s
9. Starting with PowerPivot and the Data Model 25m 44s
Enabling PowerPivot in Office 2013 Professional Plus 1m 41s
Introducing PowerPivot 4m 32s
Importing PowerPivot data 3m 24s
Adding tables to the data model 58s
Managing table columns 3m 21s
Creating relationships between tables 3m 32s
Creating a PowerPivot PivotTable 4m 21s
Filtering data using a timeline 3m 55s
10. Introducing Data Analysis Expressions (DAX) 21m 44s
Introducing the DAX language 2m 29s
Using DAX operators 4m 35s
Surveying DAX functions 2m 35s
Adding calculated columns 2m 11s
Adding calculated fields 3m 7s
Creating aggregate calculations 4m 6s
Creating filtered calculations 2m 41s
11. Visualizing Power View Data Using Matrices, Cards, and Tiles 21m 29s
Starting out with Power View 2m 16s
Installing Microsoft Silverlight 1m 59s
Creating a table or matrix 4m 2s
Creating a card 3m 30s
Creating a tile 3m 18s
Filtering Power View objects 3m 31s
Formatting Power View objects 2m 53s
12. Visualizing Power View Data Using Charts and Maps 15m 48s
Creating a column or bar chart 3m 48s
Creating a pie chart 2m 7s
Creating a line chart 2m 40s
Creating a map 2m 31s
Creating maps with multivalue series 2m 4s
Creating chart multiples 2m 38s
Conclusion 54s
Next steps 54s
http://www.lynda.com/Excel-tutorials/Excel-2013-Pivot-Tables-Depth/114891-2.html

Download File Size:733.19 MB

---