lynda.com » lynda.com library » Microsoft » Excel 2013: Pivot Tables in Depth

Excel 2013: Pivot Tables in Depth

with Curt Frye

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.

Topics include:

Creating a PivotTable
Summarizing multiple data fields
Managing subtotals and grand totals
Grouping PivotTable fields
Filtering with selections, rules, slicers, and search filters
Applying PivotTable styles
Formatting cells
Creating PivotCharts
Enabling PowerPivot
Using DAX operators
Visualizing data with matrices, cards, and tiles
Building charts and maps

show more show less

author: Curt Frye
subject: Business, Data Analysis, Spreadsheets
software: Excel 2013, Office 2013, Office 365
level: Intermediate

duration: 4h 15m
released: Apr 11, 2013

Share this course

Learn more about lynda.com

Ready to join? get started

Members who watched this also viewed

Excel 2010 Essential Training

Excel 2013 Essential Training

Excel 2013: Advanced Formulas and Functions

Excel 2010: Pivot Tables in Depth

Access 2010 Essential Training

SEO Fundamentals

Excel 2013 Power Shortcuts

Access 2013 Essential Training

Photoshop CS6 Essential Training

PHP with MySQL Essential Training

expand all | collapse all

viewed duration

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

Suggested courses to watch next:

Managing and Analyzing Data in Excel (1h 32m)
Dennis Taylor

Setting Up a Database in Excel (43m 27s)
Dennis Taylor

Excel 2013 Power Shortcuts (3h 16m)
Curt Frye

Office 2013 New Features (2h 31m)
David Rivers

You must be a lynda.com member to watch this video.

Every course in the lynda.com library contains free videos that let you assess the quality of our tutorials before you subscribe—just click on the blue links to watch them. Become a member to access all 104,069 instructional videos.

get started

learn more

If you are already an active lynda.com member, please log in to access the lynda.com library.

Get access to all lynda.com videos

You are currently signed into your admin account, which doesn't let you view lynda.com videos. For full access to the lynda.com library, log in through iplogin.lynda.com, or sign in through your organization's portal. You may also request a user account by calling 1 1 (888) 335-9632 or emailing us at cs@lynda.com.

Get access to all lynda.com videos

How to access this video.

If this course is one of your five classes, then your class currently isn't in session.

If you want to watch this video and it is not part of your class, upgrade your membership for unlimited access to the full library of 2,024 courses anytime, anywhere.

learn more upgrade

You can always watch the free content included in every course.

Questions? Call Customer Service at 1 1 (888) 335-9632 or email cs@lynda.com.

Excel 2013: Pivot Tables in Depth

with Curt Frye

Share this course

table of contents

exercise files

transcript

author

preferences

FAQs

Suggested courses to watch next:

Bookmark this Tutorial

Name

Description

Tags

bookmark this course

Create new playlist

You must be a lynda.com member to watch this video.

Get access to all lynda.com videos

Get access to all lynda.com videos

Access to lynda.com videos

How to access this video.

You don't have access to this video.

Need help accessing this video?

Try our new course pages

name:
description:
	save cancel