Create a Basic PivotTable

Now that you know the best way to set up the data I’m going to show you, step-by-step, how to create a basic PivotTable, using that data.


PivotTables are a wonderful and very powerful database feature in Excel, but they are not the only story.  Don’t forget to look up all those many other database features such as Sorting, Filtering, Subtotalling and Grouping.

Then there are all those wonderful functions that help to automate your worksheets!

If you’re going to be using Excel regularly (and I hope you are!) then it’s really worth taking the time to learn all those wonderful features that are contained in it.

We offer access to courses from as little as €15 for one month!

Click here to view all courses

Take a look at the courses that we offer and check out the outlines to view the content contained in each course.

You know what they say: Knowledge is power.

So let Knowledge Market empower you, 5 minutes at a time.

Hi, I'm Kelly!

Picture of Kelly


1 Month or 1 Year Access

Access a course for 1 Month or 1 Year  Download supporting files!

Excel Course – I really enjoyed the training as it met all my objectives while providing valuable insights into the topics I thought I already knew. Made Excel much easier by charting out the logic. Thanks Kelly!
Shubhangi S.
Excel Course – I got a greater understanding of the basic functions and abilities of Excel, and the importance of structure and layout of data in the spreadsheet.
Tim F.