The image is an instructional graphic on the topic "Pivot Tables" in Excel. On the left side, the guide is divided into three sections. Each section includes bullet-pointed information and icons. On the right side, there are two screenshots for visual assistance.
The "Build" section explains steps to create a pivot table, including selecting data and inserting it from the Insert tab, dragging fields for categories, calculations, and comparisons.
The "Group" section outlines how to arrange date fields within rows, organize other fields, and use right-click options to group by time periods.
The "Functions" section describes how values automatically sum, with options for performing calculations like sum, average, and more.
On the right side, there is a screenshot of a pivot table displaying sums and averages across various regions and months, including categories like accessories and electronics. Shown below is a Pivot table layout with "product category" in Columns, "region" and "months" in Rows, and "sum of total amount" and "average of total amount" in Values.
A footer banner reads, "Strengthen your Excel Essentials at sites.google.com/asu.edu/excelessentials."
Pivot Tables
Build
Select your data range, including headers
Insert a pivot table from the Insert tab
Drag fields to Rows area for categories
Drag fields to Values area for calculations
Drag fields to Columns area for comparing data across categories
Group
Drag date fields to the Rows area of your pivot table
Place date fields above or below other fields based on desired organization of data
Right-click on date fields to group by months, quarters, or years
Expand or collapse groups using the +/- buttons
Functions
Values automatically sum
Click the dropdown arrow next to values then click "Value Field Settings"
Choose Sum, Average, Count, Max, Min, or other options
Add the same field multiple times with different functions
Strengthen your Excel Essentials at sites.google.com/asu.edu/excelessentials
©2025 Copyright by Laura Doherty. All rights reserved.