How to create a Pivot Table in Excel
How to create a Pivot Table in Excel
Learn how to create a Pivot Table in Microsoft Excel. This tutorial demonstrates how to create an Excel Pivot Table with easy to follow steps.
Create a Pivot Table in 2016 (and sample data):
https://www.techonthenet.com/excel/pi…
Create a Pivot Table in 2013:
https://www.techonthenet.com/excel/pi…
Create a Pivot Table in 2011 for Mac:
https://www.techonthenet.com/excel/pi…
Create a Pivot Table in 2010:
https://www.techonthenet.com/excel/pi…
Create a Pivot Table in 2007:
https://www.techonthenet.com/excel/pi…
Create a Pivot Table in 2003:
https://www.techonthenet.com/excel/pi…
Excel Tutorials:
https://www.techonthenet.com/excel/in…
Don’t forget to subscribe to our channel for more great Excel tutorials!
Visit us at: https://www.techonthenet.com
or follow us on:
Facebook: https://www.facebook.com/techonthenetcom
Twitter: https://twitter.com/tech_on_the_net
Pinterest: https://www.pinterest.com/techonthene…
Content
0 -> A pivot table is a tool in Excel that allows you to quickly
summarize data in your spreadsheet
6.18 -> To illustrate how to create a pivot table,
let's look at a simple example
10.84 -> Here we have a table of data
containing order information
14.58 -> Let's use a pivot table to summarize this information
and display the total quantity for each order
20.82 -> To get started, highlight the cell
where you'd like to create the pivot table
25 -> In this example, we've selected cell A1
on Sheet2
29.14 -> Next, select the Insert tab from the toolbar
at the top of the screen
33.62 -> In the Tables group, click on
the pivot table button
36.96 -> A window called "Create Pivot Table"
should appear
40.14 -> Select the range of data for the pivot table
42.88 -> In this example, we'll select cells A1:F16
in Sheet1
48.18 -> This will be the source of data
for the pivot table
52.08 -> Now click on the "OK" button
55.14 -> A blank pivot table should now appear
on Sheet2 of your spreadsheet
59.96 -> Next, we will choose the fields
to add to the pivot table
64.06 -> To add order ID and Quantity,
select the check boxes next to these fields
69.58 -> By default, these fields are added
to the pivot table as summed values
74.56 -> Since we would rather see each Order ID
individually as a row in our pivot table
80.06 -> we will drag "Sum of Order ID" from the
Values section to the Rows section
86.38 -> Now each Order ID is displayed as
a row in the pivot table
90.52 -> However, Excel has defaulted the title in cell A1
to say "Row Labels"
96.06 -> Let's change the title to something more
meaningful such as "Order ID"
100.56 -> Our pivot table now shows all of
the order information summarized
104.38 -> We can see the Order ID values displayed in rows
with the total quantity for each order
111.02 -> This completes our example of how to
create a pivot table in Excel
115.28 -> If you would like to see
more examples
117.48 -> or would like to download
the sample data we used for this tutorial
120.92 -> please visit our website at
TechOnTheNet.com
124.16 -> If you have found our tutorial helpful,
please leave a like on this video
128.22 -> and don't forget to subscribe
to our YouTube channel for more great Excel tutorials
Source: https://www.youtube.com/watch?v=lVs37MPl9ik
