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.