Consolidate your Data with the Consolidate in Microsoft® Excel 2010
So when someone asks you to consolidate data from different spreadsheets in the same file, or from different files altogether, how do you do? Copy paste data from different files and the perform functions on them? There’s a simpler way to do this.
The Consolidate feature in Excel consolidates the data and also performs simple functions on the fly. For example, if you have to collate the productivity of your team where everyone has their individual spreadsheet; this feature could help you both merge the data and calculate its total.
Before you collate the data, you need to make sure that the data is uniform across worksheets or workbooks where you are picking them up from. Here’s how you can consolidate them:
- Click the ‘Data’ tab on the ribbon.
- Click the ‘Consolidate’ option in data tab.
- Now you can select the function you want to perform on the consolidated data.
- Then you need to give the range of the data. If the file is already open, you could just go to that file and select the data that you want to consolidate and select add. Repeat the same process if the data is present in more than one file.
- After you select all the data that needs to be consolidated, click ‘OK’
The data should now be automatically consolidated and displayed to you. Isn’t that simple? Make your work simple with the consolidate feature in Excel 2010!