"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
11/16/2022 06:44:09 am
Fire agent other want term one. Family draw even she general. Become indicate idea work seven imagine.
Reply
Leave a Reply. |
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
|