 So before we get into playing around with Microsoft Excel, we have to understand we have a few new definition terms We've got the idea of something known as a table now a table It's not like you know what we eat off of it's actually sort of this grid like structure and as you can see I'm starting to draw something out here You know, we we saw this in Microsoft Word. You saw we had to insert a table for example Well, it starts to break down even further notice how right now what I'm starting to add in are these Horizontal lines now these horizontal lines these are typically known as rows and That's exactly what they do is they just add section out off all of the horizontal sections But then I come in here and I also throw in some vertical lines Some vertical lines and what these are known as is columns Now this is where things differ a little bit in Microsoft Excel then in Microsoft Word where we were just working on inserting a tape one of the things you might notice is that we've started to introduce sort of One two three four five six and Let me erase this for a second You see that we started to add in these little notations on the top and bottom of everything So say for example, I have my one two threes on the bottom a b C conveniently D e F G Now I have a way to sort of identify which one of these I'm dealing with and I say these because we actually have another term as well. So say for example, I'm looking at This guy right here this one block Well, how do I refer to it? How do I say in particular that I'm talking about This guy well again the term that we like to use when we start thinking about this is We call this block something called a cell And the way you can think about it is now if I have the C column in the three row I would refer to this as Let's see where can I put it? I would say that this is the C three cell Now what I can do from here is if we think about it It's just like battleship once upon a time You all probably paid battleship if I were to draw out a ship across these three cells Little dingy here When you were playing black battleship what you would do is you would make these guesses You'd say something like a e2 e2 miss Well e3 e3 miss e4 ah e4 hit and You'd be looking at the e column and every time you set a number you would start to do a row Now what this breaks down into is something known as? cell referencing and The reason why is because inside of Microsoft Excel we start getting into a little bit I hate to say that we get into a little bit of algebra So now what I'm able to do is I'm able to say something like if we look for example that E4 that's where my ship was I can now specify that again using e4 But to signal this kind of thing inside of Microsoft Excel I would add in the equals sign Okay, well, why would I want to do that again? Inside of Microsoft Excel. We're no longer dealing with you know battleship. We're not dealing with Hits and misses what we're dealing with is typically numbers or letters or words But we need some way to reference these things. So Let's say for example that I have inside of My table inside of my grid. I have the number in C2 I have the number 10 I have the number 10 inside of C2 Well, what I can do via cell referencing is I can come down to B3 and I can go equal C2 times 10 Now what does this do? C2 again C2 References this C2 Then does the multiplication. So it's gonna move whatever was this you know C2 It takes whatever is inside of 10 or inside of a C2, which is 10 puts it here 10 times 10 and then all of a sudden inside of B3 what we'll get is 100