If you want to add or remove commands or customize the Quick Access Toolbar in Microsoft Excel, just follow these simple steps:

 
1. Right click on the Ribbon 
2. From the Menu, click on Customize Quick Access Toolbar
3. This opens up the customized options box
4. In the left column are the commands that are available, on the right are the commands that are on the toolbar
5. Select the Command you want to insert or to remove
6. Click on Add or Remove to add or remove it from the Toolbar
7. Click OK

 
Interested in learning more? Have a look at our Microsoft Excel Tips Page

It’s always a good idea to protect your personal files with passwords. With Project 2007 you can create a password for your project to prevent it from being accessed by unauthorised users.

 
1. Click on File and choose Save As.
2. On the tools menu in the Save As dialog box, click General Options.
3. This brings up the Protection password box.
4. Type in a password in the Password Protection box to prevent your file from being opened by a unautherised user.
5. Type in a password in the Write Reservation Password box, to protect your file from being edited by a unautherised user.
6. Click OK.

 
Have a look at our Microsoft Project Courses to see if anything interests you

When you receive a lot of emails, responding to them at once all can interrupt your work and distract you from what you are doing. In Microsoft Outlook 2007 you can set an email reminder, so you can sort out which emails need replying to more urgently, and which ones don’t need replying to straight away.

 
1. Click on the email you want to set up a reminder for
2. Click on the Follow Up Icon on the Ribbon
3. Select Add Reminder from the list
4. Choose the Due Date and Time you want the reminder to be set on
5. Click OK

 
Visit our Microsoft Outlook Tips page for more useful information

Shortcut keys can save you a lot of time in Microsoft Access; instead of going through all the settings you can just press a few buttons. Here are 10 most useful navigation keys that you can use.
 

CTRL+N – Open a new database

CTRL+O - Open an existing database

CTRL+F1 – Minimize the Ribbon

CTRL + P – Print

CTRL+Z – Undo

F5 – Switch from design view to form view

F7 – Check spelling

F12 – Open Save As box

ALT+F8 – Display the Field List.

ALT+F4 – Close Access
 
Why not book yourself onto one of our Microsoft Access Courses to learn more

Have you ever wanted to group several images together so that they become one picture? In Microsoft Word there is an option of grouping a number of images together so that when you move them around the page they all move together like they are one big image.

 
1. First click on the Insert tab on the Ribbon then select Shapes.
2. At the bottom of the menu click on New Drawing Canvas.
3. A box will then appear on the page. Insert or Paste any images you want into that box and position them the way you want.
4. Using your mouse, click and drag across the box to highlight the images.
5. Right click on one of them and choose the option for Grouping and click on Group. Now they are grouped together as one image.

 
Interested in learning more? Then visit our Microsoft Word Tips page or book one our Microsoft Word Courses to learn all about these great skills.

When you create a design in Publisher 2007 e.g. business cards, you can change the print settings so that you can print out multiple copies of them on one page instead having to print them out one at a time and use loads of paper. Follow these steps to achieve this:

 
1. Click on File and then choose Print Setup.
2. From Publication and Paper Settings tab, click on Multiple Copies per Sheet
3. You can then choose if you want to print them out in Landscape or Portrait
4. There is also the option of altering the Top and Side Margins so you can move your printout further across the page instead of it being at the edge.
5. Once you’ve selected options you want, click on Print.

Interested in learning more tips have a look on our Microsoft Publisher Tips page

PowerPoint 2007 gives you the chance to add sound effects to your presentations. This can make your presentation a lot more enjoyable and fun for your audience.

 
1. From the Ribbon, click on the Insert tab
2. Click Sound icon
3. You will get a few options to choose from like from File or from Clipart
4. Click on the sound effect you want
5. You will get a Dialog Box asking you whether you want the sound to come on Automatically or when you Click on the object
6. You will get additional tab – Options where you can Increase or Decrease the volume.

 
Interested in learning more? Visit our Microsoft PowerPoint Tips page or book a course

It is extremely annoying when you want to print out a worksheet in Excel and it can’t quite fit the whole sheet on one page. So it ends up spilling a small section over onto another page and wasting paper.
 
Excel has a handy scaling feature that allows you to specify how many pages you want your print out to occupy. You set the page dimensions, and Excel can shrink everything down so it fits in the specified area:

 
1. Set up your worksheet as desired.
2. Choose Page Setup from the File menu to get the Dialog Box.
3. Make sure the Page tab is selected.
4. Select the Fit To option and specify how many pages you want the printout to use.
5. Click on OK.
6. Print your worksheet as normal.

Do you want to learn more tips? Just visit out Microsoft Excel Tips page

When you have a task that occurs at the same time every week e.g. staff meeting, you can set a recurring task schedule in Microsoft Project. So the task has already been set, which saves you having to keep remembering it and writing it into your schedule:

 
1. Select Insert – Recurring Task
2. The Recurring Task Information Dialogue Box appears
3. Insert the Task Name, Duration, Recurrence Pattern, and Start Date and then assign any relevant calendar for the task.
4. Press Ok

 

Interested in learning more? Then visit our Microsoft Project Tips page.

When you create a new message in Outlook it just uses a plain white background, with Outlook 2007 you can change your background to have colours, or you can import an image from your files.

 
1. Open up a new message
2. Click on Options
3. Page Colour
4. Fill Effects
5. Click on the Picture tab then insert a picture from your documents to use as the background.
6. If you choose the Gradient tab you can just use colours

 
Interested in learning more? Have a look at our Microsoft Outlook Courses