Excel is on the face of it a simple tool however you can do some advanced data analysis with it, one of the things that would help is understanding how to do a pivot table.
A pivot table is a powerful tool that allows you to summarize large amounts of data in a concise, easy-to-read format. Creating a pivot table in Excel is a snap! Just follow these simple steps: