Daily Tips and Tricks Special Delivery - Microsoft

Creating Organizational Charts 1. Start Microsoft Office Visio. 2. From the Business template section, click Organization Chart. 3. Click Import Organization Data from the Organization Chart menu. 4. Select your data sources. Click Information that's already stored in a file or database, and then click A Microsoft Exchange Server directory. 5. From the list of available fields on the left, select the information that you want to appear on your chart, and then click Add. 6. Click Next. Anything you add on the next page will be added as shape data (that is, not displayed in the diagram, but forming the properties of each of the shapes that do appear). 7. Choose your organization layout. To have Visio automatically display your organization as pages, select the I want the wizard to automatically break my organization chart across pages check box. 8. Select Browse in the drop-down list. 9. From the address book, select the person you want to appear at the top of your organization chart, and then click Finish. Publish Your Calendar to Microsoft Office Online Sharing your calendar information is even easier through the new publishing capabilities that Microsoft Office Outlook 2007 provides. Through this free Microsoft Office Online service, you can create dynamic Web calendars that your coworkers, friends, or family can subscribe to and that remain up to date. 1. Click the calendar. 2. Right-click the name of the calendar that you want to publish. 3. From the list, select Publish to Internet, and then click Publish to Office Online. 4. Follow the steps in the wizard to register for the service by using your Windows Live ID credentials. 5. When you’ve registered for the service, you can simply choose the calendar, time frame, and other settings. Outlook creates a sharing invitation that you can use to invite people to subscribe to your calendar.

Customize Your Pictures You can apply style, shadow, and crop effects to the pictures that you add to your presentations. You can create great-looking effects with just a few clicks. 1. On the Insert tab, click the Picture icon to browse for a picture to add to your slide. 2. After selecting your picture, go to the Picture Tools Format tab to see the available formatting options. 3. Pause on the items in the Picture Styles gallery to preview each of the prebuilt options. If you find a style you like, click it to apply the formatting to your picture. 4. If you want to apply custom formatting, select options from the Picture Shape, Picture Border, and Picture Effects galleries.

Research Unfamiliar Words and Phrases in Word 1. Open the Research pane: a. To access the Research pane quickly, press ALT and click the word that you want to check. b. To research a phrase, select the phrase, press ALT, and click the selection. 2. Customize your research options. At the bottom of the Research pane, click Research options, and then choose which services you want to use. For instance, you might want to switch to the U.K. English dictionary. Sorting and Filtering New options for sorting and filtering make Microsoft Office Excel 2007 the ideal tool for working with large amounts of complex data. The sorting and filtering menu is sensitive to the type of data you’re working with. To sort and filter: 1. To enable filter and sort options, do one of the following: a. Format your data range as a table. b. Select the headings of the columns that you want to sort or filter. c. On the Ribbon, on the Home tab, in the Editing group, click Sort and Filter. 2. To sort, click the AutoFilter arrow in the column heading, and then select the filter mode (in Office Excel 2007, you can also filter by cell color). 3. To filter, click the AutoFilter arrow in the column heading. a. Select individual values, and then select the filter mode. b. Select Number Filters, Text Filters, or Date Filters for more advanced filter options.

Subscribe to a Web Calendar and View in Overlay Mode You can use Web calendars to add and subscribe to calendars that cover a wide array of topics, such as industry conferences, sports schedules, or movie releases. 1. Click the calendar. 2. Click the Browse Calendars Online link. 3. On the Web page that appears, click a calendar from the list. 4. Microsoft Office Outlook asks whether you want to add the calendar to the list. Click OK. 5. The calendar will appear in Outlook, and you can view this calendar in overlay mode. To enable this view, ensure that both calendars are checked and visible side by side. Then, click the arrow on the title tab of the calendar on the right.

Creating a PivotTable View Microsoft PivotTable dynamic views help you change the axis that your data is organized around. To create a PivotTable view: 1. Click anywhere inside the range of data. 2. On the Ribbon, on the Insert tab, click PivotTable. 3. In the PivotTable Field List pane, check the fields that you want to visualize. 4. Rearrange your fields by dragging the row labels, column labels, and values to where you want them. 5. To add a filter, check the desired field, and drag it to the Report Filter box. Microsoft Office Excel will display the sum of the data in the value field, but you can quickly modify the field to track other totals types, such as average, minimum value, or maximum value: 1. In the Values box, click the arrow next to the value that you want to modify. 2. Select Value Field Settings. 3. Change the setting from Sum to the desired type of calculation. 2003 to 2007 Page Layout View How many times have you walked to the printer and discovered that your Microsoft Office Excel 2003 worksheet didn't print as you expected? You can use the Page Break Preview view in Excel 2003 to scale your data to particular pages, but a more realistic preview of the printed page would be helpful. Page Layout view in Microsoft Office Excel 2007 presents an exact representation of the printer output of your worksheet. Page Layout view also makes it easy for you to add headers and footers to your worksheet by simply typing the text where you want it to appear. To use Page Layout view, click the View tab, and then click Page Layout in the Workbook Views section.