Start learning with our library of video tutorials taught by experts. Get started

Excel 2013: Pivot Tables in Depth
Illustration by Neil Webb

Excel 2013: Pivot Tables in Depth

with Curt Frye

Video: Welcome

(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.
Expand all | Collapse all
  1. 2m 33s
    1. Welcome
      1m 2s
    2. What you should know before watching this course
      52s
    3. Using the exercise files
      39s
  2. 29m 7s
    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 53s
  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. 30m 20s
    1. Highlighting cells by applying a rule
      3m 57s
    2. Highlighting the top or bottom values in a PivotTable
      5m 48s
    3. Formatting cells using data bars
      3m 28s
    4. Formatting cells using color scales
      3m 19s
    5. Formatting cells using icon sets
      4m 10s
    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
      58s
    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
      54s

Watch this entire course now—plus get access to every course in the library. Each course includes high-quality videos taught by expert instructors.

Become a member
please wait ...
Excel 2013: Pivot Tables in Depth
4h 15m Intermediate Apr 11, 2013

Viewers: in countries Watching now:

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
Subjects:
Business Spreadsheets IT
Software:
Excel Office Office 365
Author:
Curt Frye

Welcome

(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.

 
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

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

Congratulations

You have completed Excel 2013: Pivot Tables in Depth.

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


OK
Become a member to add this course to a playlist

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

Get started

Already a member?

Become a member to like this course.

Join today and get unlimited access to the entire library of video courses.

Get started

Already a member?

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:

The classic layout automatically defaults to the latest Flash Player.

To choose a different player, hold the cursor over your name at the top right of any lynda.com page and choose Site preferencesfrom the dropdown menu.

Continue to classic layout Stay on new layout
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.

Are you sure you want to delete this note?

No

Your file was successfully uploaded.

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com 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 lynda.com.

Sign up and receive emails about lynda.com 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.