If you are like me you will have been scared by someone talking about Excel PivotTables. It could have been a colleague or a Job interview, but if you are unaware of this feature, this could be a scary thing.
However, PivotTables are really useful in summarising and making sense of a lot of data and they are really simple to do. Just follow these few simple steps:-
1. Prepare your Excel Data and create a Category column if your data is not already categorised. Type a category name for each transaction. These categories will be your summary points.
Ensure that your data has headings as these will be important in producing the final summary.
2. Select the cell you wish to have your PivotTable in and select Insert and click PivotTable. You can also choose it to be in another sheet or workbook.
3. Click the red button and select the entire range of your cells including the headings and click enter then select OK.
4. Tick Category and the other field you want and the summary PivotTable will be done.
I hope this gets you to overcome the fear of PivotTables....