WEBVTT

00:00.000 --> 00:13.160
Welcome to our Interactive Pivot Table tutorial.

00:13.160 --> 00:18.960
Join us as we explore how to analyze data using pivot tables in Excel.

00:18.960 --> 00:24.760
Featuring our sample data set.

00:24.760 --> 00:30.640
Our data set includes student names, subjects they've taken, their scores, and the test dates.

00:30.640 --> 00:34.880
We'll use this information to create an insightful pivot table.

00:34.880 --> 00:38.000
First, select the entire data set.

00:38.000 --> 00:42.880
Then, navigate to the Insert tab.

00:42.880 --> 00:48.920
And select Pivot Table.

00:48.920 --> 00:57.440
Choose a new sheet for the pivot table for a clear view.

00:57.440 --> 01:05.040
In the Pivot Table fields, drag student name to Rose.

01:05.040 --> 01:10.520
Scores to Values.

01:10.520 --> 01:15.560
And Subject to Columns.

01:15.600 --> 01:19.480
Notice how the data is now organized in the Pivot Table.

01:19.480 --> 01:23.520
Let's customize our pivot table for more specific insights.

01:23.520 --> 01:27.000
First, we'll focus on a particular subject.

01:27.000 --> 01:31.880
Drag subject into the Filters area.

01:31.880 --> 01:42.520
Now, select Mathematics from the Filter dropdown.

01:42.520 --> 01:47.880
Watch as the Pivot Table updates to show only Mathematics scores.