Sometimes you will need to consolidate data from multiple sources, whether that's on the same worksheet in the same workbook or in different workbooks. So in this Screencast, I'm going to kind of show you how you can use the data consolidation tool in Excel. So I've got this file called consolidation and we've got information here. Maybe we have a bunch of employees and we have hours worked in maybe days worked in January, February, March. Somebody else provides similar information, so we have kind of same structure of data, maybe on a different worksheet. We've got even more data, so you can imagine maybe you have multiple people collecting data. And you want to kind of wrap it all up and consolidate it into one nice summary table. So on sheet2, I've got different months in each of these arrays. I've got different names and some of them are duplicates. And what we want to do is we just want to create a nice summary table that adds. So we're going to add all these items. So for example, Charlie in January, I would want to add 2 plus the 7 here and we want to take these two tables and consolidate it with this one. To do this, you first click on the cell of where you want this to be output, and then you can go up here to the Data Tab. And over here, there's a command button that says consolidate, so you can click on consolidate and first, it's going to ask for a function that you want to use. You can select from quite a few of these, if you want to count, if you want to average, if you want to find the maximum of those ranges that we're going to consolidate. So there's a lot of different ones there. We're just going to sum and now, what we need to do is we need to add our references. The first reference is going to be the first table, so I'm highlighting that entire region. This has labels both in the top row and the left column. So Excel is going to be looking through our references for Top row and Left column labels. Once I select that reference, I'm going to click Add and now, I can go over here and I'm going to select the second reference. So that table, I'm going to Add and now, I'm going to go over here to sheet2 and I've got this entire table that I'm going to Add, and when all of our references have been selected here, we're ready to go. So make sure your Top row, Left column are selected, if that's what you want to match. And then you can click OK and back on sheet1 is sort of wraps everything together. And that's where we have our summary table. So it has consolidated information from those three tables. I've got another example here. Maybe you send this worksheet to a bunch of employees and you have them place a 1 in the corresponding cell if they can meet at that time and day. What you're trying to do is to schedule a meeting, a weekly meeting that the most employees can attend. So here we've got Jim's information, on a second tab, I have Susie's information. Maybe we have other workbooks, we have Emily, Jennifer and Rex have put their data into this workbook. And then we have Charlie that has placed information in this workbook and maybe you want to insert a new workbook. That'll be kind of the summary of this, so I can click where I want that to be where the summary table to be. And then I can go up here to data consolidate data, and I'm going to some, because I want to calculate the total number of meeting times that work well for everyone as a whole. So I'm going to look for my references and press this up button, and I'm going to first go to Jim and Susie, so let's do Jim. I can select this entire region add that reference, then I'm going to browse again. We're going to go to Susie, add that reference and I'm going to do this for the remaining the three tabs on the second file, and then the one tab for Charlie's file. So now, I've got my six different sources, three files, six different tabs total, six different employees. And now, I can select Top row Left column and I'm going to go ahead and click OK and in my worksheet that I created. You can see that its consolidated the information and I can look through here and maybe I want to, I could do the maximum of that which would be 5 and I can look through here. And I can see that Tuesday 1 to 2 PM is a good time to meet, so I can schedule a weekly meeting then or it looks Friday from 11 to 12. So that's how you can use the consolidate data tool in Excel. Thanks for watching.