Give someone you love a Comp-U-Train gift certificate for Christmas and give them the gift that keeps on giving!

Pivot Tables

Pivot Tables

These are confusing to most people. I would like to clear up this confusion and give you some tips on creating a simple, user-friendly Pivot Table. These tables allow us to organise large amounts of data into a table that we can then Filter as well as many other features.

  • First of all we need to start with the data that you are putting into the Pivot Table. It is very important that we use uniform styles of writing items. This will ensure that they correct items all fall under each other in the table. If there is a full stop (period), comma or even slightly abbreviated that item will fall under a different list in the table.
  • Once we have all the information Uniform we can then start by selecting the entire data table
  • Once the data is selected we then can click on “Insert” and “Pivot Table”
  • A wizard then appears. This will guide us through the setting up of the Pivot Table.
  • Once the wizard is finished we end up with a page with the data headings on the right.
  • We now need to place the information on the page as we would like to see it. The page specifically mentions “Column Fields” and “Row Fields”. We place the information in the fields. There is a field called “Values” and this is only for figures

Once you have placed the information, the Pivot Table is ready to be used.

Comments are closed.

Give someone you love a Comp-U-Train gift certificate for Christmas and give them the gift that keeps on giving!
No announcement available or all announcement expired.