Start your free trial now, and begin learning software, business and creative skills—anytime, anywhere—with video instruction from recognized industry experts.

Start Your Free Trial Now

Excel 2013 Tutorials: Pivot Tables in Depth

with Curt Frye

Video: Welcome

Welcome to the Microsoft Excel 2013: PivotTables in Depth course. PivotTables let you examine your organization's data from different perspectives, or angles, to provide you with new insights about your organization. This online video shows you how to create a PivotTable and then reorganize the data so you can analyze the data from different angles.
Expand all | Collapse all
  1. 2m 33s
    1. Welcome
      1m 2s
    2. What you should know before watching this course
    3. Using the exercise files
  2. 29m 2s
    1. Introducing PivotTables
      3m 14s
    2. Formatting data for use in a PivotTable
      3m 2s
    3. Creating a PivotTable
      2m 37s
    4. Creating a Recommended PivotTable
      2m 6s
    5. Pivoting a PivotTable
      3m 13s
    6. Configuring a PivotTable
      3m 17s
    7. Connecting to an external data source
      1m 53s
    8. Consolidating data from multiple sources
      5m 52s
    9. Managing PivotTables
      3m 48s
  3. 23m 37s
    1. Managing subtotals and grand totals
      4m 7s
    2. Changing the data field summary operation
      5m 35s
    3. Summarizing more than one data field
      2m 0s
    4. Creating a calculated field
      3m 8s
    5. Grouping PivotTable fields
      2m 40s
    6. Using PivotTable data in a formula
      3m 59s
    7. Drilling down to the underlying data
      2m 8s
  4. 29m 39s
    1. Sorting PivotTable data
      3m 41s
    2. Creating a custom sort order
      3m 52s
    3. Filtering a PivotTable field by selection
      3m 13s
    4. Filtering a PivotTable by rule
      2m 30s
    5. Filtering a PivotTable using a search filter
      3m 18s
    6. Filtering a PivotTable using slicers
      3m 25s
    7. Formatting slicers
      3m 7s
    8. Filtering with report filter fields
      4m 26s
    9. Clearing and reapplying PivotTable filters
      2m 7s
  5. 14m 31s
    1. Applying a PivotTable style
      2m 36s
    2. Creating a PivotTable style
      4m 27s
    3. Changing the PivotTable layout
      4m 52s
    4. Changing the data field number format
      2m 36s
  6. 34m 47s
    1. Highlighting cells by applying a rule
      3m 57s
    2. Highlighting the top or bottom values in a PivotTable
      5m 25s
    3. Formatting cells using data bars
      4m 37s
    4. Formatting cells using color scales
      4m 15s
    5. Formatting cells using icon sets
      6m 55s
    6. Editing a conditional formatting rule
      3m 55s
    7. Controlling how multiple rules are applied
      3m 21s
    8. Deleting a conditional formatting rule
      2m 22s
  7. 20m 21s
    1. Creating a PivotChart
      2m 34s
    2. Pivoting a PivotChart
      2m 24s
    3. Filtering a PivotChart
      2m 48s
    4. Formatting a PivotChart
      3m 38s
    5. Changing a PivotChart's layout
      3m 28s
    6. Changing a PivotChart's chart type
      2m 29s
    7. Adding a trendline to a PivotChart
      3m 0s
  8. 9m 26s
    1. Printing a PivotTable
      2m 53s
    2. Printing headers at the top of each printed page
      2m 44s
    3. Printing each item on its own page
      2m 35s
    4. Printing a PivotChart
      1m 14s
  9. 10m 29s
    1. Recording and reviewing an Excel macro
      3m 11s
    2. Running an Excel macro
      4m 4s
    3. Creating a simple PivotTable presentation kit
      3m 14s
  10. 25m 44s
    1. Enabling PowerPivot in Office 2013 Professional Plus
      1m 41s
    2. Introducing PowerPivot
      4m 32s
    3. Importing PowerPivot data
      3m 24s
    4. Adding tables to the data model
    5. Managing table columns
      3m 21s
    6. Creating relationships between tables
      3m 32s
    7. Creating a PowerPivot PivotTable
      4m 21s
    8. Filtering data using a timeline
      3m 55s
  11. 21m 44s
    1. Introducing the DAX language
      2m 29s
    2. Using DAX operators
      4m 35s
    3. Surveying DAX functions
      2m 35s
    4. Adding calculated columns
      2m 11s
    5. Adding calculated fields
      3m 7s
    6. Creating aggregate calculations
      4m 6s
    7. Creating filtered calculations
      2m 41s
  12. 21m 29s
    1. Starting out with Power View
      2m 16s
    2. Installing Microsoft Silverlight
      1m 59s
    3. Creating a table or matrix
      4m 2s
    4. Creating a card
      3m 30s
    5. Creating a tile
      3m 18s
    6. Filtering Power View objects
      3m 31s
    7. Formatting Power View objects
      2m 53s
  13. 15m 48s
    1. Creating a column or bar chart
      3m 48s
    2. Creating a pie chart
      2m 7s
    3. Creating a line chart
      2m 40s
    4. Creating a map
      2m 31s
    5. Creating maps with multivalue series
      2m 4s
    6. Creating chart multiples
      2m 38s
  14. 54s
    1. Next steps

please wait ...
Excel 2013: Pivot Tables in Depth
Video Duration: 0s 4h 20m Intermediate


View Course Description

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
Business IT
Excel Office Office 365


(music playing) Hi! I am Curt Frye. Welcome to Excel 2013: Pivot Tables in Depth. In this course, I'll show you how to use PivotTables to gain valuable insights from your organization's data. I'll begin by showing you how to create a PivotTable from data already in your Excel workbook, then using that knowledge as a base, I'll demonstrate how to create PivotTables using data from an external source. I'll enhance your ability to analyze your data by showing you how to reorganize, or pivot, a PivotTable.

After you've organized your PivotTable's data, you can sort and filter its contents to develop useful insights into your business. I'll also show you how to create conditional formats that highlight subsets of your data, control your PivotTable using macros, and summarize huge data sets using the PowerPivot add-in. PowerPivots capabilities have been extended with the new Power View add-in. In short, I'll show you how to summarize and analyze data using one of Excel's most powerful and overlooked features.

There are currently no FAQs about Excel 2013: Pivot Tables in Depth.






Don't show this message again
Share a link to this course

What are exercise files?

Exercise files are the same files the author uses in the course. Save time by downloading the author's files instead of setting up your own files, and learn by following along with the instructor.

Can I take this course without the exercise files?

Yes! If you decide you would like the exercise files later, you can upgrade to a premium account any time.

Become a member Download sample files See plans and pricing

Please wait... please wait ...
Upgrade to get access to exercise files.

Exercise files video

How to use exercise files.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.

Exercise files

Exercise files video

How to use exercise files.

For additional information on downloading and using exercise files, watch our instructional video or read the instructions in the FAQ .

This course includes free exercise files, so you can practice while you watch the course. To access all the exercise files in our library, become a Premium Member.

Join now Already a member? Log in

* Estimated file size

Are you sure you want to mark all the videos in this course as unwatched?

This will not affect your course history, your reports, or your certificates of completion for this course.

Mark all as unwatched Cancel


You have completed Excel 2013: Pivot Tables in Depth.

Return to your organization's learning portal to continue training, or close this page.


Upgrade to View Courses Offline


With our new Desktop App, Annual Premium Members can download courses for Internet-free viewing.

Upgrade Now

After upgrading, download Desktop App Here.

Become a Member and Create Custom Playlists

Join today and get unlimited access to the entire library of online learning video courses—and create as many playlists as you like.

Get started

Already a member?

Log in

Exercise files

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships. Learn more

Get started

Already a Premium member?

Exercise files video

How to use exercise files.

Ask a question

Thanks for contacting us.
You’ll hear from our Customer Service team within 24 hours.

Please enter the text shown below:

Exercise files

Access exercise files from a button right under the course name.

Mark videos as unwatched

Remove icons showing you already watched videos if you want to start over.

Control your viewing experience

Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.

Interactive transcripts

Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.

You started this assessment previously and didn’t complete it.

You can pick up where you left off, or start over.

Resume Start over

Learn more, save more. Upgrade today!

Get our Annual Premium Membership at our best savings yet.

Upgrade to our Annual Premium Membership today and get even more value from your subscription:

“In a way, I feel like you are rooting for me. Like you are really invested in my experience, and want me to get as much out of these courses as possible this is the best place to start on your journey to learning new material.”— Nadine H.

Thanks for signing up.

We’ll send you a confirmation email shortly.

Sign up and receive emails about and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from

Sign up and receive emails about and our online training library:

Here’s our privacy policy with more details about how we handle your information.

submit Lightbox submit clicked
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.