Excel 2019: Build PivotTables

Course description

This course introduces PivotTables, one of Excel 2019’s most powerful tools for summarizing and analyzing large datasets. You’ll gain a clear understanding of how PivotTables transform complex data into concise, meaningful summaries and support faster reporting without requiring formulas. The course explains how PivotTables allow users to group, filter, and calculate totals, averages, and other summaries while exploring data from different perspectives. You’ll also learn the importance of properly structured source data, including clear headers, consistent formatting, and repeated values within columns to ensure accurate results. The lessons guide you through creating PivotTables from both standard ranges and Excel tables, highlighting the advantages of tables for automatic expansion and simplified maintenance as data grows. The course also introduces when and why data can be added to the data model for more advanced analysis involving multiple tables. In the final section, you’ll explore the Fields Pane and learn how to assign fields to filters, rows, columns, and values to organize information effectively. Additional topics include customizing calculations, applying number formats, renaming field labels, rearranging fields, sorting results, and filtering data to focus on specific details. By the end of the course, you’ll understand how to create, format, and manage PivotTables to extract insights from large datasets and support flexible, efficient reporting in Excel.

Course outline