0:00
When working with Excel 365, it's common
0:03
to deal with large volumes of data. One
0:05
useful technique is summarizing data to
0:07
highlight the highest values, which can
0:09
be important for performance
0:11
comparisons, business analysis, or
0:15
In this video, we'll focus on how to use
0:17
a pivot table to identify the maximum
0:19
value in a data set. To start, suppose
0:22
we want to find out which salesperson
0:24
achieved the highest transaction value
0:25
in a given month. Begin by inserting a
0:27
pivot table from your data set. Then
0:30
drag the field for salesperson names
0:31
into the rows area so that each
0:33
salesperson appears individually in the
0:35
report. Next, to analyze the transaction
0:37
values, drag the transaction amount
0:39
field into the values section of the
0:40
pivot table. By default, Excel will
0:42
summarize this data using the sum
0:44
function. However, since we are
0:45
interested in the highest value, we need
0:47
to change the summary function. Click on
0:49
the value field settings and choose max
0:51
instead of sum. Once this adjustment is
0:53
made, the pivot table will display the
0:55
highest transaction amount achieved by
0:57
each salesperson. For example, you might
1:00
see that Alice Newan has a maximum
1:01
transaction value of 1 to 550.
1:04
This same method can be applied to
1:06
analyze data by other criteria. For
1:09
instance, you can drag the region field
1:11
into the rows section to compare the
1:13
highest transaction value across
1:14
different regions. The pivot table will
1:16
then show the maximum value associated
1:18
with each region, giving a quick
1:20
overview of where the largest sales are
1:21
occurring. Using the max summary
1:24
function in a pivot table provides a
1:26
fast and effective way to pinpoint top
1:27
performances within your data. Whether
1:29
you're analyzing staff products or
1:31
regions, this approach helps you focus
1:33
on the most significant results. This is
1:35
a simple but powerful technique in Excel
1:37
365 to help you gain insights from your
1:39
data by identifying maximum values