Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
You could think of the table as a miniature version of an Excel spreadsheet and like the spreadsheet, it's made up of columns, rows and cells. Also like a spreadsheet you can fill those cells with text, numbers and even formulas that can do math on those numbers. Now the kind of math, you can do in a Word table pales in comparison with what you can do in an Excel spreadsheet, but we'll look at some simple math right now in a table that we've been working with in previous lessons. So right here you can see I'm still working with shopping list 6 and if we want to all get on the same page, we can go to our Open button or click the Office button and then Open and navigate to the Lesson 10 folder of your exercise files, and we can open up shopping list 7.
Give it a click, click the Open button and this should look familiar. All right, let's start with some simple math. Tight over here in the second row, the last column, I'm going to click on to the word "total" and I want to do some simple math. You can tell that it's going to be the quantity times the price. To put a formula in here, I need to go up to the Layout tab and you can see Table Tools is selected, because I clicked inside my table. When I click Layout, I then get the Data group over here and there's my Formula button. When I click that by default, Word wants to pop in a Sum formula, which is actually going to sum up all the numbers to the left, and that's not what I want to do.
I want to do some multiplication. So I'm going to backspace over what's there using my backspace key, leave the equal sign in there and we're going to put in Cell A2, so that's column A, row 2. That's our number 12 down here. Times column C, row 2, that's C2. Then before I click OK, I can choose a number format that should go in there too and it really should be- ah, there it is, a dollar format. So I give that a click before I click OK.
Look at that. 47.88 is the total. Very good. Let's fill in the other two formulas now before we continue on with our number formats. So again, we go up to formula. Now this time, it's actually not going to be A2 times C2, this time it's going to be A3 times C3. And click OK. Now see what happened when I didn't change the number format? It's a different alignment and a different look altogether.
Can I go back and do it after the fact? You bet. I click the Formula button, my formula's still there. Change my number format to match the rest and there it is, the dollar. Click OK. That looks better. One more to go. So let's go back to our Formula button, put that one in and you guessed it, this time to be A4. And it is going to be times C4. Let's change our format before we forget, to dollars and click OK. OK, let's do one more for no one now that's going to total up the totals.
So in this case, we click down here at the bottom of our last column and we've already got the label in here for total. But what we're going to do here is actually sum up the numbers above our flashing cursor, right? So when we go up to the Formula button, look what's in there automatically, =SUM(ABOVE). All I need to do is choose the format, which is going to be dollars, and click OK. Look at that. Beautiful. Just so you know there are a number of functions that you can perform in a table in Microsoft Word.
Let's just take a quick peek at some of them. We'll go up to the Formula button and over here where it says Paste function, if we click this little drop down button you can see we've got absolute, and, average, count, defined, false. We've got a if statement. And as I scroll down you can see there's quite a few in here. Nothing compared to Microsoft Excel but still a pretty good selection. So we'll just click Cancel here because we've got everything we need in our current table.
Okay, it's time to move on now to making charts from the data in the table. That's coming up next.
Get unlimited access to all courses for just $25/month.Become a member
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.
Your file was successfully uploaded.