 | Producing Consolidated Reports With Excel |  |
|
Added to Library on 19 Mar 2007
Length: 6 mins
View Tutorial Movie
Download File Used |
Consolidated reports in Excel are another rarely used, but powerful feature. If you have ever tried to merge excel spreadsheet data, either from different spreadsheets or even different work sheets in the same workbook then this technique will save you hours and probably many errors.
The Example uses 3 monthly reports and combines them to create a Q1 sales sheet. Without using this hidden feature in Excel this would have probably taken around 1 hour - instead you will see it can be done in just a couple of minutes
|
|
|
|
Feedback for this tutorial:
"Another time saving feature from Excel. Clayton your explaination made this feature very easy to understand and gave me the know how to beable to do it on my own. Thanks much, Kay"
"Clayton, Thanks so much for making the tutorials that I have purchased previously available to me for a refresher. I haven't consolidated for quite sometime and need to refresh my mind on the process. Thanks again, Kay Lenort"
"I will use this feature daily! What a time-saving function."
"This is definitely a must know...which I did not, and yet used work
books with numerous identical sheets, and did all the summary files by hand. All that will now change.
many thank!"
"Thanks for helping me find the solution to consolidating data. Your presentation made it easy to follow. It was worth buying the credits just for this but I know I will get a lot more help on various functions of Excel as I work my way through your tutorials.
I love Excel and use it in lots of ways in my work."
"Wow. Often seen "Consolidate" on the drop down but not really known how to use it....
Now I do.
Thanks Clayton for yet another very clear and consice tutorial.
Pikey"
|
|
|
| |
 | |  |
|
|
|
