Consolidate Initials Article For Free

hello and welcome to this video tutorial from computer gargled comm in this video we will use to consolidate feature of Excel to combine data from different worksheets or even different workbooks into one and I've got two examples of this feature in action now an example number one here I have this summary sheet it's just a blank sheet at the moment and I'm looking at consolidating the data from the sheets called location 1 location 2 and location free and if we have a look at these it's a very basic kind of cells data example I've got free mumps and I've got 5 products and you'll notice in each sheets they are an exact match with respect to the name of the products and name of the mumps and maybe this data has been exported from some kind of cells database or something and this is how we've I've received it or downloaded it and what we like to do is combine it all together and what the consolidate feature enables us to do is run a aggregate functional needs so I can combine them into a summary sheet and total up all these numbers let's have a look at this example and I've got another one to follow now I'll begin by clicking on a summary sheet and clicking the first sale or want my consolidated data to appear and I'll click on data at the top and consolidate on the far right and this is what it would look like now in Excel 2016 but this feature has not really changed over the years the very first drop-down list prompts you for the function to use now I am gonna stick with some I do want to total each of these figures you can see here we've got your your main players your sum count and average and in there the usual mob really that you see in your pivot tables and your subtotal functions depending what else you've used in Excel you see them along the bottom a lot of these as well I'm going to choose the sum function and then it will prompt me for the references now I've got free references they could easily be more than that I need to click in that reference box click on my first sheet and highlight the data and you can see it writes it in there is an absolute reference and I'll click the Add button to move it into the all references area now if I now go to location two you'll notice it writes down to the reference box and these happen to be the exact same reference so I'm happily click on add then jump to location three and click Add again if it was a different reference I'd highlight it and you'll see that in a moment in my second example so they don't have to be the exact same range please don't be misled by that yet that's just how this example works now I'm going to tick the use the labels in top row and left column here I do have the mumps in the top row the products on the Left column I want them to match up so it performs the total correctly I've got the opportunity to create a link to the source data here if the data allows free sheets change the datum summary sheet would automatically change if I tick that box in my example I'm assuming...