Save Time! Use a Pivot Table to Analyse Data

"I need that report by..." 5 words that create panic in the work place when you have a list that's a thousand lines long, you need to summarise it and just don't know where to start. 

Chances are if you are doing lots of filtering, sorting and subtotalling on your Excel data lists, you're wasting a lot of time repeating tasks. If  you want to save yourself a stack of time, the tool to use is a Pivot Table.  This feature can be found under the Insert tab on the ribbon.

Select a populated cell in the list you want to analyse and click the Pivot Table icon. This will highlight the entire list including headers, and the Pivot Table analyses the data on a new sheet where you can manipulate that data in a variety of ways (see below).

Here's an example (you can download the file to practise yourself! or play the video tutorial at the end of this post).

amazon_referrals_pivot_data_2013.xlsx
File Size:	122 kb
File Type:	xlsx

Download File

---

Watch a short video tutorial here...

Look forward to seeing you soon,

Anita Lund
Owner and Founder of Trainers Direct Pty Ltd (Sydney)  
On Site MS Office, Excel, Word, PowerPoint, Outlook and computer training
www.trainers-direct.com.au
​& Storm Training & Solutions (UK) www.stormtraining.com