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.
How to use Welcome Center Windows Vista
Welcome Center Windows Vista
The first time you use Windows Vista, you see Welcome Center, which offers a wealth of introductory information to help you with Windows Vista. Topics include connecting to the Internet and news about Windows Vista. If you decide to close Welcome Center and instruct Windows Vista not to open it at startup, and then you change your mind, you can find it in Control Panel.
1. Click Start.
2. Click Control Panel.
3. Click System and Maintenance.
4. Click Welcome Center.
The first time you use Windows Vista, you see Welcome Center, which offers a wealth of introductory information to help you with Windows Vista. Topics include connecting to the Internet and news about Windows Vista. If you decide to close Welcome Center and instruct Windows Vista not to open it at startup, and then you change your mind, you can find it in Control Panel.
1. Click Start.
2. Click Control Panel.
3. Click System and Maintenance.
4. Click Welcome Center.
How to Format Chart Elements Just Like Shapes in MS Excel
Format Chart Elements Just Like Shapes in MS Excel
In Microsoft Office Excel 2007, charts have as much data-crunching power as ever. They’re also part of the new Microsoft Office graphics engine, so you can format charts with the same flexibility as other Microsoft Office drawing objects, such as shapes. To apply a style of formatting to the entire chart, on the Chart Tools Design tab, select an entry from the Chart Styles gallery. Or to apply custom formatting, select a chart element (such as a data series), and then click the Chart Tools Format tab for the option to apply shape styles, fill, outline, or effect formatting. From the Chart Tools Format tab, you can also apply WordArt formatting to the text of selected chart elements, such as the legend, axis labels, and data labels.
In Microsoft Office Excel 2007, charts have as much data-crunching power as ever. They’re also part of the new Microsoft Office graphics engine, so you can format charts with the same flexibility as other Microsoft Office drawing objects, such as shapes. To apply a style of formatting to the entire chart, on the Chart Tools Design tab, select an entry from the Chart Styles gallery. Or to apply custom formatting, select a chart element (such as a data series), and then click the Chart Tools Format tab for the option to apply shape styles, fill, outline, or effect formatting. From the Chart Tools Format tab, you can also apply WordArt formatting to the text of selected chart elements, such as the legend, axis labels, and data labels.
How to Save and Reuse Tables in Ms Word
Save and Reuse Tables in Ms Word
Do you frequently create the same type of complex table, such as a financial table or tables to use for custom page layouts? If so, you can save that table for easy insertion into any document by storing it in the Quick Tables gallery. Here’s how:
Select the table, and then press ALT+F3 to open the Create New Building Block dialog box. Type a name for your table, click the Gallery drop-down arrow, and then choose Tables from the list. You can set other options as well, such as choosing or creating a category for your table, which affects where in the Quick Tables gallery it is stored. By clicking the Save in drop-down arrow, you can indicate the template in which you want to store the table. However, if you leave the default Building Blocks.dotx as the Save in location, your table will be available to you for use in any document.
To access your saved table, on the Insert tab, click Table, and then point to Quick Tables
Do you frequently create the same type of complex table, such as a financial table or tables to use for custom page layouts? If so, you can save that table for easy insertion into any document by storing it in the Quick Tables gallery. Here’s how:
Select the table, and then press ALT+F3 to open the Create New Building Block dialog box. Type a name for your table, click the Gallery drop-down arrow, and then choose Tables from the list. You can set other options as well, such as choosing or creating a category for your table, which affects where in the Quick Tables gallery it is stored. By clicking the Save in drop-down arrow, you can indicate the template in which you want to store the table. However, if you leave the default Building Blocks.dotx as the Save in location, your table will be available to you for use in any document.
To access your saved table, on the Insert tab, click Table, and then point to Quick Tables
How to Use Outlook to View the Web using office outlook
Use Outlook to View the Web using office outlook
You can view the Web from Microsoft Office Outlook. Here’s how:
1. On the View menu, click Toolbars, and then click Web to display the Web address bar.
2. Enter a URL, and the view pane will become a browser while still retaining the Outlook Navigation Bar.
3. Click any navigation item or the Back button to return to your Outlook view.
You can view the Web from Microsoft Office Outlook. Here’s how:
1. On the View menu, click Toolbars, and then click Web to display the Web address bar.
2. Enter a URL, and the view pane will become a browser while still retaining the Outlook Navigation Bar.
3. Click any navigation item or the Back button to return to your Outlook view.
how to Share Custom Chart Types in MS Excel
Share Custom Chart Types in MS Excel
To save your active Microsoft Office Excel chart as a template that you can reuse or share, on the Chart Tools Design tab, in the Type section, click Save as Template. In the Save Chart Template dialog box, type a name for your new chart type, and then click Save.
To create a chart based on a chart template, on the Insert tab, at the bottom-right corner of the Charts section, click the dialog box launch icon to open the Insert Chart dialog box. Then click Templates to access your saved custom chart types. Each chart template is saved as an individual file that you can copy and share.
Saved chart templates are located in your Microsoft Office user templates folder, inside a subfolder named Charts. To locate your user templates folder, click the Office button, and then click Excel Options. Click the Trust Center tab, and then click Trust Center Settings. In the Trust Center dialog box, on the Trusted Locations tab, double-click the entry Excel 2007 default location: User Templates to view the full file path.
To save your active Microsoft Office Excel chart as a template that you can reuse or share, on the Chart Tools Design tab, in the Type section, click Save as Template. In the Save Chart Template dialog box, type a name for your new chart type, and then click Save.
To create a chart based on a chart template, on the Insert tab, at the bottom-right corner of the Charts section, click the dialog box launch icon to open the Insert Chart dialog box. Then click Templates to access your saved custom chart types. Each chart template is saved as an individual file that you can copy and share.
Saved chart templates are located in your Microsoft Office user templates folder, inside a subfolder named Charts. To locate your user templates folder, click the Office button, and then click Excel Options. Click the Trust Center tab, and then click Trust Center Settings. In the Trust Center dialog box, on the Trusted Locations tab, double-click the entry Excel 2007 default location: User Templates to view the full file path.
How to Deal Efficiently with Nonessential E-Mail While You're Out of the Office using outlook
Deal Efficiently with Nonessential E-Mail While You're Out of the Office using outlook
To create e-mail rules that apply only when you're out of the office:
1. On the Tools menu, click Out of Office Assistant.
2. Click Add Rule. In the Edit Rule dialog box that opens, you can set aside for later any nonessential messages you receive while you're away. Alternately, you can forward a copy of these e-mail messages to someone else.
To create e-mail rules that apply only when you're out of the office:
1. On the Tools menu, click Out of Office Assistant.
2. Click Add Rule. In the Edit Rule dialog box that opens, you can set aside for later any nonessential messages you receive while you're away. Alternately, you can forward a copy of these e-mail messages to someone else.
How to Modify the Report in MS Access
Modifying the Report in MS Access
Here’s how you can modify a report in Microsoft Office Access 2007.
1. Ensure you are in Layout view, which is the default view if you have just created a new report.
2. Select the fields (columns) that you want to delete (press SHIFT to select multiple fields), and then press DELETE.
3. Resize columns by dragging the column edge to the width you want.
4. To reorder columns, select the column that you want to move, and then drag it to another location.
5. Double-click the report title to modify it.
6. To add banded rows, select a row. Then on the Formatting contextual tab, in the Font section, choose a color from Alternate Fill/Back Color.
7. To add a group, in the Grouping pane, click Add a group. If the pane is not open, on the Ribbon, on the Formatting tab, click Grouping. Select the fields that you want to group.
8. To change to Landscape mode or adjust margins, go to the contextual Page Setup tab.
Here’s how you can modify a report in Microsoft Office Access 2007.
1. Ensure you are in Layout view, which is the default view if you have just created a new report.
2. Select the fields (columns) that you want to delete (press SHIFT to select multiple fields), and then press DELETE.
3. Resize columns by dragging the column edge to the width you want.
4. To reorder columns, select the column that you want to move, and then drag it to another location.
5. Double-click the report title to modify it.
6. To add banded rows, select a row. Then on the Formatting contextual tab, in the Font section, choose a color from Alternate Fill/Back Color.
7. To add a group, in the Grouping pane, click Add a group. If the pane is not open, on the Ribbon, on the Formatting tab, click Grouping. Select the fields that you want to group.
8. To change to Landscape mode or adjust margins, go to the contextual Page Setup tab.
Jumat, 29 Agustus 2008
How to Identify Duplicate Values in an Ms Excel Table
Identify Duplicate Values in an Ms Excel Table
In Microsoft Office Excel 2007, you can easily highlight duplicate values with conditional formatting.
1. Select the list in which you want to identify duplicates.
2. Click the Home tab on the Ribbon.
3. In the Styles section, click Conditional Formatting, point to Highlight Cells Rules, and then click Duplicate Values. Pairs of duplicates will then be highlighted, and you can choose which of each pair to delete.
In Microsoft Office Excel 2007, you can easily highlight duplicate values with conditional formatting.
1. Select the list in which you want to identify duplicates.
2. Click the Home tab on the Ribbon.
3. In the Styles section, click Conditional Formatting, point to Highlight Cells Rules, and then click Duplicate Values. Pairs of duplicates will then be highlighted, and you can choose which of each pair to delete.
How to Integrate All Your Types of Communication from MS Outlook
Integrate All Your Types of Communication from Outlook
Suppose you are working in Microsoft Office Outlook 2007 and want to call the person who sent you an e-mail message. Or perhaps you want to send the person an instant message but don’t know whether he or she is online. By using the integrated presence information provided by Microsoft Office Communicator 2007 and Microsoft Office Live Communications Server 2007, you can easily initiate a phone call or even an instant messaging conversation.
Suppose you are working in Microsoft Office Outlook 2007 and want to call the person who sent you an e-mail message. Or perhaps you want to send the person an instant message but don’t know whether he or she is online. By using the integrated presence information provided by Microsoft Office Communicator 2007 and Microsoft Office Live Communications Server 2007, you can easily initiate a phone call or even an instant messaging conversation.
How to Add Folder to Quick Launch in Windows Vista
Add Folder to Quick Launch
When you find that you are repeatedly returning to and opening the same folder, you can add it to the Quick Launch bar. A handy one to add is the Saved Searches folder.
1. Click Start.
2. Click your user name.
3. Drag the Saved Searches folder to the Quick Launch bar.
When you find that you are repeatedly returning to and opening the same folder, you can add it to the Quick Launch bar. A handy one to add is the Saved Searches folder.
1. Click Start.
2. Click your user name.
3. Drag the Saved Searches folder to the Quick Launch bar.
How to Drawing Lines in MS Word
Drawing Lines in Word
You can create a line across the page of your Microsoft Office Word document or Microsoft Office Outlook e-mail message by using just a few keystrokes.
• To create a normal line, type three consecutive hyphens, and then press ENTER.
• To create a bold line, type three underscores, and then press ENTER.
• To create a double line, type three equal signs, and then press ENTER.
You can create a line across the page of your Microsoft Office Word document or Microsoft Office Outlook e-mail message by using just a few keystrokes.
• To create a normal line, type three consecutive hyphens, and then press ENTER.
• To create a bold line, type three underscores, and then press ENTER.
• To create a double line, type three equal signs, and then press ENTER.
How to Upgrade Old Documents to 2007 Versions in MS Word
Upgrade Old Documents to 2007 Versions in MS Word
If you receive a document from a colleague who is not yet running the 2007 Microsoft Office system, the 2007 Office system will automatically open it in Compatibility Mode. However, not all the new features will be available to you. When you close the document, it will be saved in its original format, not in the format of the 2007 release.
If you want to upgrade the file to the 2007 Office system:
1. Click the Office button, and then click Convert.
2. In the Microsoft Office Word dialog box, click OK, and then click Save.
Note: You may want to make a backup copy of the file before you upgrade it . Also, to see when you are working in Compatibility Mode, look at the top of the screen. The phrase Compatibility Mode will appear in brackets to the right of the file name.
If you receive a document from a colleague who is not yet running the 2007 Microsoft Office system, the 2007 Office system will automatically open it in Compatibility Mode. However, not all the new features will be available to you. When you close the document, it will be saved in its original format, not in the format of the 2007 release.
If you want to upgrade the file to the 2007 Office system:
1. Click the Office button, and then click Convert.
2. In the Microsoft Office Word dialog box, click OK, and then click Save.
Note: You may want to make a backup copy of the file before you upgrade it . Also, to see when you are working in Compatibility Mode, look at the top of the screen. The phrase Compatibility Mode will appear in brackets to the right of the file name.
How to Turn Any 2-D Shape into a 3-D Object in MS Powerpoint
Turn Any 2-D Shape into a 3-D Object in MS Powerpoint
Want to convert a flat shape in Microsoft Office PowerPoint 2007 into a 3-D object? Here’s how:
1. With a slide open, click the Insert tab, and then select any shape from the Shapes ribbon. Alternately, select a shape you have created yourself.
2. Click the slide's surface to add the shape to the slide.
3. Right-click the shape, and then click Format Shape.
4. Select a solid or gradient fill. This step is not required but will enhance the 3-D look of your object.
5. Transform your shape into a 3-D object. You can add depth, bevel, contour, and surface type via the 3-D Format tab.
6. Give perspective to your 3-D shape. Rotate the object via the 3-D Rotation tab.
Want to convert a flat shape in Microsoft Office PowerPoint 2007 into a 3-D object? Here’s how:
1. With a slide open, click the Insert tab, and then select any shape from the Shapes ribbon. Alternately, select a shape you have created yourself.
2. Click the slide's surface to add the shape to the slide.
3. Right-click the shape, and then click Format Shape.
4. Select a solid or gradient fill. This step is not required but will enhance the 3-D look of your object.
5. Transform your shape into a 3-D object. You can add depth, bevel, contour, and surface type via the 3-D Format tab.
6. Give perspective to your 3-D shape. Rotate the object via the 3-D Rotation tab.
How to Allocate Time for Tasks in Your Outlook Calendar in MS Outlook
Allocate Time for Tasks in Your Outlook Calendar in MS Outlook
Outlook 2007 now provides a view of your current tasks in the bottom pane of your Calendar view. To allocate time in your calendar to perform these tasks, drag each task to a specific time slot on the calendar. These time slots will then appear as "busy" in your Outlook calendar.
Outlook 2007 now provides a view of your current tasks in the bottom pane of your Calendar view. To allocate time in your calendar to perform these tasks, drag each task to a specific time slot on the calendar. These time slots will then appear as "busy" in your Outlook calendar.
How to Work Offline with 2003 to 2007
2003 to 2007 Work Offline
Working offline with documents stored in Windows SharePoint Services 2.0 document libraries means saving the file locally and replacing the server version the next time you connect. In Windows SharePoint Services 3.0, you can synchronize document libraries to a Microsoft Office Outlook 2007 list by clicking the Actions button in the document library, and then clicking Connect to Outlook. After you're connected, you can open the server documents directly from your Outlook 2007 client.
To edit a document offline in the 2007 Microsoft Office system, open the file from Outlook, and then click Edit Offline. You are now ready to disconnect from the network. When you close the file, you can choose to synchronize it or keep it offline. If you want to check out the file from the document library before going offline, you need to do so from the document library itself or configure the library to require checkout for editing.
Working offline with documents stored in Windows SharePoint Services 2.0 document libraries means saving the file locally and replacing the server version the next time you connect. In Windows SharePoint Services 3.0, you can synchronize document libraries to a Microsoft Office Outlook 2007 list by clicking the Actions button in the document library, and then clicking Connect to Outlook. After you're connected, you can open the server documents directly from your Outlook 2007 client.
To edit a document offline in the 2007 Microsoft Office system, open the file from Outlook, and then click Edit Offline. You are now ready to disconnect from the network. When you close the file, you can choose to synchronize it or keep it offline. If you want to check out the file from the document library before going offline, you need to do so from the document library itself or configure the library to require checkout for editing.
How to Change Your Default Chart Type in Microsoft Excel
Change Your Default Chart Type in Microsoft Excel
To quickly create a chart on its own sheet in a Microsoft Office Excel workbook, select the chart data, and then press the F11 key. This action generates a chart using your default chart type, which is originally set to be a clustered column chart.
To change your default chart type, on the Insert tab, at the bottom-right corner of the Charts section, click the dialog box launch icon to open the Insert Chart dialog box. Select your preferred chart type, and then click Set as Default Chart. You can then click Cancel to close the dialog box without generating a chart. Though nothing appears to have changed, the next time you generate a chart by using the F11 key, you’ll automatically get your new default chart type.
Note: Keep in mind that after you’ve created a chart, you can still change the chart type. To change chart type for just the active chart, on the Chart Tools Design tab, in the Type section, click Change Chart Type.
To quickly create a chart on its own sheet in a Microsoft Office Excel workbook, select the chart data, and then press the F11 key. This action generates a chart using your default chart type, which is originally set to be a clustered column chart.
To change your default chart type, on the Insert tab, at the bottom-right corner of the Charts section, click the dialog box launch icon to open the Insert Chart dialog box. Select your preferred chart type, and then click Set as Default Chart. You can then click Cancel to close the dialog box without generating a chart. Though nothing appears to have changed, the next time you generate a chart by using the F11 key, you’ll automatically get your new default chart type.
Note: Keep in mind that after you’ve created a chart, you can still change the chart type. To change chart type for just the active chart, on the Chart Tools Design tab, in the Type section, click Change Chart Type.
How to Collaborate with Windows Meeting Space in Windows Vista
Collaborate with Windows Meeting Space in Windows Vista
Do you need to connect with a colleague to share ad hoc, real-time work? By using Windows Meeting Space, you can share handouts and work together on applications. You can join or start a meeting where everyone participates or just watches, and it can be done immediately as long as you are all on the same network.
Here’s how to get started:
1. Click Start.
2. Click All Programs.
3. Click Windows Meeting Space. Notice that passwords are required to offer a degree of security.
Do you need to connect with a colleague to share ad hoc, real-time work? By using Windows Meeting Space, you can share handouts and work together on applications. You can join or start a meeting where everyone participates or just watches, and it can be done immediately as long as you are all on the same network.
Here’s how to get started:
1. Click Start.
2. Click All Programs.
3. Click Windows Meeting Space. Notice that passwords are required to offer a degree of security.
How to Find Tooltips for Keyboard Shortcuts in MS Word
Find Tooltips for Keyboard Shortcuts in MS Word
If you press and hold the ALT key, tooltips appear above the commands at the top of the page. You can then press the appropriate letter for a simple keyboard shortcut.
If you press and hold the ALT key, tooltips appear above the commands at the top of the page. You can then press the appropriate letter for a simple keyboard shortcut.
How to Schedule Group 2003 to 2007
2003 to 2007 Group Schedule
Checking schedule availability for your team in Microsoft Office Outlook 2003 means opening a fake meeting request, entering everyone's names, and then navigating the blue bars for an open slot of time. In Microsoft Office Outlook 2007, you can create group schedules to view availability for multiple people and resources, like conference rooms.
1. Click the Actions menu, and then click View Group Schedules.
2. Click New, and then type a name for the new schedule.
3. Enter the names of the people and resources whose schedules you want to view.
4. Click Save and Close.
5. To schedule a meeting or send an e-mail message to the group or an individual, open the group schedule, and then click the Make Meeting list.
Checking schedule availability for your team in Microsoft Office Outlook 2003 means opening a fake meeting request, entering everyone's names, and then navigating the blue bars for an open slot of time. In Microsoft Office Outlook 2007, you can create group schedules to view availability for multiple people and resources, like conference rooms.
1. Click the Actions menu, and then click View Group Schedules.
2. Click New, and then type a name for the new schedule.
3. Enter the names of the people and resources whose schedules you want to view.
4. Click Save and Close.
5. To schedule a meeting or send an e-mail message to the group or an individual, open the group schedule, and then click the Make Meeting list.
How to Share Your Calendar via E-Mail in Ms Outlook
Share Your Calendar via E-Mail in Ms Outlook
If you want to share your calendar with colleagues, here’s how:
1. Open your calendar, and then click Send a Calendar via E-mail.
2. Select the period that you want to share (such as today, tomorrow, or the next 7 days).
3. You now have an e-mail message ready to send with your selective calendar details attached. Enter the e-mail addresses of those you want to receive it, and then send the message.
If you want to share your calendar with colleagues, here’s how:
1. Open your calendar, and then click Send a Calendar via E-mail.
2. Select the period that you want to share (such as today, tomorrow, or the next 7 days).
3. You now have an e-mail message ready to send with your selective calendar details attached. Enter the e-mail addresses of those you want to receive it, and then send the message.
How to Preview Formatting Before You Apply It in MS Office
Preview Formatting Before You Apply It in MS Office
Need the perfect document design, or the right formatting to ensure that your text, table, or graphic coordinates with the rest of your document? Forget time-consuming trial and error. In the 2007 Microsoft Office system programs Word, Excel, and PowerPoint, you can preview many types of document formatting before you apply them. Point to an entry in an applicable gallery, such as the Themes gallery to see font, color, and graphic effect formatting changes all at once throughout the document, or the SmartArt Styles gallery to preview a variety of formats for your SmartArt diagram.
Live Preview is available for Document Themes in Word, Excel, and PowerPoint, as well as Quick Style Sets in Word, Table Styles in all three programs, and many graphic formatting galleries (such as Picture Styles or Shape Styles). Note that Live Preview is not currently available for Chart Styles.
Need the perfect document design, or the right formatting to ensure that your text, table, or graphic coordinates with the rest of your document? Forget time-consuming trial and error. In the 2007 Microsoft Office system programs Word, Excel, and PowerPoint, you can preview many types of document formatting before you apply them. Point to an entry in an applicable gallery, such as the Themes gallery to see font, color, and graphic effect formatting changes all at once throughout the document, or the SmartArt Styles gallery to preview a variety of formats for your SmartArt diagram.
Live Preview is available for Document Themes in Word, Excel, and PowerPoint, as well as Quick Style Sets in Word, Table Styles in all three programs, and many graphic formatting galleries (such as Picture Styles or Shape Styles). Note that Live Preview is not currently available for Chart Styles.
Kamis, 28 Agustus 2008
How to Preview Formatting Before You Apply It
Preview Formatting Before You Apply It
Need the perfect document design, or the right formatting to ensure that your text, table, or graphic coordinates with the rest of your document? Forget time-consuming trial and error. In the 2007 Microsoft Office system programs Word, Excel, and PowerPoint, you can preview many types of document formatting before you apply them. Point to an entry in an applicable gallery, such as the Themes gallery to see font, color, and graphic effect formatting changes all at once throughout the document, or the SmartArt Styles gallery to preview a variety of formats for your SmartArt diagram.
Live Preview is available for Document Themes in Word, Excel, and PowerPoint, as well as Quick Style Sets in Word, Table Styles in all three programs, and many graphic formatting galleries (such as Picture Styles or Shape Styles). Note that Live Preview is not currently available for Chart Styles.
Need the perfect document design, or the right formatting to ensure that your text, table, or graphic coordinates with the rest of your document? Forget time-consuming trial and error. In the 2007 Microsoft Office system programs Word, Excel, and PowerPoint, you can preview many types of document formatting before you apply them. Point to an entry in an applicable gallery, such as the Themes gallery to see font, color, and graphic effect formatting changes all at once throughout the document, or the SmartArt Styles gallery to preview a variety of formats for your SmartArt diagram.
Live Preview is available for Document Themes in Word, Excel, and PowerPoint, as well as Quick Style Sets in Word, Table Styles in all three programs, and many graphic formatting galleries (such as Picture Styles or Shape Styles). Note that Live Preview is not currently available for Chart Styles.
How to Upload Files in Advance in Live Meeting
Upload Files in Advance in Office Live Meeting
When you’re using Microsoft Office Live Meeting to host a meeting, you can upload the documents that you want to cover in the meeting to a Microsoft SharePoint site in advance, and then tell everyone invited where those documents are. That way, anyone who can’t attend the meeting because of other commitments or network problems can still see the documents. Upload the documents as soon as they’re ready: Put them on a SharePoint workspace that everyone can access. A day (24 hours) before the meeting, send e-mail to all the invitees with a link to the files. Even those who can't attend will then have the benefit of seeing the meeting documents.
When you’re using Microsoft Office Live Meeting to host a meeting, you can upload the documents that you want to cover in the meeting to a Microsoft SharePoint site in advance, and then tell everyone invited where those documents are. That way, anyone who can’t attend the meeting because of other commitments or network problems can still see the documents. Upload the documents as soon as they’re ready: Put them on a SharePoint workspace that everyone can access. A day (24 hours) before the meeting, send e-mail to all the invitees with a link to the files. Even those who can't attend will then have the benefit of seeing the meeting documents.
How to Apply Multiple Conditional Formats to the Same Cell(s) in Ms Excel
Apply Multiple Conditional Formats to the Same Cell(s) in Ms Excel
To apply more than one conditional formatting rule to the same cells, select the cells, and then apply each new rule that you need. However, to prioritize the rules for the exact result you want, use the Conditional Formatting Rules Manager. To do this, on the Home tab, in the Styles section, click Conditional Formatting, and then click Manage Rules. In the Conditional Formatting Rules Manager dialog box, you can use the Move Up and Move Down arrows to reorder rules, which determines what formatting appears in front. You can also select the Stop If True option to stop executing further rules in cells for which the selected condition is true.
To apply more than one conditional formatting rule to the same cells, select the cells, and then apply each new rule that you need. However, to prioritize the rules for the exact result you want, use the Conditional Formatting Rules Manager. To do this, on the Home tab, in the Styles section, click Conditional Formatting, and then click Manage Rules. In the Conditional Formatting Rules Manager dialog box, you can use the Move Up and Move Down arrows to reorder rules, which determines what formatting appears in front. You can also select the Stop If True option to stop executing further rules in cells for which the selected condition is true.
Rabu, 27 Agustus 2008
How to Maximize My Screen Area by Hiding the Navigation Pane in Ms Outlook
Maximize Your Screen Area by Hiding the Navigation Pane in Ms Outlook
You can minimize the Navigation Pane by pressing the « button on the title bar in the Navigation Pane. Whenever you need to access another mail folder from the folder list, click the Navigation Pane area. The folder list will appear temporarily, and then disappear after you've chosen your folder or selected another Microsoft Office Outlook feature.
You can minimize the Navigation Pane by pressing the « button on the title bar in the Navigation Pane. Whenever you need to access another mail folder from the folder list, click the Navigation Pane area. The folder list will appear temporarily, and then disappear after you've chosen your folder or selected another Microsoft Office Outlook feature.
How to make Shortcut to a SharePoint Meeting Workspace in Office Share Point Serve
Shortcut to a SharePoint Meeting Workspace Office Share Point Serve
To quickly open an existing Microsoft SharePoint meeting workspace from your calendar view (without having to open the appointment), right-click the meeting item in your calendar, and then click View Meeting Workspace. The SharePoint Meeting Workspace associated with your selected meeting will open directly in a Web browser.
To quickly open an existing Microsoft SharePoint meeting workspace from your calendar view (without having to open the appointment), right-click the meeting item in your calendar, and then click View Meeting Workspace. The SharePoint Meeting Workspace associated with your selected meeting will open directly in a Web browser.
How to Synchronizing Your Own Computers With Office Groove 2007
Synchronizing Your Own Computers in Office Groove 2007
If you have multiple computers, you can set up your Microsoft Office Groove 2007 account on each of them to keep a synchronized copy of key workspaces and files on each computer.
1. From the File menu, click Use Account on Another Computer, and then save the account file to your desktop by clicking OK in the dialog box.
2. Transfer the account file to a second computer through an e-mail attachment or a removable storage device.
3. On the second computer, install Groove 2007. In the Account Configuration Wizard, click Use a Groove Account you have already created, and follow the instructions to select your saved account file.
4. Your workspaces will appear in the Launchbar labeled as Not on this computer. Double-click each workspace to download it from your other computer.
Note: Your Groove administrator may have set policies for your account that restrict you from adding it to other computers.
If you have multiple computers, you can set up your Microsoft Office Groove 2007 account on each of them to keep a synchronized copy of key workspaces and files on each computer.
1. From the File menu, click Use Account on Another Computer, and then save the account file to your desktop by clicking OK in the dialog box.
2. Transfer the account file to a second computer through an e-mail attachment or a removable storage device.
3. On the second computer, install Groove 2007. In the Account Configuration Wizard, click Use a Groove Account you have already created, and follow the instructions to select your saved account file.
4. Your workspaces will appear in the Launchbar labeled as Not on this computer. Double-click each workspace to download it from your other computer.
Note: Your Groove administrator may have set policies for your account that restrict you from adding it to other computers.
How to Customize the Appearance of Conditional Formats Such as Data Bars, Color Scales in MS Excel
Customize the Appearance of Conditional Formats Such as Data Bars, Color Scales, and Icon Sets in MS Excel
When you need conditional formatting in your Microsoft Office Excel 2007 worksheet, try one of the new data visualization options, including color scales, icon sets, and data bars. You can apply these formats with just a click from galleries of preset options, or customize your own conditional formatting rules.
To access the new conditional formats, on the Home tab, in the Styles section, click Conditional Formatting, and then point to Data Bars, Color Scales, or Icon Sets. Or to create a custom rule for one of these formats, at the bottom of the Conditional Formatting menu, click New Rule. In the New Formatting Rule dialog box, select the rule type Format all cells based on their values to use the new data visualization tools. In the lower half of the box, you can then choose among data bars, color scales, and icon sets; specify conditions for each formatting type; and customize colors for data bars or color scales.
Note: In Excel 2007, it’s also possible to edit existing conditional formatting rules. To access existing rules for editing, at the bottom of the Conditional Formatting menu, click Manage Rules.
When you need conditional formatting in your Microsoft Office Excel 2007 worksheet, try one of the new data visualization options, including color scales, icon sets, and data bars. You can apply these formats with just a click from galleries of preset options, or customize your own conditional formatting rules.
To access the new conditional formats, on the Home tab, in the Styles section, click Conditional Formatting, and then point to Data Bars, Color Scales, or Icon Sets. Or to create a custom rule for one of these formats, at the bottom of the Conditional Formatting menu, click New Rule. In the New Formatting Rule dialog box, select the rule type Format all cells based on their values to use the new data visualization tools. In the lower half of the box, you can then choose among data bars, color scales, and icon sets; specify conditions for each formatting type; and customize colors for data bars or color scales.
Note: In Excel 2007, it’s also possible to edit existing conditional formatting rules. To access existing rules for editing, at the bottom of the Conditional Formatting menu, click Manage Rules.
Senin, 25 Agustus 2008
How to Find how Much Storage Space Your Mail Is Occupying on the Server in MS Outlook
Find Out How Much Storage Space Your Mail Is Occupying on the Server
1. On the upper menu bar, click Tools.
2. Click Mailbox Cleanup. A dialog box appears.
3. Click View Mailbox Size. In the dialog box, you can now view the details of locally used storage.
4. On the Server Data tab you can see how much space is left on the server. The amount of space shown will be cumulative if folders contain subfolders.
1. On the upper menu bar, click Tools.
2. Click Mailbox Cleanup. A dialog box appears.
3. Click View Mailbox Size. In the dialog box, you can now view the details of locally used storage.
4. On the Server Data tab you can see how much space is left on the server. The amount of space shown will be cumulative if folders contain subfolders.
How to Use the Calculator in MS OneNote
Using the Calculator in MS OneNote
To perform calculations, you can use the OneNote calculator by entering a number anywhere on the page and using the mathematical expressions keys (*, /, +, =) on your keyboard.
To perform calculations, you can use the OneNote calculator by entering a number anywhere on the page and using the mathematical expressions keys (*, /, +, =) on your keyboard.
How to Reduce File Sizes by Changing Image Formats in MS Power Point
Reduce File Sizes by Changing Image Formats in MS Power Point
The Compress Pictures button in Microsoft Office PowerPoint can often reduce your .ppt files by up to 50 percent. But that can still leave you with large files, especially if your images have been created from .png files. You can save even more space by changing them to .gif or .jpg formats. (Note: The .png format is more flexible than the other file formats. Flattening to .jpg or .gif reduces flexibility.) Here’s how to reduce file sizes:
1. Save your PowerPoint file as Hypertext Markup Language (HTML), which creates an .htm file and a folder of the same name. This folder will contain all the images from the presentation.
2. Open the folder, and sort it by size to reveal which files are the largest.
3. Locate the largest images in your presentation. They may have been scaled, so they might look smaller than the saved image.
4. In PowerPoint, make sure that the image isn't grouped.
5. Select the image.
6. On the Picture Tools menu, in the Adjust section, click Compress Pictures.
7. Right-click the image, and then click Save as Picture.
8. From the Save as type menu, select .jpg or .gif (if you need to use transparency effects), and then save the image.
9. Delete the original image from your presentation, and reload the saved image at its original place.
10. Regroup the images if necessary.
Another way to compress the images is to use an image editing tool like Microsoft Digital Image Suite. This tool gives you more image compression options and can save you yet more space.
The Compress Pictures button in Microsoft Office PowerPoint can often reduce your .ppt files by up to 50 percent. But that can still leave you with large files, especially if your images have been created from .png files. You can save even more space by changing them to .gif or .jpg formats. (Note: The .png format is more flexible than the other file formats. Flattening to .jpg or .gif reduces flexibility.) Here’s how to reduce file sizes:
1. Save your PowerPoint file as Hypertext Markup Language (HTML), which creates an .htm file and a folder of the same name. This folder will contain all the images from the presentation.
2. Open the folder, and sort it by size to reveal which files are the largest.
3. Locate the largest images in your presentation. They may have been scaled, so they might look smaller than the saved image.
4. In PowerPoint, make sure that the image isn't grouped.
5. Select the image.
6. On the Picture Tools menu, in the Adjust section, click Compress Pictures.
7. Right-click the image, and then click Save as Picture.
8. From the Save as type menu, select .jpg or .gif (if you need to use transparency effects), and then save the image.
9. Delete the original image from your presentation, and reload the saved image at its original place.
10. Regroup the images if necessary.
Another way to compress the images is to use an image editing tool like Microsoft Digital Image Suite. This tool gives you more image compression options and can save you yet more space.
How to Apply a Sum or Other Function to Every Row in a Data Range in One Step in MS Excel
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.
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.
How to use Smarter Navigation in MS Word
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.
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.
How to Register My Regular E-Mail Contacts as Safe Senders in Outlook
Register Your Regular E-Mail Contacts as Safe Senders in MS Outlook
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.
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.
How to Preview Slide Shows in MS Power point
Preview Slide Shows in MS Powerpoint
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.
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.
Jumat, 22 Agustus 2008
How to Add Automatic Captions in MS Word
Add Automatic Captions in MS Word
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.
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.
How to Turn Your Data Range into a Table for Easy Data Management and Formatting
Turn Your Data Range into a Table for Easy Data Management and Formatting in MS Excel
The new tables functionality in Microsoft Office Excel 2007 provides options for formatting and managing your data more easily and dynamically than ever before.
To convert a data range to a table:
1. Click anywhere in the range.
2. On the Home tab, in the Styles section, click Format as Table.
3. Click to apply a table style. The Format as Table dialog box appears, where you can confirm the data range and indicate whether your range contains headers. Click OK in this dialog box to convert the range to a table and apply selected formatting.
Notice that table headers automatically contain AutoFilter arrows. Additionally, when you click into a table, the Table Tools Design tab becomes available, from which you can edit the table style, add options such as banded columns or a total row, and perform other data management tasks.
The new tables functionality in Microsoft Office Excel 2007 provides options for formatting and managing your data more easily and dynamically than ever before.
To convert a data range to a table:
1. Click anywhere in the range.
2. On the Home tab, in the Styles section, click Format as Table.
3. Click to apply a table style. The Format as Table dialog box appears, where you can confirm the data range and indicate whether your range contains headers. Click OK in this dialog box to convert the range to a table and apply selected formatting.
Notice that table headers automatically contain AutoFilter arrows. Additionally, when you click into a table, the Table Tools Design tab becomes available, from which you can edit the table style, add options such as banded columns or a total row, and perform other data management tasks.
Kamis, 21 Agustus 2008
How to Keep up to Date in Microsoft Office Outlook
How to Keep up to Date in Microsoft Office Outlook
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.
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.
How to Copy Content in Ms NoteOne
Copying Content in MS NoteOne
You can easily copy content from Web pages or any content on your screen, such as a dialog box or your desktop: Right-click the OneNote icon in the notification area, and then click Create Screen Clipping (keyboard shortcut: Windows logo key+S)
You can easily copy content from Web pages or any content on your screen, such as a dialog box or your desktop: Right-click the OneNote icon in the notification area, and then click Create Screen Clipping (keyboard shortcut: Windows logo key+S)
Rabu, 20 Agustus 2008
How to use Sorting and Filtering in MS Office Excel
Use Sorting and Filtering in MS Excel
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.
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.
How to Research Unfamiliar Words and Phrases in Office Word
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.
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.
Selasa, 19 Agustus 2008
How to Create a New Report in Microsoft Office Acess
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, a form, or a 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.
To create a report:
1. Open, or select in the navigation pane, a table, a form, or a 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.
How to Customize the Default Word Document Template in MS Word
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.
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.
Selasa, 05 Agustus 2008
Add Your Name (or) Application to right click Of My Computer
Caution ..
As it is related to Windows regisrty it can be dangerous
so,Try This at ur own risk
To write your name on right click application
please follow the steps.
1.Copy/Paste the following code in Notepad And then Save it as .reg
Windows Registry Editor Version 5.00
[HKEY_CLASSES_ROOT\CLSID\{20D04FE0-3AEA-1069-A2D8-08002B30309D}\shell\Registry Editor]
@="Your Name Or Name of the Application"
[HKEY_CLASSES_ROOT\CLSID\{20D04FE0-3AEA-1069-A2D8-08002B30309D}\shell\Registry Editor\command]
@="Location Of The Application"
2.Now edit it and then Type your name In
Eg:
[HKEY_CLASSES_ROOT\CLSID\{20D04FE0-3AEA-1069-A2D8-08002B30309D}\shell\Registry Editor]
@="Rajesh"
3. If u want to get any application, once you click Your name or name of application
Then , Type the location Of the application Which u want to open In:
[HKEY_CLASSES_ROOT\CLSID\{20D04FE0-3AEA-1069-A2D8-08002B30309D}\shell\Registry Editor\command]
@="Location Of The Application"
For eg.C:\Program Files\Yahoo!\Messenger\messenger.exe
Thats It finally save it And then Run it .
------------------------------------------------------------
To add Application Control Panel
[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{20D04FE0-3AEA-1069-A2D8-08002B30309D}\shell\Control Panel\command]
@="rundll32.exe shell32.dll,Control_RunDLL"
To add Application Add/Remove
[HKEY_CLASSES_ROOT\CLSID\{20D04FE0-3AEA-1069-A2D8-08002B30309D}\shell\Add/Remove\command]
@="control appwiz.cpl"
To add Application Reboot
[HKEY_CLASSES_ROOT\CLSID\{20D04FE0-3AEA-1069-A2D8-08002B30309D}\shell\[Reboot]\command]
@="shutdown -r -f -t 5"
To add Application Shutdown
[HKEY_CLASSES_ROOT\CLSID\{20D04FE0-3AEA-1069-A2D8-08002B30309D}\shell\[Shutdown]\command]
@="shutdown -s -f -t 5"
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-....-......----..--.-...--.-..-
As it is related to Windows regisrty it can be dangerous
so,Try This at ur own risk
To write your name on right click application
please follow the steps.
1.Copy/Paste the following code in Notepad And then Save it as .reg
Windows Registry Editor Version 5.00
[HKEY_CLASSES_ROOT\CLSID\{20D04FE0-3AEA-1069-A2D8-08002B30309D}\shell\Registry Editor]
@="Your Name Or Name of the Application"
[HKEY_CLASSES_ROOT\CLSID\{20D04FE0-3AEA-1069-A2D8-08002B30309D}\shell\Registry Editor\command]
@="Location Of The Application"
2.Now edit it and then Type your name In
Eg:
[HKEY_CLASSES_ROOT\CLSID\{20D04FE0-3AEA-1069-A2D8-08002B30309D}\shell\Registry Editor]
@="Rajesh"
3. If u want to get any application, once you click Your name or name of application
Then , Type the location Of the application Which u want to open In:
[HKEY_CLASSES_ROOT\CLSID\{20D04FE0-3AEA-1069-A2D8-08002B30309D}\shell\Registry Editor\command]
@="Location Of The Application"
For eg.C:\Program Files\Yahoo!\Messenger\messenger.exe
Thats It finally save it And then Run it .
------------------------------------------------------------
To add Application Control Panel
[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{20D04FE0-3AEA-1069-A2D8-08002B30309D}\shell\Control Panel\command]
@="rundll32.exe shell32.dll,Control_RunDLL"
To add Application Add/Remove
[HKEY_CLASSES_ROOT\CLSID\{20D04FE0-3AEA-1069-A2D8-08002B30309D}\shell\Add/Remove\command]
@="control appwiz.cpl"
To add Application Reboot
[HKEY_CLASSES_ROOT\CLSID\{20D04FE0-3AEA-1069-A2D8-08002B30309D}\shell\[Reboot]\command]
@="shutdown -r -f -t 5"
To add Application Shutdown
[HKEY_CLASSES_ROOT\CLSID\{20D04FE0-3AEA-1069-A2D8-08002B30309D}\shell\[Shutdown]\command]
@="shutdown -s -f -t 5"
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-....-......----..--.-...--.-..-
Tips to recover scratched CD's
1. Spread a cloth on a flat surface and place the CD on it.
2. Then, hold the disc with one hand, use the other to wipe the polish into the affected area with a soft cloth.
3. Wait for it to dry and buff using short, brisk strokes along the scratch, not across it.
4. A cloth sold to wipe spectacles or camera lenses will work super m8's.
5. When you can no longersee the scratch,, wash the disc with water and let it dry before playing. Intersting isnt it? Try it right now
I have used toothpaste with good effects before Ive also used car paint cutting compound on deeper scratches. It does leave lots of smaller scratches (as it is a cutting compound after all) but it will remove the worst scratches in most cases.
ya u r gng to b surely befinited by this Operation
* Fingermarks/prints cause 43% of disc problems!
* General wear & tear causes 25% of disc problems!
* Player-related issues cause 15% of disc problems!
* Remaining Others
2. Then, hold the disc with one hand, use the other to wipe the polish into the affected area with a soft cloth.
3. Wait for it to dry and buff using short, brisk strokes along the scratch, not across it.
4. A cloth sold to wipe spectacles or camera lenses will work super m8's.
5. When you can no longersee the scratch,, wash the disc with water and let it dry before playing. Intersting isnt it? Try it right now
I have used toothpaste with good effects before Ive also used car paint cutting compound on deeper scratches. It does leave lots of smaller scratches (as it is a cutting compound after all) but it will remove the worst scratches in most cases.
ya u r gng to b surely befinited by this Operation
* Fingermarks/prints cause 43% of disc problems!
* General wear & tear causes 25% of disc problems!
* Player-related issues cause 15% of disc problems!
* Remaining Others
How to Find Calendars Quickly in Your Calendar
Find Calendars Quickly in Your Calendar in MS Out Look
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
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
How to use 2003 to 2007 Out of Office Assistant
2003 to 2007 Out of Office Assistant in Microsoft Office
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.
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.
Langganan:
Postingan (Atom)