|We will be updating our servers tonight between 8:30 p.m. and 11:30 p.m. Pacific Time, which may cause some minor service interruptions. We will restore normal service as soon as possible. Thanks for your patience.|
Start learning with our library of video tutorials taught by experts. Get started
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.
(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.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
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.