Excel 2013 Tutorials: Pivot Tables in Depth

with Curt Frye
please wait ...
Excel 2013: Pivot Tables in Depth
Video duration: 0s 4h 20m Intermediate


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


- [Voiceover] Hi, I'm Curt Frye. Welcome to Excel 2013, Pivot Tables in Depth. In this course, I'll show you how to use pivot tables to gain valuable insights from your organization's data. I'll begin by showing you how to create a pivot table from data already in your Excel workbook. Then, using that knowledge as a base, I'll demonstrate how to create pivot tables using data from an external source. I'll enhance your ability to analyze your data by showing you how to reorganized or pivot a pivot table. After you've organized your pivot tables data you can sort and filter it's 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 pivot table using macros, and summarize huge data sets using the power pivot add-in. Power pivot's 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.

please wait ...