"Drag and Drop" is another way to move messages in your Outlook Inbox,.
For example,  you can create a task from an email message you have received:

a) Click with the left mouse button on the email message in the Inbox, hold the mouse down, then drag the message
    without releasing the mouse button, and drop it on your Tasks folder.
    
   This action takes an email message and adds it as a task to your Tasks list (but doesn't include any attachments).
    It leaves a copy of the message in your Inbox. 

b) "Drag and Drop" with the right mouse button is another option.
    Click and hold on the email with the right mouse button. 
    Without releasing the mouse button, move the mouse pointer to the 
    Tasks folder and release the mouse button.
    You will now see the pop up window with options to copy or move the
     message. Click on the required option.

Format Painter is useful for copying a format to another piece of text. For example, if you set up a heading with a different font, size and alignment to the rest of your text, you can copy this heading format to the next heading you do.

To copy formatting once:

1. Click on the word with the format you wish to copy.

2. Click the Format Painter button once. 

3. Drag across the new word, which is to have the same format. 

To copy formatting more than once:

1. Click on the word with the format you wish to copy.

2. Double Click the Format Painter button.

3. Click and drag the paintbrush across all the words you want formatted.

4. Repeat as required

When you’ve finished, press the ESC key on the keyboard, or click the Format Painter button again to stop the formatting.

In Excel, you can format cells conditional on the value that is in the cell. In other words, the cell can be formatted differently (colour, font style, border) depending on the value in the cell. This is particularly useful when you want to highlight a value that has gone out of an acceptable range. e.g. For budget vs actual analysis of figures.

To add conditional formatting to a cell (or range of cells),

1.      Click into the cell, or select the range required.

2.      Click Format, then Conditional Formatting.

3.      Set the values required in Condition 1, then click the Format button to set the required format for this condition.
Set the values required in Condition 1, then click the Format button to set the required format for this condition.

4.      Click Add to add another condition to the formatting of the cell.

5.      Add Condition 2 and more if required.

6.      Click OK to finish.

 To delete a condition from the cell's formatting, click Format / Conditional Formatting, select the condition and then click Delete.

Yes, it's all available on the internet, but we do not want a search to return 500,000 results (or even more).
Six results is great, especially when targeted exactly on what you're looking for.

Choose a search engine and learn how to use it.  
Most search engines have a Search Tips area, which is worth having a look at.

We choose to use Google when searching. In the Address Bar of your Internet browser type www.google.com and click Go.

2010 is far less than 2,190,000 but still far too many to read. Notice I have put quotation marks around the words travel bookings, this means the words must come “one after the other” on the site or the site is not included on the list.

If you are still getting too many results, have a quick look at the sites that are being found and put a “-“ sign in front of a word that appears often.  This will reduce the number of “hits” you get.

Review the sites that appear and put a,    
“-“ sign in front of the words that are irrelevant,
"+" sign in front of a word that is required,          
as in above example.
(Be sure to include a space before the "+" or “-“ sign.)

Within Google searches are NOT case sensitive. All letters, regardless of how you type them, will be understood as lower case. For example, searches for "computer training", "Computer Training", and "cOmPuTeR tRaInInG" will all return the same results.  This does not apply to all search engines – refer the Search Tips area of each search engine for it's specific requirements.

1) The company’s internet address starts with https (rather than http) to indicate a secure site.
N.B. The https address will display at the time you choose to make your payment (not when you first view the site). 
Some examples are:          https:\www.ezibuy.co.nz
                                        https:\www.ticketek.co.nz    
                                        https:\www.amazon.com

2) The company has a security and privacy statement published on their web site.

3) The company has a physical address.

4) The site has a returns policy for unwanted goods.

5) The browser shows a key or locked padlock on the bottom right hand corner of the window.                                                  

Happy Shopping!

Ever tried adding a symbol to your Excel spreadsheet? It's easy in MS Word (Insert/Symbol) .... but in Excel there's no simple way. One option for this is to use "number codes".

Make sure your “number lock”  key on the keyboard is turned on.  Then, while holding down the Alt key - type the number (e.g.0162  from the list below), release the Alt key  and the symbol will appear (¢ in this case).

¢
£
¥
™
« »
§ 
¶ 
†  
‡  
º  
¼ 
½ 
¾ 
×  
÷  
±  
µ  
´   
²   
³   
¯  
þ  
Þ
å   
Å  
æ 
Æ  

Have you ever needed a way to quickly add up a column of numbers in Excel, but don't want to create a total?

In Excel there is a feature called AutoCalculate which does just that.

1) Highlight the list of numbers on your Excel column (or row).

2) Look on the Status Bar of your Excel window
(near the bottom of the screen, on the right hand side).

3) You'll see the words "Sum = " appear, with the total of the numbers you've highlighted.

It's also possible to change the function to Average the highlighted numbers, Count the number of entries or find the Minimum or Maximum number in the selected list.
To do this, right mouse click in the Status Bar area, and click (with left mouse button) on the function required.

Borders around objects or text can be a great way to make a document look more eye-catching. You can add borders to text, pictures, drawing objects, text boxes & clipart. 

Click on to the object to "select" it, or highlight text.
Click Format / Borders & Shading / Borders

Click on the Type of border required (Box, Shadow, 3D);
then the Style of line for the border (scroll to see selection of many different line styles); the colour of the border, and the width of the line.

You can set up a border to surround the whole page by clicking Format / Borders & Shading / Page Border.
Here, you have the same choices as before for the type, size, colour & width of your border, but also, there's another box for Art.
This gives you many choices of both fun and dramatic borders to surround your document. Really handy when you're making certificates, newsletters, posters, notices etc in Word or Publisher.
NB You may find the border takes up too much room when you're using BorderArt - try reducing the Width option to make the border fit your page better.