Daily Tips and Tricks Special Delivery - Microsoft

Smarter Navigation in Word You may already know that in Microsoft Office Word, the up-and-down double arrows below the vertical scroll bar will page up and down through an open document. But you might not know that you can use the Select Browse Object button (the little dot) below the vertical scroll bar to change the function of the double-arrow buttons and of the CTRL+PAGE UP and CTRL+PAGE DOWN keyboard shortcuts. You can, for example, choose to browse by heading, which means the buttons will automatically move the cursor up or down to the next heading. Other choices include browsing by footnote, endnote, comment, graphic, or table. Apply a Sum or Other Function to Every Row in a Data Range in One Step When you format a data range as a table in Microsoft Office Excel 2007, you can add a calculated column—a column of functions (such as sums or averages)—in just one step. To convert a data range to an Excel 2007 table, click in the range, and then on the Home tab, in the Styles section, click Format as Table, and then click to apply a table style. When your range is formatted as a table, click in a cell of any empty table column, or a cell in the column directly to the right of the table, on any data row. Then in just that cell, add the function or formula you need. (For example, sum all data on that row of the table.) When you press ENTER to apply your formula in that cell, the entire table column is populated with the same formula, adjusted for each applicable data row. If your insertion point was in the column to the right of the table, Excel formats that column to become part of the table when it generates the calculated column.

Preview Slide Shows For a quick preview of a slide show while you're editing a presentation, hold down the CTRL key while clicking View Show on the Slide Show ribbon. Instead of opening in full-screen mode, the presentation, starting with the current slide, appears in a small window over the slide being edited. To edit the slide and see your changes in real time, align the Microsoft Office PowerPoint window so that the preview slide is in view. Any modifications that you make appear in the preview window. Register Your Regular E-Mail Contacts as Safe Senders Here’s how to designate anyone you send mail to as a safe sender: 1. Click Actions, point to Junk E-mail, and then click Junk E-mail Options. 2. On the Safe Senders tab, select the Automatically add people I e-mail to the Safe Senders List check box. Now anyone you send an e-mail message to will be designated a safe sender.

Add Automatic Captions Follow these steps to add captions to your tables, figures, and graphics automatically in Microsoft Office Word 2007: 1. On the References tab, in the Captions section, click Insert Caption. 2. Click AutoCaption. 3. Select what you want to insert from the Add caption when inserting list. 4. In the Options section of the AutoCaption dialog box, choose the display options that you want to use. 5. Click OK twice.

Keep up to Date Whatever your business, there are bound to be freely available Really Simple Syndication (RSS) feeds for relevant blogs and Microsoft SharePoint sites. In addition to using a browser, you can now subscribe to RSS feeds from Microsoft Office Outlook 2007. Here’s how: Right-click RSS Feeds, click Add a New RSS Feed, and then enter the feed URL of your chosen site.

2003 to 2007 Out of Office Assistant If you're going on vacation, you can use the Microsoft Office Outlook 2003 and Microsoft Exchange Server 2003 Out of Office Assistant to send automatic replies to your coworkers with a message of your choice. However, most out-of-office replies are limited to internal contacts only. The improved Out of Office Assistant in Microsoft Exchange Server 2007 enables Outlook 2003 and Microsoft Office Outlook 2007 clients to send separate replies to internal and external contacts. You can also schedule when your out-of-office replies turn on and off. That way, you won't forget to turn them on as you're leaving, and your coworkers won't have to remind you to turn them off after you return. To use the improved Out of Office Assistant, click the Tools menu, and then click Out of Office Assistant. Find Calendars Quickly in Your Calendar You can arrange calendars alphabetically in your My Calendars list in Microsoft Office Outlook 2007. 1. Go to the Calendar view. 2. Right-click the My Calendars bar on the left side, and then click Arrange By Name.

Customize the Default Word Document Template If you want to customize the default template that Microsoft Office Word uses to create a new document, here’s how: 1. Make a copy of the default template in Word. You'll find the default template here: C:\Documents and Settings\yourname\Application Data\Microsoft\Templates\Normal.dotm (where yourname is the name you use to log on to your computer). 2. Store the copy of the template in a safe place. 3. Create the document that you want to use as a new template, and then save it on the desktop as a macro-enabled template. 4. Close all instances of Word. 5. Replace the default template in the location given in step 1. Your new template will now be the default. Creating a New Report Microsoft Office Access 2007 helps you make sense of complex information by offering easy-to-use interactive design tools that you can use to quickly create rich reports that display sorted, filtered, and grouped information. In addition to the traditional Report Designer (Design view), Office Access 2007 introduces a Layout view, so you can look at your data while you’re authoring the report. To create a report: 1. Open, or select in the navigation pane, a table, form, or query. 2. On the Create tab, in the Reports section, click Report. Access automatically includes all the fields in the object selected and opens the report in Layout view.