pivot table in excelIf you’re studying Excel as a beginner or an advanced student, you’ve no doubt come across the phrase ‘pivot table’. Like most students, you may have seen a pivot table, but didn’t know how it was made. This post will explain what a pivot table is, how it’s used, and some important things to remember when setting one up.

Learn how to create pivot tables with this online course!

What is a Pivot Table?

Before getting into how to create a pivot table, let’s first explore exactly what it is and why it’s necessary.

A pivot table is a lifesaver for people who have to summarize and process large amounts of data from Excel tables and lists. In essence, a pivot table is a tool that makes summarizing this information much easier. Without pivot tables, you’d have to manually select, copy, paste, drag and drop the info into new cells and organize it all into a neat new table. If you want to compare data from a single list or table, you’d have create a separate table for each list manually. This is extremely time consuming and leaves room for too many human errors. This is why businesses as well as individuals who use Excel frequently, prefer to use pivot tables.

As mentioned above, a pivot table summarizes information from lists and tables in Excel. You don’t have to drag over a single cell, copy any info or type any formulas. It does it all for you, and here’s how.

How To Use a Pivot Table

Okay, before we walk you through creating a pivot table, it’s important to note that not all data is suitable for one. There are specific criteria that the data should meet for the function to work properly.

The criteria are as follows:

Creating a Pivot Table

There’re only two steps you need to complete to create a pivot table. Before beginning, select the cells that you want to add into the pivot table, then run the Pivot Table Wizard.

Step One 

  1. Select the option that says ‘Microsoft Office Excel List or Database’, then click next.
  2. Select the cells you’re going to use from the drop down menu, then click next.
  3. Select where you want the pivot table to go. The options available are ‘New Worksheet’ and ‘Existing Worksheet’. Once you’ve made your selection, click ‘Finish’.

Step Two

If you selected ‘New Worksheet’ in step three, you will be given the option to create a layout for the pivot table. If you want to save time, it’s best to organize the layout after you’ve created the table.

The pivot table contains clickable regions. When you click a region, options will appear on the right, which you can select to add the corresponding info for display in that field. After you insert all of the data, you can go to the layout option to create the look of your pivot table.

The bigger a pivot table is, the more complex it becomes to create; but rest assured that following these steps will help you through creating one — no matter how simple or complex. If you feel you still need help creating pivot tables, you can take an Excel 2010 IntermediateMicrosoft Excel 2013 Training Tutorial or Advanced Excel Training course, which will walk you through many hands on examples.

Top courses in Excel

Microsoft Excel - Data Visualization, Excel Charts & Graphs
Maven Analytics, Chris Dutton
4.6 (13,428)
Use Excel Like A Pro. Fast.
Kieran Luke
4.6 (984)
Excel Macros and VBA: Automate Your Excel Workload
Think Forward Online Training
4.7 (437)
Excel XML, XPath and XSLT Workflows
Grant Gamble
4.5 (176)
Microsoft Excel - Excel from Beginner to Advanced
Kyle Pew, Office Newb LLC
4.6 (152,332)
The Ultimate Excel Programmer Course
Daniel Strong
4.4 (12,952)
Microsoft Excel - Data Analysis with Excel Pivot Tables
Maven Analytics, Chris Dutton
4.6 (19,301)

More Excel Courses

Excel students also learn

Empower your team. Lead the industry.

Get a subscription to a library of online courses and digital learning tools for your organization with Udemy for Business.

Request a demo