microsoft word training - Formulae in tables

The UK's most regular instructor-led training courses.
Training information: microsoft word training · Word courses london · Microsoft word training london

Resolved · Low Priority · Version Standard

Formulae in tables

Celine has attended:
Excel Introduction course
Word Intermediate course

by - delegate Celine [3 posts] (2008 Feb 4 Mon, 13:58) Reply

Can i have more details on those?

Thanks

Version	Date	Location	Places available	Book	Next place rate:
Word Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 16 Tue	Bloomsbury	3	book now	£224	£235
2007	2008 Oct 17 Fri	Bloomsbury	6	book now	£229	£240
2003	2008 Oct 28 Tue	Bloomsbury	8	book now	£187	£224
2003	2008 Nov 14 Fri	Bloomsbury	5	book now	£199	£224
2007	2008 Dec 12 Fri	Bloomsbury	4	book now	£229	£245
2003	2008 Dec 22 Mon	Bloomsbury	8	book now	£110	£224
Full Schedule: See all 21 Word Advanced course dates. Bookings currently available until 11th November 2009.

RE: Formulae in Word Tables

by - trainer Katie gold contributer [208 posts] (2008 Feb 11 Mon, 13:47) Reply

Hi Celine,

Thanks for your question.

In order to use formulae in Word tables, you must insert a table with a formula row/column to put the result in.

1. In the result cell, select TABLE menu.
2. FORMULA option
3. Under "Paste Function", choose an appropriate funtion
4. Under "Formula", you type in either the cell range (e.g. A2:A10) or just the direction (e.g. TOP).
5. Press OK

After updating numbers, you may press [F9] to update the result.

Hope this helps.

Regards,

Katie Woo
Microsoft Certified Trainer

· Microsoft Word Cheat Sheet: Tips and Shortcuts
· Five Time Saving Microsoft Word Tips
· Microsoft Word and its Uses in the Home
· Microsoft Word Editing Tips
· Students and Microsoft Word

Word tip:

Changing case

Sometimes, you're typing along and don't realize that you have left on or accidently pressed the Caps Lock key. Or maybe you have typed a paragraph in all caps then decide you would prefer to have it in title case or lower case.

Word provides you with several ways of changing case quickly:

1. You can change case by selecting the text and going to Format-Change Case. You can then choose from a variety of different formats including uppercase, lower case, sentence case, toggle case, and title case.

2. The keyboard can be used to change case. Select the text then use Shift key + F3 (function key) to cycle through the options (lower case, sentence case and all caps).

3. Word has an AutoCorrect feature that corrects accidental use of the caps lock key for you. You can find this feature under Tools-AutoCorrect Options. The "Correct accidental use of the cAPS lOCK key" should be checked.

View all Word hints and tips