Microsoft Office Courses

Creating a Pivot Table simply using a Table of Data

We post a number of hints and tips on different Microsoft Office courses, however Excel always comes out as being one of the most popular for hints and tips! In this week’s hint and tips we are showing how easy it can be to create a pivot table having first converted your range of data into a Table.

To begin with, we will cover some terms that will be used below.

Tables – Tables make it easy to sort, filter and format data within a sheet in Excel. A table is often created to analyse and organise related data. They can also be used when you are creating a pivot table.

Pivot Table – a pivot table is a tool within Excel that allows you to easily arrange and summarise complex data in a way that is easier to view and manipulate

An example of a Table in Excel is shown below

Microsoft Office courses - table within ExcelTo create a Table from a set of Data simply follow these steps
1. Lay out your data with headings on row 1 with no blank rows or columns
2. Select 1 active cell in your range and then choose the Insert Tab 

 

 

3. Choose Table from the left hand side of the ribbon. Click ok on the next screen: the range of data will be correct
4. Take the option now to Summarise with a Pivot Table
5. This has the advantage now that if you add extra rows to your data sheet then you do not have to Amend the Data Source simply just refresh.

A video of these steps with sound recording can be found by clicking here.

Further details on pivot tables can be learned on our Excel courses and are covered in Advanced Excel and the Master Class Excel series. We run these courses on site in the midlands along with other Microsoft Office courses. See www.jplcomputer.co.uk

We also launched some ‘training videos’ across a number of levels in Excel. Again for more details please contact us on johnlegge@jplcomputer.co.uk

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