Creating a PivotTable View in MS Excel
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.
Minggu, 31 Agustus 2008
How to use 2003 to 2007 Page Layout View
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.
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.
How to Subscribe to a Web Calendar and View in Overlay Mode in MS Outlook
Subscribe to a Web Calendar and View in Overlay Mode in MS Outlook
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.
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.
How to Embedding Office Files and E-Mail Messages into Office OneNote 2007
Embedding Office Files and E-Mail Messages into Office OneNote 2007
In addition to the ability to cut and paste between Microsoft Office system programs, you can use Microsoft Office OneNote 2007 to embed files into a OneNote notebook. You can drag any file from Windows Explorer onto a OneNote page, or you can insert the file into the page by using the File command on the Insert menu. If you are working on a project, you probably use different types of documents to track pieces of the project. Now you can keep these documents together with everything else in Office OneNote 2007.
In addition to the ability to cut and paste between Microsoft Office system programs, you can use Microsoft Office OneNote 2007 to embed files into a OneNote notebook. You can drag any file from Windows Explorer onto a OneNote page, or you can insert the file into the page by using the File command on the Insert menu. If you are working on a project, you probably use different types of documents to track pieces of the project. Now you can keep these documents together with everything else in Office OneNote 2007.
How to Monitor Out-of-Office Messages in MS Outlook
Monitor Out-of-Office Messages in MS Outlook
The first time you send an e-mail message to someone who has turned on his or her out-of-office notification, you'll receive an automated e-mail message to inform you. At times, it's crucial that you see this notification so you can resend your message to someone else. By creating a rule that triggers a desktop alert, you'll spot out-of-office notifications as soon as they arrive. By adding extra conditions to your rule, you can also automatically mark an out-of-office message as read, and then move it from your Inbox to a different folder for later reference. This way, the next time you're unsure when someone will return from a vacation, for example, you can simply refer back to the out-of-office message that Microsoft Office Outlook automatically filed for you.
The first time you send an e-mail message to someone who has turned on his or her out-of-office notification, you'll receive an automated e-mail message to inform you. At times, it's crucial that you see this notification so you can resend your message to someone else. By creating a rule that triggers a desktop alert, you'll spot out-of-office notifications as soon as they arrive. By adding extra conditions to your rule, you can also automatically mark an out-of-office message as read, and then move it from your Inbox to a different folder for later reference. This way, the next time you're unsure when someone will return from a vacation, for example, you can simply refer back to the out-of-office message that Microsoft Office Outlook automatically filed for you.
How to Use Multiple Monitors to Present and See Notes at the Same Time in MS Power Poinr
Use Multiple Monitors to Present and See Notes at the Same Time in MS Power Poinr
Microsoft Office PowerPoint provides a feature you can use to show the presentation slides on a projector while keeping the Presenter view (with the speaker notes) on your notebook computer’s screen. To use this feature, you need to change your display settings. Here’s how:
1. Open the Display Properties dialog box by right-clicking the desktop and then clicking Properties.
2. Click the Settings tab.
3. Click the Secondary Display symbol (the 2).
4. Under the Screen resolution heading, select the Extend my Windows desktop onto this monitor check box. This setting gives you a desktop that spreads across both the projector and your notebook computer's screen.
You can now set up PowerPoint to use both screens.
1. Open your presentation.
2. On the menu bar, click Slide Show, and then click Set Up Slide Show.
3. In the Set Up Show dialog box, locate the Multiple monitors option, and select the Show Presenter View check box.
4. Start the slide show. The Slide Show view of the presentation appears on the projector’s screen, while the Presenter view and speaker notes appear only on your notebook computer’s screen.
Microsoft Office PowerPoint provides a feature you can use to show the presentation slides on a projector while keeping the Presenter view (with the speaker notes) on your notebook computer’s screen. To use this feature, you need to change your display settings. Here’s how:
1. Open the Display Properties dialog box by right-clicking the desktop and then clicking Properties.
2. Click the Settings tab.
3. Click the Secondary Display symbol (the 2).
4. Under the Screen resolution heading, select the Extend my Windows desktop onto this monitor check box. This setting gives you a desktop that spreads across both the projector and your notebook computer's screen.
You can now set up PowerPoint to use both screens.
1. Open your presentation.
2. On the menu bar, click Slide Show, and then click Set Up Slide Show.
3. In the Set Up Show dialog box, locate the Multiple monitors option, and select the Show Presenter View check box.
4. Start the slide show. The Slide Show view of the presentation appears on the projector’s screen, while the Presenter view and speaker notes appear only on your notebook computer’s screen.
How to Create Custom ScreenTips for Shapes in MS Office Visio 2007
Create Custom ScreenTips for Shapes in MS Office Visio 2007
Shape ScreenTips in Microsoft Office Visio are the boxed text that appears when you point to a shape. Some Visio shapes have built-in ScreenTips—usually the name of the shape (such as the name of a workflow step). However, you can edit existing ScreenTip text or create new ScreenTip text for shapes that don’t have a built-in ScreenTip.
To create or edit a ScreenTip:
1. Select the shape.
2. On the Insert menu, click either Shape ScreenTip or Edit Shape ScreenTip, as applicable.
3. In the Shape ScreenTip dialog box, type or edit the ScreenTip text.
4. Click OK.
Shape ScreenTips in Microsoft Office Visio are the boxed text that appears when you point to a shape. Some Visio shapes have built-in ScreenTips—usually the name of the shape (such as the name of a workflow step). However, you can edit existing ScreenTip text or create new ScreenTip text for shapes that don’t have a built-in ScreenTip.
To create or edit a ScreenTip:
1. Select the shape.
2. On the Insert menu, click either Shape ScreenTip or Edit Shape ScreenTip, as applicable.
3. In the Shape ScreenTip dialog box, type or edit the ScreenTip text.
4. Click OK.
Langganan:
Postingan (Atom)