Excel

How to Create a Basic Pivot Table? | Excel | Tutorial

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.

19 thoughts on “How to Create a Basic Pivot Table? | Excel | Tutorial”

  1. 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!

    Liked by 1 person

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.