0:00
In many situations when working with
0:02
Excel, we are faced with large volumes
0:04
of data. Filtering and comparing this
0:07
data can be a time-consuming task if
0:09
done manually. However, with just a few
0:12
simple clicks, Excel allows us to
0:14
efficiently filter and summarize our
0:16
data using pivot tables. This is
0:19
extremely useful when we want to analyze
0:21
information without having to manually
0:23
compile individual reports or apply
0:25
formulas repeatedly. In this video, we
0:28
will learn how to create a pivot table
0:29
in Excel 365, which is a powerful
0:32
feature for data analysis. First, select
0:34
the data set you want to use for your
0:36
summary. This data should be organized
0:38
in a tabular format with clear headers
0:40
for each column. Once your data is
0:42
selected, go to the insert tab and
0:44
choose the pivot table option. Excel
0:47
will automatically detect the range you
0:48
selected and ask where you want the
0:50
pivot table to appear, either in a new
0:52
worksheet or in the existing one. You
0:55
can choose based on your preference. To
0:57
make the data easier to analyze, start
0:59
by dragging the column that contains
1:01
product names into the row section of
1:02
the pivot table field list. This step
1:05
will organize your table by product,
1:06
showing each item as a row. Next, if you
1:09
want to compare different aspects of the
1:11
data, such as sales figures or
1:13
quantities, drag the corresponding
1:14
fields into the values section. Excel
1:17
will automatically summarize the data,
1:19
usually by summing the values, and
1:20
display the results neatly grouped by
1:22
product. As you can see, this method
1:25
provides a clear summary of the product
1:27
data without having to manually filter
1:29
or reorganize anything. The pivot table
1:32
automatically groups and calculates the
1:33
information for you, which makes it much
1:35
easier to interpret large data sets
1:37
quickly. This is one of the most
1:39
efficient ways to summarize and compare
1:40
large sets of information in Excel. By
1:43
using pivot tables, you save time and
1:45
reduce the chances of manual errors
1:46
while gaining better insights into your
