PDA

View Full Version : Solved: excels analysis tools



philfer
04-10-2008, 05:20 AM
Hello,

I am working on a workbook at work (!!) which basically takes a huge amount of data and then on subsequent sheet summarises it by :-

1) Person
2) All the people in a department
3) For the organisation as a whole

This includes current years figures with previous years as a comparison and a contrast to the budget figures

The workbook is growing out of control especially with all the formulae in it

I wonder if Excel has any built in analysis tools. I know there is Data Consolidate but I almost want to do the opposite of this.

Has anyone ever done anything like this in the past and have any advice for me

Thanks

rory
04-10-2008, 05:23 AM
Sounds to me like you want a pivot table, but it depends on the layout of your data and what output you want.