Creating a Pivot Table in Excel…how do you do it? Watch the video to find out

Creating a pivot table and chart in Excel – how do I do this? Find out how this week below…

creating a pivot table in excel: Excel iconOne of the most useful and powerful features companies can use in Excel is the ability through Pivot Tables to analyse and summarise data. We deliver the following training locally:

  • IT Training Warwickshire
  • IT Training Worcestershire
  • IT Training Gloucestershire
  • IT Training Herefordshire

We also train IT in other counties and always seek to provide the essential skills in Excel and there’s no better way to analyse data in Excel than through a Pivot Table so… Firstly, what is a Pivot Table and Chart and secondly how simple is it to create one?


Data Sheet

It is really important to set up your list with details of the transactions in a certain way. Follow these rules and it’s a great start:

  • All your data on 1 sheet (even months/years as it’s very easy to filter by month/year)
  • Row 1 to contain field column headings: all different and not too long
  • Rows 2 onwards with no blank rows and no blank columns to contain your transaction data
  • No merge cells anywhere


Pivot Table layout

Once you have your Pivot Table again follow these steps:

  • Fill in the 4 boxes at the bottom right of your screen which allow you to design the PT with column/rows/filters and at least 1 value. The value may well be a quantity/sales value/product margin etc.
  • Drag and drop these fields (this is simple to do) until you are happy with the layout
  • Use Slicers to make filtering of the data easy

Below is a video which takes you through a live example on creating a Pivot Table and then a Pivot Chart.

Once you have these in place it’s a case of updating your transaction data and updating the data source so that the PT takes on board the latest data.

We hope you liked this hint and tip on creating pivot tables in Excel, why not take a look at our previous one on the BODMAS concept?


We have delivered Excel training courses in Worcestershire and Herefordshire recently where Pivot Tables have made a major impact on the efficiency of those businesses.

For all details of our Excel courses and details of IT training Herefordshire as well as the other counties we train in, please visit our web site here or phone us 07903 840105.

Cookie Control

Cookie control

We have placed cookies on your device to help make this website better.

I'm fine with this

We use cookies to give you the best online experience.

Please let us know if you agree to all of these cookies.

Some of the cookies we use are essential for the site to work.

We also use some non-essential cookies to collect information for making reports and to help us improve the site. The cookies collect information in an anonymous form.

To control third party cookies, you can also adjust your browser settings.

I'm fine with this
(One cookie will be set to store your preference)
(Ticking this sets a cookie to hide this popup if you then hit close. This will not store any personal information)
Information and Settings Cookie policy