"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).
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
1 Comment
Look forward to seeing you soon,
Anita Lund Owner and Founder of Trainers Direct Pty Ltd (Sydney) www.trainers-direct.com.au & Storm Training & Solutions (UK) www.stormtraining.com In the first of our 2 minute tutorials we show you how to create a chart in Excel 2013 with 2 data series, and plot the second data series on a secondary axis. This is useful if you have a large variation in values. Yes, all in 2 minutes, it's that easy! Look forward to seeing you soon,
Anita Lund Owner and Founder of Trainers Direct Pty Ltd (Sydney) www.trainers-direct.com.au & Storm Training & Solutions (UK) www.stormtraining.com |
About The AuthorAnita Lund is an avid MS Office evangelist, trainer and Company Owner. Passionate about sharing the most useful tricks of the trade using plain English. Archives
June 2016
Categories
All
|