Instructor: Curt Frye
Many Excel users aren't sure how to use PivotTables. In this course, Excel power user Curt Frye shows you how to navigate the complexity of PivotTables while taking advantage of their power. Curt explains how to build PivotTables from single or multiple data sources, pivot and configure a PivotTable, define a default PivotTable layout, and more. He demonstrates ways to summarize your data, add calculated fields, filter your results, and format your layout to make it more readable.

Curt steps you through how to sort and filter PivotTable data, format your PivotTable and, and apply conditional formats. Plus, he goes over how to create PivotCharts to visualize your data, enhance PivotTables with macros, and use the Data Model feature to build PivotTables from related tables.

Note: This course was recorded in Microsoft 365. However, anyone using a recent standalone version of Excel (Excel 2021, 2019, or 2016) should be able to follow along with the course contents.

Learning objectives

• Determine when it is necessary to click Defer Layout Update in the fields area.
  
• Recall the easiest way to create a PivotTable from external data that cannot be imported directly as an Excel table.
  
• Explain the configuration that takes up the least width on the screen while keeping the Fields List area visible.
  
• Identify the mistake users often make when creating filters.
  
• Explore the function of slicers.
  
• Review the use of data bars with a PivotTable.
  
• Name the first step in viewing all the conditional rules applied to a PivotTable.
  
• Recognize the appropriate way to save a macro.
  

More Info







Free search engine download: Excel PivotTables in Depth