Tips & Tricks

Word 2010 Interactive Guide

Wondering where your favourite Word 2003 commands are located in the new Word 2010 interface? Or, just want to explore the new design with a little guidance?

Try the Word 2010 Interactive Guide > (For Internet Explorer only)

Once the Guide is launched, an interface identical to the Word 2003 menu appears. Click on the menu or button as you would on your 2003 interface and it will show you where to find this new button in the 2010 version. To explore the new options and commands offered in the 2010 version, hurry up and register for our training course on New Features in Office 2010.

Tricks

Tip #1 : how to convert lowercase letters to capital letters in a text

version : 2000 to 2007

Want to put an entire series of words or sentence in capital letters in an MS Word document without retyping it? Select your text and press Shift + F3. This shortcut allows you to switch over to modes: UPPERCASE, lowercase, Capitalize Each Word and tOGGLE cASE

Tip #2 : How to use the synonyms dictionary

To find the synonyms of a word selected on your page press Shift + F7.

Tip #3 : How to select a paragraph

version 2000 to 2007

Want to quickly select a paragraph in an MS Word document? Place your pointer anywhere in the paragraph and triple click.

Tip #4 : How to quickly move around in a document

version 2000 to 2007

Want to quickly move from one paragraph to the next in an MS Word document? Combine the Ctrl + Up Arrow keys or Ctrl + Down Arrow keys.

Tip #5 : How to add a watermark to your document

When you send a draft proposal to your personnel, you don’t want it to be mistaken for a final version. To prevent this from happening, insert a watermark indicating “Draft”, “Confidential”, “Sample” or any other expression of your choice.

version : 2002-2003

· Click on Format > Background > Insert Watermark.
· Make your selections and select either Translucent or Faded from the options.
· Click on OK.
version : 2007
· Click on the Page Layout tab.
· In the Background group, click on Watermark.
· Select the watermark of your choice.

Tip #6 : How to Copy & Paste more rapidly in a document

version : 2000 to 2007

Select the object to copy (highlight the text or select the object with its handles). Next, click on the object while pressing on the Ctrl key (a small + will appear next to the mouse pointer). Move this selection to the location you want to copy it to and release everything. This method is very effective since it allows you to quickly Copy & Paste text and duplicates repetitive elements in a drawing.

Tip #7: How to select the entire document using the mouse

version : 2000 to 2007

To select your entire document with the mouse, triple click in the margin on the left-hand side of your document.

Tip #8: How to quickly jump to the beginning of a document

version : 2000 to 2007

To quickly access the very beginning of your document press Ctrl + Home.

Tip #9: How to quickly go to the end of a document

version : 2000 to 2007

To quickly access the end of your document press Ctrl + End.

Tip #10: How to launch the spell checker

version : 2000 to 2007

To launch the spelling and grammar checker press the F7 key.

Excel 2010 Interactive Guide

Wondering where your favourite Excel 2003 commands are located in the new Excel 2010 interface? Or, just want to explore the new design with a little guidance?

Try the Excel 2010 Interactive Guide >

Once the guide is launched, an interface identical to the Excel 2003 menu appears. Click on the menu or button as you would on your 2003 interface, and it will show you where to find this new button in the 2010 version. To explore the new options and commands offered in the 2010 version, hurry up and register for our training course on New Features in Office 2010.

Tricks

Tip #1: How to enter the current date in a cell

version : 2000 to 2007

To quickly enter current date in a cell press Ctrl+;

Tip #2: How to enter the current time in a cell

version : 2000 to 2007

To quickly enter the current time in a cell press Ctrl+:

Tip #3: How to make a graph in less than 5 seconds

version : 2003 to 2007

To make a graph in less than 5 seconds, without using the Assistant (in 2003), select your data range and press the F11 key.

Tip #4: How to ask Excel to read data

Want to compare the values in an Excel column with those in a paper report you are working with? Instead of looking back and forth from the paper to your file, ask Excel to read your data!

2003 version

Select the data range to read and click on Tools/Vocal Functions/Display the toolbar Spoken Text and click on the Speak Cells button.

2007 version

In the 2007 version, this tool is not part of the Ribbon, but can be added in the Quick access toolbar. From the Office button, go to Excel options, Personalize. Then in the drop-down list of categories display All commands. In the tools list look for Speak Cells and add it to the Quick access toolbar.

Tip #5: How to add a new worksheet in the current workbook

version : 2003 to 2007

To add a new worksheet in an Excel workbook, you can use the following key combination: Shift+F11.

Tip #6: How to quickly select a column

version : 2000 to 2007

To select the column you’re currently in, press Ctrl + Space.

Tip #7: How to select the cells containing comments

version : 2000 to 2007

To quickly select all the cells with comments press Ctrl + Shift + O.

Tip #8: How to copy the content of a cell

version : 2000 to 2007

To copy the contents of the cell located above into the active cell press Ctrl + Shift + “.

Tip #9: How to select the entire worksheet

version : 2000 to 2007

To select the entire sheet press Ctrl + Shift + Space.

Tip #10: How to erase the borders

version : 2000 to 2007

To erase the borders of a selection of cells press Ctrl + _ (underscore).

Tip #11: How to eliminate duplicates in a selection of cells

2003 version

To extract a list of values while avoiding duplicates in an Excel 2003 column follow these steps:

· Click on “Data” tab;
· “Filter”;
· “Elaborate Filter”;
· In this menu, select the column where the duplicates are located;
· Check off the “Extract without duplicates” box.

2007 version

To extract a list of values while avoiding duplicates in an Excel 2003 column follow these steps:

· Select the range of cells you wish to extract without duplicates;
· Click on the Data tab;
· Click on the Remove Duplicates button.

PowerPoint 2010 Interactive Guide

Wondering where your favourite PowerPoint 2003 commands are located in the new PowerPoint 2010 interface? Or, just want to explore the new design with a little guidance?

Try the PowerPoint 2007 Interactive Guide. >

Once the guide is launched, an interface identical to the PowerPoint 2003 menu appears. Click on the menu or button as you would on your 2003 interface, and it will show you where to find this new button in the 2010 version. To explore the new options and commands offered in the 2010 version, hurry up and register for our training course on New Features in Office 2010.

Tricks

Tip #1: How to launch a slide show

version : 2000 to 2007

To launch your presentation press: F5. To start your presentation from the current slide press Shift + F5.

Tip #2: How to quickly add a new slide

version : 2000 to 2007

One of the fastest ways to add a new slide to your presentation is to use the shortcut: Ctrl + M.

Tip #3: How to go to a specific slide during your presentation

version : 2000 to 2007

In Slide Show mode, to go directly to a slide, type the number of the slide followed by Enter.

Tip #4: How to make a copy of the active slide

version : 2000 to 2007

To make a copy of the current slide press Ctrl + D.

Tip #5: How to display a white or black screen during a presentation

version : 2000 to 2007

To momentarily hide your presentation and bring back the focus on yourself during your slide show follow these steps. To display a black screen, press the B key; to display a white screen, press the W key. Press any key to return to the slide show.

Outlook 2010 Interactive Guide

Wondering where your favourite Outlook 2003 commands are located in the new Outlook 2010 interface? Or, just want to explore the new design with a little guidance?

Try the Outlook 2010 Interactive Guide >

Once the Guide is launched, an interface identical to the Outlook 2003 menu appears. Click on the menu or button as you would on your 2003 interface and it will show you where to find this new button in the 2010 version. To explore the new options and commands offered in the 2010 version, hurry up and register for our training course on New Features in Office 2010.

Tricks

Tip #1: How to quickly move e-mails to a folder

version : 2002 to 2007

· Select the e-mails that you want to move.
· Press Ctrl + Shift + V, a dialogue box will appear.
· Select the folder in which you want to move the e-mails, or create a new folder.
· Click on OK.

Tip #2: How to quickly enter a date for an appointment

version : 2003 to 2007

Did you know that you can enter a date in the form of text in the date field of a new Appointment? For example, you want to schedule an appointment in 2 days: just type “2 days” and Outlook will automatically find the date for you.

Better still! Enter “Day before Christmas” and it will give you 24/12/. It also works with New Years day, but not for Easter since it’s a holiday which doesn’t always fall on the same date from year to year and Outlook cannot foresee it.

version : 2003 to 2007

Do you receive a lot of e-mails and manually sort them in subfolders? Outlook can handle this for you using Message Rules.

· Go to Tools/Rules and Alerts and click on “New Rule”.
· Under Step 1, select: “Move messages from certain people to a special folder”.
· Under Step 2: click on “Redirect it to people or distribution list”.
· Click on “Specific Folder” to select in which folder you want the messages to be redirected.
· Click on “Finish”.

Tip #3: How to create a new message

version : 2000 to 2007

To quickly create an e-mail press Ctrl + Shift + M.

Tip #4: How to find all e-mails from a specific sender

Are you looking for an e-mail and all you can remember is who sent it to you? In Outlook, you can filter your messages to see only e-mails from a specific sender. Select a message from this sender from any email folder

version : 2003

Go to Tools/Search/Messages from sender.

version : 2007

Go to Tools/Quick Search/Messages from sender.