Archive for the 'Tips and Tricks' Category

Microsoft Word Tips – Create a Template from an Existing Word Document

If you have a Word document that you want to change into a template, then just follow these simple steps:

 

  1. Open up or have the document that you want to save as a template ready
  2. Click on the Microsoft Office button
  3. Navigate to Save As
  4. Click on the Arrow next to Save As and choose Word Template
  5. Find the location where you want to save the template
  6. Type in a file name
  7. Click Save

 

Have a look at you Microsoft Word Tips page for more useful information

Microsoft Publisher Tips – Insert Text from Another File Without Opening It

If you need to insert text from another document into a Microsoft Publisher design, here’s how to do it without having to open the file and copy and paste it:

 

  1. Create a text box you want to place the information in
  2. Click on Insert
  3. Choose Text File
  4. An Insert Text dialog box appears
  5. Locate the file you want to insert from your documents
  6. Double Click on the document
  7. The document will upload into your text box

 

Why not book yourself onto one of our Microsoft Publisher Courses if you wish to learn more.

Microsoft Project Tips – Track Progress on Projects

If you want to keep up to date on how much progress you have made on a project, follow these steps to track your progress using Microsoft Project 2007:

     

 

  1. Click on View
  2. Select Gantt Chart
  3. This will open up the Gantt Chart view
  4. Then click on Tools and go down to Tracking
  5. Select Update Project
  6. This opens up the Update Project dialog box
  7. Make sure the Update work as complete through option is checked
  8. In the date box, select the date you want to start tracking your tasks
  9. Click OK

 
Have a look at our Microsoft Project Courses for anything that might interest you

Microsoft Excel Tips – Command Shortcut Keys

Shortcut keys can save you a lot of time in Microsoft Excel; instead of going through all the settings you can just press a few buttons. Here are 10 useful command shortcut keys. 
 
Ctrl + A – Select all contents on the worksheet

Ctrl + B – Bold highlighted selection

Ctrl + I – Italic highlighted selection

Ctrl + K – Insert Link

Ctrl + U – Underline highlighted selection

Ctrl + 5 – Strikethrough highlighted selection

Ctrl + P – Open print dialog box

Ctrl + Z – Undo last action

Ctrl + F9 – Minimize current window

Ctrl + F10 – Maximize current window
 
Have a look at our Microsoft Excel Tips page for more useful information

Microsoft PowerPoint Tips – Add Animations to Presentation

If you want to add animations to your PowerPoint presentation in 2007, then just follow these simple steps:

     

  1. Click on the object you want to animate i.e. Text or Picture
  2. Click on the Animation tab on the Ribbon
  3. Click on the Custom Animations Button
  4. This opens up the Custom Animations Dialog Box
  5. Choose the Animation you want
  6. It will automatically set it
  7. Click on Remove if you want to delete the animation

 
Book yourself onto one of our Microsoft PowerPoint Courses if you wish to learn more.

Microsoft Outlook Tips – Increase Font Size While Reading Mail

Have you ever recieved an email with really small writing? Microsoft Outlook 2007 can increase and decrease the size of the emails font so you can read them more easily. There are two ways of doing it:

     

  1. Open up the email you want to read
  2. Hold down CTRL while turning the scroll wheel on your mouse Up to increase font size or scroll Down to decrease the font size
  3. Or you can click on Other Actions on the Ribbon and select Zoom
  4. This opens up the page size dialog box
  5. You can then Increase or Decrease the email size by a small amount
  6. Click OK

 
Interested in learning more? Then visit our Microsoft Outlook Tips page

Microsoft Access Tips – Convert a Form into a Report

If you have created a form in Microsoft Access and you want to convert it into a report then follow these steps:

      
     

  1. Open the form in Design View
  2. Click on the Microsoft Office Button
  3. Click on Save As
  4.  In the Save As Dialog box Select Report
  5. Click OK
  6. The system creates a report based on the form you have created.

 
Look at our Microsoft Access Courses for more information

Microsoft Word Tips – Edit 2007 Documents in Print Preview

Did you know you can edit your documents in Word 2007 Print Preview? This way you can see what your document would look like when printed, and if something isn’t right you can change it. Here’s how to edit it.

     

  1. Click on the Microsoft Office Button
  2. Go down to the arrow next to print and select Print Preview
  3. Make sure that the Magnifier Box on the Ribbon is Not checked
  4. You can then edit your document if you need to

 

Wea re going to write about the 2010 version next time so keep reading
 
Book yourself onto one of our Microsoft Word Courses if you want to learn more

Microsoft Publisher Tips – Design Checker

Before you print out a design in Microsoft Publisher 2007, try using the Design Checker, to catch out any flaws you may have missed. This utility checks your design looking for any design problems, for example, text that is too close to the edge of a page or an object that is not visible. Design Checker will allow you to correct any mistakes; instead of finding them after you’ve printed your design.

     

  1. On the Menu Bar click on Tools
  2. Choose Design Checker
  3. This will open up the Design Checker Pane
  4. It will list any design errors it has found in the pane
  5. Click on the dropdown arrow next to the error it has found
  6. Click on Fix, if you want it to change it automatically
  7. Click on Go to this Item, if you want to change it yourself
  8. If you don’t want something changed click on Never Run this Check Again
  9. Click on Explain if you don’t understand what it means
  10. Click on Close Design Checker when you have finished

 
Visit our Microsoft Publisher Tips page for more useful information

Microsoft PowerPoint Tips – Re-colouring Clipart Pictures

Did you know in Microsoft PowerPoint 2007, you can re-colour clipart pictures if you don’t like their original colours, if you want to change the colour here’s how to do it:

     

  1. Click on the Insert Tab on the Ribbon
  2. Choose Clipart
  3. In the Search for box, type in an image you want to use
  4. Double click on it to insert it into the slide
  5. Click on the Format Tab on the Ribbon
  6. Click on the Recolour icon
  7. Choose and click on the colour you want the image to have

 
Visit our Microsoft PowerPoint Tips page for more useful information