Get the most out of the Teacher Learning Community. Sign in now. Not a member? Click here to get started for free!

Summarize and Analyze Data Using PivotTables and PivotCharts in Excel 2013

Preview Preview Preview Preview Preview
Buy Now


PivotTables are a great way to summarize and analyze your data, but in the past they have been a bit tricky to create. Excel 2013, however, makes it easy to create PivotTables with a single click using their Recommended PivotTables feature, which shows you possible PivotTables based on the data you've selected. In this webinar, join Jerry Swiatek as he discusses PivotTables and shows how to create a PivotTable using this feature. He will also show how to create a PivotTable without using this feature, as well as how to refresh the data within a PivotTable and how to change the source data. In addition, he will cover PivotCharts and explain how they can now be created without starting from a PivotTable.


Status: Available On-Demand
Subject: Other
Last aired on: Thursday, November 7, 2013 @ 4:30 PM EST
Duration: 30 minutes
Credit Hours: 0.5
Categories: Desktop Applications, Microsoft
Tags: Microsoft Excel 2013, PivotCharts, PivotTables, spreadsheets, worksheets

Reviews (25)

Full Member
great presentation/information!
very good info.
Basic Member
This had some great info to make calculations and visuals easier. Think I recall doing highlighting in the past for employers, where this tactic of pivot tables probably could have been recommended to save time.
Nice work
helpful - nice to learn about "slices"
Thank you for the ease of a spreadsheet, with a click of a button to organize data.
Basic Member
Wow! I like the slicer - that's useful!
Basic Member
This is useful. Thanks!
Basic Member
great overview of when and how to use
Basic Member
Very helpful presentation
more reviews ...