"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...