Excel - General Question on Pivot Table - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

i need someone to get me through the basics of pivot tables
Solved by M. A. in 52 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 06/04/2018 - 06:55
Hello! Welcome to Excel chat.
User 06/04/2018 - 06:55
hello Ref
Excelchat Expert 06/04/2018 - 06:56
I understand that you want to learn some basics about Pivot tables.
User 06/04/2018 - 06:56
kindly help with my problem thanks
Excelchat Expert 06/04/2018 - 06:56
Excelchat Expert 06/04/2018 - 06:56
Please share your data.
User 06/04/2018 - 06:57
i dont have any data, like i said i would like to go through the major basics of pinot tables
User 06/04/2018 - 06:57
pivot tables sorry i swhat i meant
Excelchat Expert 06/04/2018 - 06:57
Excelchat Expert 06/04/2018 - 06:58
You want to know how to create a Pivot table?
Excelchat Expert 06/04/2018 - 06:58
May I know which Excel version you are using.
User 06/04/2018 - 06:58
of whta importance it is, how to creat e it and how to use it. am using excel 2016
Excelchat Expert 06/04/2018 - 06:59
Ok. Got it.
User 06/04/2018 - 07:00
Hello you are still there??
Excelchat Expert 06/04/2018 - 07:00
The importance of Pivot table : In simple terms, it summarizes your data in terms of sum, count, average etc.. Allows you to filter your data on various parameters.
Excelchat Expert 06/04/2018 - 07:00
Yes. I am here only.
Excelchat Expert 06/04/2018 - 07:01
Let me add some sample data to the sheet and then we will discuss a problem which can be solved by a pivot.
User 06/04/2018 - 07:01
Excelchat Expert 06/04/2018 - 07:02
Thanks. Just give me few minutes.
Excelchat Expert 06/04/2018 - 07:06
There is some data in the sheet now. Please have a look at that.
Excelchat Expert 06/04/2018 - 07:09
So, let's talk about a Pivot here.
Excelchat Expert 06/04/2018 - 07:09
Suppose you want to count Republican and Democrat voters and see it in a summary table.
User 06/04/2018 - 07:10
ok lets go
Excelchat Expert 06/04/2018 - 07:12
User 06/04/2018 - 07:13
so what now???
User 06/04/2018 - 07:13
is that th epivot table?
Excelchat Expert 06/04/2018 - 07:13
Please see the Pivot Table 1.
User 06/04/2018 - 07:14
how did u comre up to that?
Excelchat Expert 06/04/2018 - 07:17
Sure, let me explain the process.
User 06/04/2018 - 07:18
yo taking long to reply asap
Excelchat Expert 06/04/2018 - 07:19
I am sorry for that. But some issues at network at my end.
User 06/04/2018 - 07:19
Excelchat Expert 06/04/2018 - 07:21
Open your original spreadsheet and remove any blank rows or columns. Make sure each column has a heading, as it will be carried over to the Field List. Make sure your cells are properly formatted for their data type. Highlight your data range Click the Insert tab. Select the PivotTable button from the Tables group. Select PivotTable from the list.
Excelchat Expert 06/04/2018 - 07:23
That's how the pivot table is created.
Excelchat Expert 06/04/2018 - 07:27
Drag an item such as Last Voted from the PivotTable Field List down to the Row Labels quadrant. The left side of your Excel spreadsheet should show a row for each value. You should also see a check mark appear next to.

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc