As an EXCEL user, if you have been creating a lot of tables and have not yet been introduced to Pivot Tables, you are missing out on EXCEL’s most advanced & powerful business intelligence (BI) solution for data analysis. It comes with EXCEL and there is no need to pay for a plug-in.
Pivot Tables empowers you to visually & interactively slice & dice (BI’s jargon for filtering & segmenting your data repeatedly) your data to get to the level of data you require for reporting & analysis. And to further aid your analysis, present your results graphically as Pivot Charts which are linked to your Pivot Tables. They are dynamically updated as you work with the tables.