Pivot Tables in Excel – Data Analysis made easy!

Here at JPL IT Training Limited we run Excel training most of the time and two of our courses focus as a key element of that wonderful mysterious feature called Pivot Tables and Charts. Pivot Tables and Pivot Charts are great tools within Excel that you can use to make analysing your data easier and more effective that a basic chart. They can make analysis a large spreadsheet of raw data extremely easy!

You used to be have to be a 9th Dan Ninja expert to even think about using them but now they are available to all simply and quickly. See how below by following these simple steps.

  1. Ensure your master data has a single row heading at the top and continuous rows of transaction data underneath
  2. To insert a Pivot Table, make sure you have an active cell selected. Then select the Insert Tab and choose Pivot Table
  3. A new sheet is given looking like belowPivot Tables in Excel - Screen shot of a Pivot Table in Excel
  4. The sheet view that you can see above was created by simply dragging and dropping fields on the right hand pane into various quadrants at the bottom right. The resulting Pivot Table is hence created automatically on the left showing in this example a SUM of quantities sold by customer by part with filtering possible on year and period. (You can change the view from SUM to other functions like COUNT, AVERAGE, etc. by double clicking on the ‘SUM of Qty’ cell and changing the function to that you require).
  5. A new feature in later versions of Excel is the use of slicers.  These make filtering so simple. Again see the example below.

Pivot Tables in Excel - Screen shot of Slicers in Pivot Tables

For more details on our Excel training courses in Worcestershire, Herefordshire, Gloucestershire, Warwickshire and Leicestershire, or if you especially want to learn more about Pivot Tables in Excel, please email us at johnlegge@jplcomputer.co.uk or phone on 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 have placed cookies on your device to help make this website better.

You can use this tool to change your cookie settings. Otherwise, we’ll assume you’re OK to continue.

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