Excel is full of great tools for doing data analysis, in fact it is sometimes useful to import data from another application or database and analyse it in Excel. One of these great tools is the PivotTable. It is quick and easy to use and you can easily move your data around which might help you see the data better.

Other useful tools for data analysis in Excel include data tables, goal seek and the scenario manager.

Here is a video tutorial that will help you get started with PivotTables.