{"id":1409,"date":"2012-12-03T10:38:49","date_gmt":"2012-12-03T10:38:49","guid":{"rendered":"http:\/\/www.microsofttraining.net\/b\/exceltraining\/?p=1409"},"modified":"2023-12-30T23:11:04","modified_gmt":"2023-12-30T23:11:04","slug":"what-is-a-pivot-table","status":"publish","type":"post","link":"https:\/\/www.stl-training.co.uk\/b\/what-is-a-pivot-table\/","title":{"rendered":"What is a pivot table?"},"content":{"rendered":"

It is possible to use Excel for data entry and miss out some of the tools that can make analysing and summarising data easy-peasy. For me, this was Pivot tables. \u00a0I avoided Pivot tables because a) I didn’t know what they were and \u00a0<\/em>b) I thought it would be too difficult to use as they sounded complicated.<\/em><\/p>\n

My solution needed a calm and experienced trainer and an Excel intermediate course<\/strong> to see the benefits of the Pivot table, with ready-made data to practise on (so I couldn’t break anything). \u00a0Here is what I’ve learnt….<\/p>\n

A Pivot table<\/strong>\u00a0is a tool used for\u00a0creating reports<\/strong>\u00a0that\u00a0summarise the data<\/strong>\u00a0in your database. \u00a0They can be created in a few mouse clicks (yes, really they can…).<\/p>\n

Why is is called a Pivot table?<\/strong>
\nThe pivot<\/em>\u00a0part refers to the way you can use a table to analyse data from different angles and perspectives<\/strong>. \u00a0The pivot part means you can move around your information, manipulate it, rotate it, group items, turn the data around to present it in the most digestible format for your needs.<\/p>\n

Pivot tables are\u00a0<\/strong>dynamic and interactive.<\/strong>
\n<\/em>With Pivot tables you can create summaries with whatever data you want to focus on, update them with new data by refreshing the table, and even add formulas to help you make new calculations.<\/p>\n

Pivot tables are flexible.<\/strong>
\nThis means that you have the flexibility to choose what you want to summarise and how you want to show it (by frequency, by month, by team, by customer, by account etc).<\/p>\n

Pivot tables are easy to update.<\/strong>
\nThis means when you enter or amend data into your database source, you can update your pivot table with the new figures by refreshing the content.<\/p>\n

You can customise they way they look.
\n<\/strong>You can use the Pivot table to create professional reports and customise them to meet your company branding.<\/p>\n

Why are Pivot Tables useful?<\/strong><\/p>\n

They Analyse data to meet your needs with a visual summary.<\/strong><\/em>
\nIt is much easier to analyse data in a large data sheet if it can be broken down into\u00a0usable\u00a0chunks of information, that are easy to read and understand.<\/p>\n

For example, if you wanted to analyse expenditure across five departments to identify trends, spot good practise (who is keeping overheads low) and see if there could be budget savings, or map expenditure to sales by month to identify gaps.<\/p>\n

You can use Pivot tables to answer specific questions about your data. \u00a0<\/strong>
\nYou have the flexibility to find out answers from your data. \u00a0Anything you are keeping in your database can be queried. \u00a0Such as: Do you want to know which month of the year has the most staff requests for annual leave? \u00a0Who is the member of staff generating the most sales? \u00a0Are there peaks of staff illness in the last year indicating a problem which could be tackled by addressing office environment?<\/p>\n

Now you have the definition and basics of why pivot tables are useful, you are closer to getting more out of your data. \u00a0Take the plunge and explore with an\u00a0Excel intermediate course<\/a>.<\/p>\n

 <\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

It is possible to use Excel for data entry and miss out some of the tools that can make analysing and summarising data easy-peasy. For me, this was Pivot tables. \u00a0I avoided Pivot tables because a) I didn’t know what they were and \u00a0b) I thought it would be too difficult to use as they […]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4],"tags":[204,417],"class_list":["post-1409","post","type-post","status-publish","format-standard","hentry","category-excel-training","tag-excel-intermediate-course","tag-pivot-tables"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1409","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/comments?post=1409"}],"version-history":[{"count":1,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1409\/revisions"}],"predecessor-version":[{"id":6691,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1409\/revisions\/6691"}],"wp:attachment":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/media?parent=1409"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/categories?post=1409"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/tags?post=1409"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}