IT Training Scotland Edinburgh. Computer training for microsoft word, excel, access, office 97, office 2000, office xp, macromedia dreamweaver, fireworks, web design, adobe acrobat
tips and tricks archive
Our trainers have complied this archive as an example of just some of the amazing facts you will learn on our courses. Enjoy!
 
 
Microsoft Word
  1. Type =rand() then press enter to display a large chunk of text

  2. Select some text and hold down the CTRL and SHFT and press < or >, to decrease or increase the size of text visually

  3. When Word autocorrects text (i.e. ½ or 1st ) press Undo to cancel the autocorrect

  4. When in a bulleted or numbered list, hold the SHIFT key and press ENTER to insert a soft line break (allowing you to insert another paragraph within the same bullet or number)

  5. Right click on the small book on the status bar (at the bottom of the screen) to quickly hide spelling errors (i.e. the red wavy line). Works with grammar also

  6. To instantly calculate figures in word go to- Tools, Customise, Commands, Tools, Tools calculate

  7. Press F4 to repeat the last action

    More to come..

    ^ TOP
Microsoft Excel
  1. Hold down the CTRL and the ¬ Key to show or hide all formulas on your worksheet

  2. Press SHIFT F11 to insert a new sheet within an excel workbook

  3. Select all of your data and press F11 to produce an instant chart

  4. Press F2 to edit a cell

  5. Press F9 to recalculate formulas

  6. To edit a cell double click into the middle of the cell

  7. Right click on the Sheet navigation tabs to display a menu of all sheets in a workbook

  8. After selecting a group of cells containing numbers, look at the status bar (at the bottom of the screen) for a running total

    More to come..

    ^ TOP
Microsoft Outlook
  1. When addressing an e-mail, type the persons name (any part) and press CTRL K to confirm the name

  2. When sending an e-mail press CTRL and ENTER to send the mail quickly

  3. When composing a new mail choose View, Bcc Field to show an address bar which hides anyone's name from anyone else the e-mail is addressed to

  4. Right click on an e-mail in the inbox and choose Mark as Unread to remind you to read the message

    More to come..

    ^ TOP
Miscellaneous
  1. In Internet Explorer- simply type any word in your address bar, then press CTRL and ENTER to add the www. and .com automatically

  2. Press F12 in any office document for Save As...

  3. Hold the Windows key down and press E to quickly open windows explorer


    More to come..


    ^ TOP
iTrainScotland MMV