How to Consolidate Worksheets in Excel

Video Transcript

"Hi, my name is Dave Andrews. Today, I'm going to show you how to consolidate worksheets in Excel. To begin, let's open up Microsoft Excel. Click on the start button, go to All Programs. Let's find Microsoft Office, and we're going to launch Excel. And you'll notice down here, at the bottom, I have many sheets -- Sheet 1, Sheet 2, and Sheet 3. Let's pretend that each one of these sheets is one of our employees in our company. Let's just right-click it and rename our employee Sheet 1. Let's call it Dave, and Sheet 2, let's call it William. Now, this spreadsheet is a spreadsheet for the number of sales, so let's put that in A1 -- Number of Sales. And down this column, we're going to put in some sales data for David. Now, let's do the same thing for William. In A1, let's type Number of Sales, and then William's sales data. Now, since our two employees are on different sheets, we want to be able to get a total for the number of sales between these two. We'll, maybe, average them together. What I'm going to do is get a total. I'm going to click where I want my answer to come, which is going to be in D1, and let's go to the Data tab, and we're going to say Consolidate. The function we have selected is sum, so we're going to add together the number of sales between David and William. You can also average them and run several other functions on them. Let's leave that as sum. Click inside the reference field and let's select David's data. With that selected, say add. Now, click inside the reference field again, click on William's sheet, and select William's data and say add. Now, just click okay. As you can see, their total number of sales have been added together and placed into this column. My name is Dave Andrews, and I've just showed you how to consolidate workbooks in Excel."