Dreevoo.com | Online Learning and Knowledge Sharing
 
Home | Programs | Microsoft Office | Microsoft Excel | Excel Pivot tables explained for the beginners
Guest
Click to view your profile
Topics
Programs
Languages
Recipes
Home
Shortcuts
 
 

Excel Pivot tables explained for the beginners

Using Pivot tables can really help you to see and present your Excel data in a nice and more functional way.

 
  Author: mat | Version: 2010 | 22nd October 2012 |  
 
 
1.
 

I'm going to show you the basics of Pivot tables usage on this simple Costs worksheet. Let's say I want a report of people sorted in groups and how much "they cost".

 
 
2.
 

First, I'm going to select the whole spreadsheet with the data I want to present in a Pivot report table.

 
 
3.
 

Click Insert in the menu and click PivotTable.

 
 
4.
 

In the Pivot Table settings, choose if you want the pivot table in the new or existing worksheet.

If you choose the Existing Worksheet ...

 
 
5.
 

Choose where on a worksheet you want that Pivot Table to be.

Simply click a cell and then click OK.

 
 
6.
 

A blank pivot table shows up.

 
 
7.
 

Now on the right you should notice the PivotTable Field List. As I said I want my report to show me the people sorted into groups, I need to choose the Name and the Group field of my table.

 
 
8.
 

And as I also want the cost next to the names, I selected the Cost field.

 
 
9.
 

And here's my simple Pivot Table sorted into the groups, with names that fall under them.

As I also added the costs, Excel automatically summed up the costs of individual groups and the grand total cost at the end.

 
 
10.
 

You can change the way the Pivot table looks like and the way it presents data, by simply clicking and dragging the fields into available areas.

I'm going to drag the Group filed from the Row Labels ...

 
 
11.
 

... to the Column Labels.

 
 
12.
 

And this is what happened. Instead of having my fields presented in rows, they are now sorted in different columns.

There are many more aspects of Excel Pivot Tables, you can do all sorts of complex reports and charts, this tutorial was only meant to get you started and to show you the basics of Pivot Tables and how can they make your life easier when dealing with vast amount of data.

 
 
 
   
  Please login to post a comment
  Click to open user profile  
Audrey, 27th Aug 2022, 11:21 AM
i really like this article please keep it up. เว็บ พนันบอล https://www.ufabetwins.com
 
 
  Click to open user profile  
piers, 4th Sep 2022, 2:25 PM
Wow, What a Excellent post. I really found this to much informatics. It is what i was searching for.I would like to suggest you that please keep sharing such type of info.Thanks อนิเมะ https://animedonki.com
 
 
  Click to open user profile  
piers, 7th Sep 2022, 2:15 PM
I love the way you write and share your niche! Very interesting and different! Keep it coming! 먹튀검증커뮤니티 https://toto-pro.net/
 
 
  Click to open user profile  
Audrey, 12th Sep 2022, 1:53 PM
Great survey, I'm sure you're getting a great response. brand design https://brand-designing.com/
 
 
  Click to open user profile  
Audrey, 15th Sep 2022, 2:48 PM
You make so many great points here that I read your article a couple of times. Your views are in accordance with my own for the most part. This is great content for your readers. logo maker https://brand-designing.com/
 
 
  Click to open user profile  
pomo, 10th Aug 2023, 9:36 PM
Very good points you wrote here..Great stuff...I think you've made some truly interesting points.Keep up the good work. asianbookie
 
 
  Click to open user profile  
activedetaili, 5th Jun 2024, 12:59 PM
Benefits of car detailing include long-lasting shine, ease of cleaning.
 
   
 
 
online learning made for people
Dreevoo.com | CONTRIBUTE | FORUM | INFO