Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member

Making calculations in a table

From: Word 2007 Essential Training

Video: Making calculations in a table

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.

Making calculations in a table

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.

Show transcript

This video is part of

Image for Word 2007 Essential Training
Word 2007 Essential Training

85 video lessons · 45728 viewers

David Rivers
Author

 
Expand all | Collapse all
  1. 40s
    1. Welcome
      40s
  2. 28m 24s
    1. Getting started with Word
      1m 21s
    2. Understanding the interface
      9m 23s
    3. Navigating the interface
      11m 24s
    4. Navigating documents
      6m 16s
  3. 18m 39s
    1. Creating new documents
      5m 25s
    2. Importing documents
      4m 35s
    3. Saving documents
      5m 41s
    4. Sending documents
      2m 58s
  4. 12m 35s
    1. Using Print Preview
      2m 45s
    2. Using Quick Print
      2m 31s
    3. Setting print options and printing
      7m 19s
  5. 23m 29s
    1. Selecting text
      3m 45s
    2. Formatting text
      5m 2s
    3. Using Find and Replace
      3m 35s
    4. Undo, Redo, and Repeat
      3m 26s
    5. Copying, pasting, and moving text
      4m 37s
    6. Showing formatting
      3m 4s
  6. 20m 30s
    1. Using indents
      3m 52s
    2. Setting justification
      3m 19s
    3. Changing line spacing
      4m 11s
    4. Setting tabs
      6m 10s
    5. Using the Highlighter
      2m 58s
  7. 38m 26s
    1. Changing margins
      5m 54s
    2. Changing orientation
      2m 29s
    3. Page numbering
      5m 41s
    4. Choosing paper size and source
      3m 59s
    5. Headers and footers
      7m 23s
    6. Applying a Page Background
      7m 56s
    7. Using Watermarks
      5m 4s
  8. 20m 10s
    1. Checking spelling and grammar
      4m 54s
    2. Finding synonyms
      3m 37s
    3. Looking up words and translations
      4m 55s
    4. Setting document proofing options
      6m 44s
  9. 23m 19s
    1. Modifying Environment settings
      7m 46s
    2. Modifying Display and Document settings
      6m 47s
    3. Modifying toolbars and keyboards
      8m 46s
  10. 15m 7s
    1. Creating a bulleted list
      7m 27s
    2. Creating a numbered list
      3m 36s
    3. Editing a list
      4m 4s
  11. 55m 28s
    1. Creating tables from scratch
      5m 29s
    2. Creating tables from text
      3m 25s
    3. Inserting an Excel spreadsheet
      5m 3s
    4. Modifying tables
      7m 44s
    5. Formatting tables
      7m 32s
    6. Making calculations in a table
      4m 13s
    7. Creating charts
      5m 44s
    8. Modifying chart data
      2m 8s
    9. Modifying chart appearance
      12m 29s
    10. Creating text from a table
      1m 41s
  12. 10m 18s
    1. Using Styles
      3m 3s
    2. Creating Styles
      3m 38s
    3. Editing and deleting Styles
      3m 37s
  13. 9m 21s
    1. Creating and using Building Blocks
      4m 27s
    2. Editing and organizing Building Blocks
      4m 54s
  14. 26m 23s
    1. Creating a Mail Merge
      13m 27s
    2. Creating a Data Source
      5m 21s
    3. Merging to create envelopes and labels
      7m 35s
  15. 8m 58s
    1. Sorting text
      4m 15s
    2. Sorting numbers
      2m 11s
    3. Sorting in tables
      2m 32s
  16. 10m 36s
    1. Creating Macros
      5m 40s
    2. Playing a Macro
      1m 46s
    3. Editing a Macro
      3m 10s
  17. 10m 13s
    1. Working with Newspaper Columns
      5m 31s
    2. Working with Parallel Columns
      4m 42s
  18. 24m 13s
    1. Working with Pictures and Clip Art
      10m 23s
    2. Working with Shapes
      5m 10s
    3. Working with SmartArt
      8m 40s
  19. 40m 40s
    1. Tracking changes
      7m 40s
    2. Reviewing changes
      3m 42s
    3. Sending and faxing documents
      3m 39s
    4. Password-protecting documents
      3m 4s
    5. Linking and embedding
      10m 7s
    6. Inspecting a document
      2m 43s
    7. Encrypting a document
      2m 45s
    8. Adding a digital signature
      7m 0s
  20. 30m 12s
    1. Creating cross-references
      3m 41s
    2. Creating a table of contents
      4m 8s
    3. Creating an index
      4m 43s
    4. Creating footnotes and endnotes
      7m 17s
    5. Using hyperlinks
      4m 24s
    6. Using bookmarks
      3m 26s
    7. Using a document map or thumbnails
      2m 33s
  21. 29s
    1. Goodbye
      29s

Start learning today

Get unlimited access to all courses for just $25/month.

Become a member
Sometimes @lynda teaches me how to use a program and sometimes Lynda.com changes my life forever. @JosefShutter
@lynda lynda.com is an absolute life saver when it comes to learning todays software. Definitely recommend it! #higherlearning @Michael_Caraway
@lynda The best thing online! Your database of courses is great! To the mark and very helpful. Thanks! @ru22more
Got to create something yesterday I never thought I could do. #thanks @lynda @Ngventurella
I really do love @lynda as a learning platform. Never stop learning and developing, it’s probably our greatest gift as a species! @soundslikedavid
@lynda just subscribed to lynda.com all I can say its brilliant join now trust me @ButchSamurai
@lynda is an awesome resource. The membership is priceless if you take advantage of it. @diabetic_techie
One of the best decision I made this year. Buy a 1yr subscription to @lynda @cybercaptive
guys lynda.com (@lynda) is the best. So far I’ve learned Java, principles of OO programming, and now learning about MS project @lucasmitchell
Signed back up to @lynda dot com. I’ve missed it!! Proper geeking out right now! #timetolearn #geek @JayGodbold
Share a link to this course

What are exercise files?

Exercise files are the same files the author uses in the course. Save time by downloading the author's files instead of setting up your own files, and learn by following along with the instructor.

Can I take this course without the exercise files?

Yes! If you decide you would like the exercise files later, you can upgrade to a premium account any time.

Become a member Download sample files See plans and pricing

Please wait... please wait ...
Upgrade to get access to exercise files.

Exercise files video

How to use exercise files.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.


Exercise files

Exercise files video

How to use exercise files.

For additional information on downloading and using exercise files, watch our instructional video or read the instructions in the FAQ.

This course includes free exercise files, so you can practice while you watch the course. To access all the exercise files in our library, become a Premium Member.

Join now "Already a member? Log in

Are you sure you want to mark all the videos in this course as unwatched?

This will not affect your course history, your reports, or your certificates of completion for this course.


Mark all as unwatched Cancel

Congratulations

You have completed Word 2007 Essential Training.

Return to your organization's learning portal to continue training, or close this page.


OK
Become a member to add this course to a playlist

Join today and get unlimited access to the entire library of video courses—and create as many playlists as you like.

Get started

Already a member?

Become a member to like this course.

Join today and get unlimited access to the entire library of video courses.

Get started

Already a member?

Exercise files

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships. Learn more

Get started

Already a Premium member?

Exercise files video

How to use exercise files.

Ask a question

Thanks for contacting us.
You’ll hear from our Customer Service team within 24 hours.

Please enter the text shown below:

The classic layout automatically defaults to the latest Flash Player.

To choose a different player, hold the cursor over your name at the top right of any lynda.com page and choose Site preferencesfrom the dropdown menu.

Continue to classic layout Stay on new layout
Exercise files

Access exercise files from a button right under the course name.

Mark videos as unwatched

Remove icons showing you already watched videos if you want to start over.

Control your viewing experience

Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.

Interactive transcripts

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.

Are you sure you want to delete this note?

No

Your file was successfully uploaded.

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.