Microsoft Excel

To sum the values in a filtered list use the worksheet function named SUBTOTAL.

If you click the AutoSum toolbar button Excel will use this function to sum the values of only those rows visible in the filtered list. Change the filter parameters and the sum will be recalculated to display the sum of the currently visible rows.

To try it:

1. Enter the headings Class, Client, and Income in A1:C1.

2. Enter clients in B2:B10. Use classes Word Processing, Database Development and Editing
   at random for A2:A10. Enter incomes in C2:C10.

3. Select any cell in the list and choose Data\ Filter \AutoFilter.

4. Use the AutoFilter drop-down list for Class to select Editing. Only those clients who used your Editing service will be displayed.

5. Select cell C12 and click the AutoSum toolbar button.

Excel will use the SUBTOTAL function and the incomes from only the currently visible clients are totalled. If you select another class by using the Class drop-down list, Excel will calculate a new total.

Microsoft Outlook

It is easy to change the colour of a note; useful if you want to assign categories to your notes (for example: pink for personal, blue for business).

1. Open the Notes folder and select the note you want to change.

2. Right-click, point to Color, and choose a new color. If the note is already open, Left-click the icon in the top left corner, choose Color, and select the colour you want.

Microsoft Word

When finding and replacing text while editing , the following wildcards are useful—however, use with care to avoid unwanted results.

? Will find any single character:
“c?t" will find "cat”, "cot”, and "cut”.

* Will find any string of characters.
"b*d" will find "bad”, "bewildered”, and " bread”.

[ ] Will find one of the specified characters.
"b[ai]t" will find "bat" and "bit" but not "bet”.

[-] Will find any single character in the specified range (which must be in ascending order).
"[l-r]ight" will find "light”, "might”, "night”, and "right.

[!] Will find any single character except those specified.
"m[!u]st" will find "mist" and "most" but not "must”.
"t[!ou]ck" will find "tack" and "tick" but not "tock" or "tuck”.

[!x-z] Will find any single character except those in the specified range.
"t[!a-m]ck" will find "tock" and "tuck" but not "tack" or "tick”.

{n} Will find exactly n occurrences of the previous character or expression.
"re{2}d" will find "reed" but not "red”.

{n,} Will find at least n occurrences of the previous character or expression.
"re{1,}d" will find "red" and "reed”.

{n,m} Will find from n to m occurrences of the previous character or expression.
"10{1,3}" will find "10”, "100”, and "1000”.

@ Will find one or more occurrences of the previous character or expression.
"me@t" will find "met" and "meet”.

< Will find the beginning of a word.
"<inter" will find "interest" and "interrupt" but not "splinter”.

> Will find the end of a word.
"in>" will find "in" and "main" but not "inspiring”.