Posts Tagged ‘tools’

Calculate Totals Within a Table in MS Word

Wednesday, June 3rd, 2009

When you have a list of numbers and you want to show totals, you do not need to start Windows’ built-in Calculator to sum them.

MS Word can calculate totals and averages and do other simple calculations. In order to do this though, you must have your Tables and Borders toolbar visible.

Before you start, click on View | Toolbars or right-click on an empty space on an existing toolbar and select Tables and Borders.

Follow the instructions below to begin summing figures:

Simply place your cursor in a blank cell of your table, below or to the right ofthe numbers you would like to total.

Click the AutoSum (resembles a sideways letter M) button on the Tables and Borders toolbar to calculate totals automatically.

To make other types of calculations, Click on Table | Formula. This will open the dialog box.

If your figures should change, you must recalculate the formual. To do this, select the formula and press the F9 key.

When you place a formula in a table, the numbers appear with grey shading. They will not print in grey though. The grey shading simply lets you know that you have a formula, not just typed figures.

You can also total figures in paragraphs in MS Word. The Calculate function in MS Word ignores any text that is not a number, except for currency symbols, periods and commas, which it recognizes when they are part of a number.

For operations other than addition, you must include the mathematical operator. To force a calculation out of precedence order, enclose the expression in parentheses.

You can add the Tools Calculate button to any toolbar or shortcut menu by following the steps below:

  1. Select Tools | Customize.
  2. Click the Commands tab.
  3. In the Categories column, select All Commands.
  4. Scroll down until you find Tools Calculate.
  5. Drag the command to the Tools menu and place it wherever you  like or, you could just drag it to your toolbar.

It may appear greyed out as Tools Calculate is only available when you have selected text. By default, the Calculate command will add any set of selected numbers separated by white space. Word tmporarily displays the result in the status bar and also places it on the clipboard.

SAVE YOUR REPLIES WITH YOUR ORIGINAL E-MAIL IN OUTLOOK

Thursday, May 21st, 2009

As you all know, I am all about saving time and keystrokes. You must be highly organized to run an efficient office and this little tip is but one more way to achieve that end.  This article will also be very well liked by law offices especially.

I am sure there have been instances when you go back and re-read an e-mail and you have to scratch your head and wonder what your response was when you originally received it. This little tip will show you how to never have that experience again!

In most law offices, folks create special folders for client specific e-mail.  You must have folders other than your Inbox for this particular trick to work, so that is a very good thing.

The reason law offices do this is so that when a client calls and they need to referencethe client’s  latest e-mail, they don’t have to scroll through hundreds of other of e-mails to find it.

Follow the steps below to learn how to save your repleis with your original e-mails.

  1. Make sure that you have a special folder other than your Inbox to store client specific mail.
  2. Click on Tools | Options.
  3. At the top of the dialog box that opens, under the Preferences tab, under E-mail,  click on E-mail Options.
  4. Once that dialog box opens, under Message Handling, click the Advanced E-mail Options.
  5. Under Saved Messages, select In Folders Other than the Inbox, save replies with original message.
  6. Click OK three times to exit and you are finished.

Now, when you open up a particular client folder, you will not only find your original e-mail from them, but also your reply to that e-mail.  There will be no more guessing!

You may want to take a look around at the other options available to you under the Advanced E-mail Options even if just to make yourself more familiar with them.