 So one of the things that I can do now that I'm working with a little bit of a spreadsheet I've already built for us is the fact that You notice these titles are starting to go a little further than I really want them to What I can do is say for example, I know why the cage bird sings by Maya Angelou I can double-click on this cell And you're gonna notice that I actually have my cursor now inside of it One of the things I can do while I'm in here is I can say Hold down the alt key and if I press enter Notice what happens it didn't immediately jump to If I just hit enter by itself, it's just gonna immediately jump to the next cell but Holding alt in pressing enter. You notice how it jumps it down now if I hit enter You'll see that the entire row actually gets resized then I'm gonna do this again for reposition yourself reflections Holding alt enter Enter and then once again for interpretation of dreams by Sigmund Freud Now why would I want to do this? Well that allows me to shrink this down a little bit So one of the other things that we can do is let's say for example Let's cut off psychoanalysis if I click on psychoanalysis and I select word wrap up here Notice that'll actually also do it as well. That's pretty nice So one of the things I can do while I'm messing around inside of Microsoft Excel is you can notice I have a price and a quantity for each one of these books Now we started using the idea of cell referencing just a little bit ago so what I can do is I can actually find that sort of a Subtotal if you will and by utilizing cell referencing I start with the equal sign. I can select my G13 times my f13 Even though there's a dollar sign Excel understands that I'm dealing with currency and if I hit enter You see I get the calculated total now as you can guess I probably want to do this for Every one of these I want to do it for the 99 cent thing for the 150 or hundred ten dollar one one of the ways I can do this I can actually click on Sort of my 3990 notice what happens I have a border around my active cell and at the very bottom there I've got this tiny tiny little square right there notice what happened when I moused over it my mouse Changed to this little crosshair effect This is a plus sign. This is a crosshair notice the difference if I click hold and drag downward notice What's happening to my box? It's actually following me and now what will happen as soon as I let go is It's gonna actually take That same math equation notice up here in my address bar my formula bar That's what we typed in g13 times f13 down here g14 f14 Notice what's happening? It automatically was applying sort of the change that we did with it So as I went down it went down pretty nice Now one of the things I can do with this is that obviously I need to make a total and I'll go ahead and add these things together and I will do it the old timey way first equals one Plus two plus three plus four plus five when I hit enter I get Just under the three hundred dollars So one of the things that we're gonna have to factor in is the fact that okay. Well We're in North Carolina. Mr. Fuke is in California, so I'm gonna probably need to do some shipping, you know, so I see that we've got only we've got two digital but we also have Three actual physical copies, so I need to add in a new row One of the things I can do is if I click on row 18, I Can actually come up here to my insert tab. I actually don't even need to it's right there There's the insert tab and if I click on that drop-down menu. You see that I have insert sheet rows And that's actually gonna do exactly that notice what happened. I now have a new row. I can add in Shipping and before I even add in shipping notice my number didn't change this still stayed the same as well It understood that that's pretty nice I type shipping Well, go ahead and add in say maybe I don't know Ten dollars. I know that's a lot now. I do need to effectively add that in so plus H 18 and so now Notice what we've done. We've added in some new little effects