Velsoft ResourcesMicrosoft – Tips n Tricks7th May 2010 – Kerrie Street
Velsoft Resources
Intranet Home PageCollaborationProfessional Development Site – nearly at the bottom of
the pageOffice 2007 Resources – Velsoft
There are several stepsRead the “Do’s” and “Don’t’s” Statements
Dos and Don’ts of Velsoft
Request PD Approval
Click on the Professional Development Link to send the email
When you have been confirmed click on the Office 2007 Resources - Velsoft link
Description Document – read this firstQuick Reference Guides – these are really goodOpen specific folder to find the information
Velsoft Folders
Folders containStudent workbook – be aware these are 200-
300 pages in lengthExercise FilesSkill Sharpeners
Microsoft Tips n Tricks
Outlook – Email Options
Love it or hate it, it is here to staySome modifications I always makeTools; Options; Email Options
Close original message on reply or forwardAdvanced Options
Show an envelope icon in the notification area
Customise Quick Access Barfor all MS products
Right Click; Add to Quick Access BarPrint PreviewAlign ObjectsFormat PainterPicture BorderCrop
Outlook – Calendar Options
Add a second time zoneUK or US
Calendar Options; Add Time Zone
Outlook – Print to One Note
Office ButtonPrintChoose Send to Office OneNote 2007Creates a portable electronic file of your emails.File; Save AsShare Screen to demonstrate
Outlook - Signatures
You can have multiple signatures, for example• KS LTU
• KS Wiki
Outlook Signatures can save time
Have you considered editing your signature to include commonly used standard information.
Here is my Adobe Connect signature
Signatures are set up under Tools; Options; Mail Format; Signatures
Outlook and Word – Quick Parts
This is by far the best way to cope with standard text comments.Highlight your text;Alt+F3Name itTo use it, type in the name and press F3
Share Screen to demonstrate
Outlook – Organize Colors
I like my unread messages to stand out – in hot pinkTools; Organize; Using Colors; Automatic Formatting; change the font
colour for unread messagesI like message from:
Louise Turnbull’s in blueBeth Hobbs in green
Outlook - Categories
A great way to group your information together
Right click under Categories column, apply a category
Click on Categories to sort
Outlook – Data File Management
Remove attachments, save the messageCreate Outlook FileCheck Properties
PowerPoint - Slideshow
Start slideshow – F5Start slideshow on current slide – Shift+F5To turn existing slide slide Black – BTo turn existing slide White – WThese are toggles, press B or W to resume slideshow
PowerPoint – Slide Master
To change overall fonts styleView; Slide MasterChange the font attributesClose Slide MasterShare Screen to demonstrateSeparate Screen for Title Slide, etc
Position ObjectsAlign objectsDistribute Horizontally/Vertically on ScreenThe red row is sitting on the screen as placed The blu erow have been aligned to the top and distributed horizontally
How to Nudge an object
Select the object and you can move using the mouse, or the directional arrows on your keyboard.
However, to “nudge” it slightly, hold down the Alt key and move with the mouse
Ctrl + arrow – tiny nudgesShare Screen to demonstrate
Microsoft Word
Keyboard Shortcuts – this will definitely improve your productivityCtrl A – selects allCtrl C – copiesCtrl V – pastesCtrl X – cutsWindows + DWindows + E
A comprehensive list is on the Techtime wiki
Styles in Word
Using StylesShortcuts for StylesRepeat Key – F4
Automatic Table of Contents - WordCreate document with heading
styles appliedReference; Table of contents;
Automatic Table 1 Your document now has the
TOC with automatic hyperlinks to the various pages
Document is available on Techtime wiki
Word – Quick Parts
Quick Parts – same steps as discussed in Outlook Insert File Name and Path
Insert; Quick Parts; Field; FileName (note you can add the path if necessary by ticking the box)
Customise Quick Access Bar
Excel
DemonstrateSheet Chart – F11Data Validation - Freeze panesPrint to one page wideBest Fit