Shortcut keys to better view your diagram page area:

- To zoom in or out of the drawing page: Hold down the Shift + Ctrl key while either left-clicking (zoom in) or right-clicking (zoom out).

- To zoom in to a selected area: Hold down the Shift + Ctrl keys while you drag a selection around the area you want to zoom in on.

- To zoom out and view the entire page: Press the Ctrl + W keys.

- To pan the drawing page: Hold down the Shift + Ctrl keys while you click and drag with the mouse.

Click here to view our Training Calendar to see what other software tricks you can learn.

Using the Format Painter: to apply the same type of formatting to other items - select the text with formatting you would like to transfer to other text, double-click the Format Painter button (on the home tab), drag-select text you want to format, click on the Format Painter button once, to turn it off when finished.

Click here to view our Training Calendar to see what other software tricks you can learn.

You can name ranges of cells in Excel, like a column of information in a table, and then write formulas that use the names rather than cell references.  This makes formulas easier to understand when looking at them, so that you don’t have to refer to the specific cells. 

• 1. Select a range of cells
• 2. In the Name Box, above the row headings, type a name for the range - note that you cannot use spaces in the name
• 3. Type a formula such as =SUM(
• 4. Then click on the Formulas tab and in the Defined Names group, click on the Use in Formula button
• 5. From the drop-down list, select your named range and then finish your formula

 Click here to view our Training Calendar to see what other software tricks you can learn.

Absolute references refer to cells by their fixed position in the worksheet.  This distinction is important because when you start copying and pasting formulas from one location to another in the worksheet, relative references adjust automatically, while absolute references do not.  To identify a cell as an Absolute Reference in a formula, you need to type a $ in front of each cell reference, or you can simply hit F4 on your keyboard after you’ve typed the cell reference, and Excel will automatically fill these in for you: $A$1
Click here to view our Training Calendar to see what other software tricks you can learn.

You can add pre-outlined text from a word document into the Outline tab of a presentation.  This will allow you to quickly add content to your presentation without typing.

• 1. Click on the Outline tab
• 2. On the Home tab, in the Slides group, click the drop-down arrow under the New Slide button and select Slides from Outline
• 3. Select the document containing the text from your files
• 4. Click Insert

Click here to view our Training Calendar to see what other software tricks you can learn.

When you send and e-mail to a recipient, their email address is stored in your Auto Complete list.  This is the list that pops up whenever you start typing in an e-mail address in the To field.  This list can get rather long, so you can remove e-mail addresses from it by using this trick.

• 1. Click on the New button to create a new e-mail
• 2. In the To: field, type a letter and view the e-mail addresses that appear
• 3. Use the up or down arrow keys on your keyboard to select an e-mail address, then press the Delete button on your keyboard to remove it

Click here to view our Training Calendar to see what other software tricks you can learn.

You can add text to an existing PDF document without having to go back to the original application.

• 1. Click on the TouchUp Text Tool button
• 2. At the location where you would like to insert the text, press the Ctrl key on your keyboard then click where you would like to add the new text
• 3. In the New Text Font box, choose a font type
• 4. Type desired text, then click OK

Click here to view our Training Calendar to see what other software tricks you can learn.

There is a quick key function that will allow you to toggle between displaying all formulas in a spreadsheet to displaying all values (the default normal view).  This is helpful if you want to print out a sheet so that all formulas rather than values are visible, or it you simply want to note where the formulas are in a document.

• 1. Within a spreadsheet hold down the Ctrl key on your keyboard then press the ` key (hint: it is above your Tab key and to the left of the 1 key).
• 2. Press Ctrl ` again to return to normal view

Click here to view our Training Calendar to see what other Excel tricks you can learn.

Word 2007’s Compare feature allows you to compare 2 versions of a document (Legal Blackline) or combine changes from two reviewer’s edits into 1 document (either all at once, or by accepting or declining each edit).

• 1. Open word and click on the Review Tab
• 2. Click on the Compare button then choose either Compare or Combine
• 3. Browse to the desired documents on your PC from the dialog box, then click OK
• 4. Now you can view and accept each change if desired or save the blacklined document

Click here to view our Training Calendar to see what other Word 2007 tricks you can learn.

If you like to use keyboard shortcuts when using your Office Applications, the Office 2007 applications give you quick visual keyboard labels at the touch of a button.  You can display all available keyboard shortcuts by pressing the Alt key on the keyboard.  View the keyboard shortcut tips under each button on the ribbon.  Press the corresponding key on your keyboard to activate that option.  Press the Esc button or click anywhere in the application to close the Keyboard Tips.

Click here to view our Training Calendar to see what other software tricks you can learn.