Data referencing tricks in Excel

In Microsoft Excel, you typically won't have…every single bit of data sitting on one big sheet.…To stay organized, data should be split up…into separate sheets, but that doesn't mean…it all can't be linked together.…Today's workshop is all about linking data…in Excel, and referencing those cells.…Whether it be in a single workbook or across…multiple worksheets in a workbook,…or even across multiple workbooks.…Alright.…The most important feature of a spreadsheet…is the ability to reference the contents of cells…and their ranges, so let's start here in this…workbook called NOH Profits 2014.…

Notice we're looking at the main tab,…and there are different departments here,…and you can see we're tracking revenues…and expenses, giving us our profits.…We'll go back to the main tab.…Alright.…in the same worksheet, and we're going to do it…using the mouse, which will make it easy…to navigate, so in cell A11, let's go over here…and type in the word total.…I'm going to type it in all caps.…Press enter, and it's locked in.…Now, we're going to go next door to cell B11.…