There are many reasons a financial analyst may want to use this function.
Launch Excel 2010, and open a spreadsheet on which you want to apply data Consolidation.
For instance, we have included worksheet, carrying student records, containing marks obtained by student in different exams.
To master the art of Excel, check out CFI's FREE Excel Crash Course, which teaches you how to become an Excel power user.
Learn the most important formulas, functions, and shortcuts to become confident in your financial analysis.
Check out our free Excel crash course to learn more tips, tricks, and best practices in Excel.
I need to take two excel files, each with multiple tabs, and combine them into one file, keeping all the tabs seperate (and possibly renaming tabs, if possible).
The rest of this article will show a simple example of how this process works.
I hope it will give you ideas of how to apply these tools to your unique situation.
sales-feb-2014sales-jan-2014sample-diff-1my-diff-1sales-mar-2014sample-diff-2my-diff-2sample-address-1sample-salesv3sample-address-2sample-address-3A lot of this data may not make much sense for this data set but I’m most interested in the count row to make sure the number of data elements makes sense. Now that we have all of the data into one Data Frame, we can do any manipulations the Data Frame supports.
In this case, the next thing we want to do is read in another file that contains the customer status by account.
As you can see in the screenshots below that we have included three worksheets containing students records in each exam.