A pivot table is an excel built-in tool which allows you to sort and summarise complex data. This table typically consists of rows, columns, and fields.
This tutorial will show you how to create a very simple pivot table.
Video Guide
Instructions
- Add the data that you want to analyse or summarise.
- Click on Insert – Pivot Table
- This gives you two options:
- New worksheet or
- Existing worksheet
- Click on any cell on the worksheet where you would like to have the Pivot table displayed.
- From the Pivot Table options
- Drag and drop the desired item into the row field – in this example “Department” which needs to be grouped together.
- Drag and drop the desired item into the field Value ∑ – in this example “Salary” which needs to be summarised.
- Once the table has been generated you could also format the data using the “Number Format” option to display Currency.
Simplify Tasks 
Clear and crisp! Looking forward for more posts! 🙂
LikeLiked by 4 people
Thank you!
LikeLiked by 4 people
It will rather help me, thank you.
LikeLiked by 1 person
The content was concise but hard to hear. Speak up a bit and I think bite sized tutorials like this could definitely gain some traction
LikeLiked by 2 people
Thank you for watching my tutorial and giving me some useful tips.
LikeLiked by 1 person
Excellent…
LikeLiked by 1 person
nice
LikeLiked by 1 person
I like your positive attitude. ‘Basic’ and ‘pivot table’ seem fairly oxymoronic don’t they? But I do like a challenge.
LikeLiked by 2 people
just loved it
LikeLiked by 1 person
Looking forward to read ur post again
LikeLiked by 1 person
Thanks I actually needed to know how to do this for work! Great job!
LikeLiked by 1 person
Keep up the good work. Website is clean. Excel is a powerful tool I will never forger the first time I ever say that program in action, lol, 1987. I was blown away.
LikeLiked by 1 person
Hi this is so cool 😎 love what your doing keep it up 👍
LikeLiked by 1 person
i work on Access noe the time. If you also concern on it…i wiish…..
LikeLiked by 1 person
Good and concise instruction.
LikeLiked by 1 person
Nice post thanx for sharing
LikeLiked by 1 person
thanks for sharing that! I really needed a easy to follow tutorial.
LikeLiked by 1 person
Thanks for your response
LikeLiked by 1 person
You might find the work of one of my colleagues, Margaret Burnett, of use. She’s done a lot of studies of how people get confused or make errors in EXCEL. She’s at Oregon State University in Corvallis I believe. Anyway, thanks for the info!
LikeLiked by 1 person
Great post
LikeLiked by 1 person
Following you
LikeLike
have read this post and if I could I want to suggest you some interesting things or advice.
I wish to read more things about it!
LikeLike