Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Excel Training and help » Consolidating data in excel 2007
|
|
|
Bookmark this page|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Consolidating data in excel 2007
Resolved · Low Priority · Version 2003
Reply
Consolidating data in excel 2007
What is the difference between producing a consolidating data and creating a pivot table?For upcoming training course dates see: Pricing & availability
RE: Consolidating data in excel 2007
Hi JasminaThanks for your question
They are 2 rather different things
Data consolidation involves aggregating data held in the same column and row format across different worksheets. For example you might have a table showing sales per employee per region, and have the same table in different sheets for different months. A consolidation would build a "master table", showing total sales per sales person per region for the whole year.
A pivot table however, takes data stored in the form of a list and provides a multidimensional analysis of it. This only works with excel databases and lists and allow a cross tab analysis of the different fields
Regards
Stephen
Mon 1 Mar 2010: Automatically marked as resolved.
|
 |
|
» Forum post: BODMAS |
Not sure of this..how is =A1+B1*C1 equal 7?
