Apply a Sum or Other Function to Every Row in a Data Range in One Step MS Excel
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.
Selasa, 18 November 2008
How to use Smarter Navigation in MSWord
Smarter Navigation in MSWord
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 Reduce File Sizes by Changing Image Formats in MS PowerPoint
Reduce File Sizes by Changing Image Formats in MS PowerPoint
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.
Selasa, 11 November 2008
How to use 2003 to 2007 Out of Office Assistant
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.
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.
How to Find Calendars Quickly in Your Calendar in MS Outlook
Find Calendars Quickly in Your Calendar in MS Outlook
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 Photo Gallery in MS Vista
Photo Gallery in MS Vista
Windows Vista makes managing your media files even easier. Windows Photo Gallery is an improved way of looking at images and includes better organizational features catered to media. You can use the properties tools to add tags for additional references.
Here’s how to open Windows Photo Gallery:
1. Click Start.
2. Click All Programs.
3. Click Windows Photo Gallery.
Windows Vista makes managing your media files even easier. Windows Photo Gallery is an improved way of looking at images and includes better organizational features catered to media. You can use the properties tools to add tags for additional references.
Here’s how to open Windows Photo Gallery:
1. Click Start.
2. Click All Programs.
3. Click Windows Photo Gallery.
How to Find Related Messages in MS Outlook
Find Related Messages in MS Outlook
Searching for related messages in Microsoft Office Outlook 2007 is easy. Open an e-mail message, and in the Find section of the Ribbon, click Related, and then click Related Messages. Outlook quickly displays a list of related messages.
Searching for related messages in Microsoft Office Outlook 2007 is easy. Open an e-mail message, and in the Find section of the Ribbon, click Related, and then click Related Messages. Outlook quickly displays a list of related messages.
How to Calculate the Matrix Determinant on the Fly in MS Excel
Calculating the Matrix Determinant on the Fly in MS Excel
1. Create a square matrix in Microsoft Office Excel with values.
2. Type an equal sign (=) followed by MDETERM in an empty cell. While typing, you’ll notice that Excel automatically gives you a list of functions beginning with what you have already written. Many more functions are available in Microsoft Office Excel 2007.
3. After the opening parenthesis, select your matrix data. You'll instantly see the determinant being calculated. Excel updates this value if you change the source data.
1. Create a square matrix in Microsoft Office Excel with values.
2. Type an equal sign (=) followed by MDETERM in an empty cell. While typing, you’ll notice that Excel automatically gives you a list of functions beginning with what you have already written. Many more functions are available in Microsoft Office Excel 2007.
3. After the opening parenthesis, select your matrix data. You'll instantly see the determinant being calculated. Excel updates this value if you change the source data.
How to Setting Permissions in MS Groove
Setting Permissions in MS Groove
Each person you invite to a workspace will have one of three roles: Manager, Participant, or Guest. Each role type is granted specific permissions within the workspace and within each tool. As the Manager, you can adjust tool permissions to help protect the content and control what others can do within the workspace.
1. Right-click the Tool tab, click Properties, and then click Permissions. Then select a role from the menu.
2. Adjust the permissions by selecting or clearing the check boxes, and then click Apply.
Each person you invite to a workspace will have one of three roles: Manager, Participant, or Guest. Each role type is granted specific permissions within the workspace and within each tool. As the Manager, you can adjust tool permissions to help protect the content and control what others can do within the workspace.
1. Right-click the Tool tab, click Properties, and then click Permissions. Then select a role from the menu.
2. Adjust the permissions by selecting or clearing the check boxes, and then click Apply.
How to Derive a Strategic Value Score for Projects in MS Office Project
Derive a Strategic Value Score for Projects in MS Office Project
You can use the intuitive prioritization wizard in Portfolio Optimizer to derive a strategic value score for projects.
1. Select an organization in the Builder Scorecard, and then click the Optimizer link on the main navigation bar.
2. Click the Analyze link to open the Open Dialog page in the wizard.
3. Select a completed pairwise comparison matrix and impact matrix, and then start the wizard.
4. Click Next Step to derive the business driver priorities.
5. Click Next Step to open the project to business driver impact matrix.
6. Click Next Step to derive a strategic value score for each project.
You can use the intuitive prioritization wizard in Portfolio Optimizer to derive a strategic value score for projects.
1. Select an organization in the Builder Scorecard, and then click the Optimizer link on the main navigation bar.
2. Click the Analyze link to open the Open Dialog page in the wizard.
3. Select a completed pairwise comparison matrix and impact matrix, and then start the wizard.
4. Click Next Step to derive the business driver priorities.
5. Click Next Step to open the project to business driver impact matrix.
6. Click Next Step to derive a strategic value score for each project.
How to Convert Text to Tables in MS Excel
Convert Text to Tables in MS Excel
Sometimes you may find different types of information within the same piece of text, where the only thing separating the information is a space. Microsoft Office Excel makes it easy to redistribute this data by using different columns, and to display the data in a more digestible format.
1. Choose delimiters and column separators.
a. Select the cells containing the data that you want to separate.
b. On the Data ribbon, in the Data Tools section, click the Text to Columns button.
c. Select your preferred data type (that is, Delimited or Fixed width) from the options in the first step presented by the wizard.
d. In the second step of the wizard, select your preferred delimiters from the Delimiters options, or the column separator position from the Fixed width options.
2. Define the data format of your new columns.
a. In the dialog box of the wizard’s third step, select one column at a time and define its data format by clicking your preferred option under Column data format.
b. Click the Finish button. The text chains will now be distributed into columns according to your chosen data format.
Sometimes you may find different types of information within the same piece of text, where the only thing separating the information is a space. Microsoft Office Excel makes it easy to redistribute this data by using different columns, and to display the data in a more digestible format.
1. Choose delimiters and column separators.
a. Select the cells containing the data that you want to separate.
b. On the Data ribbon, in the Data Tools section, click the Text to Columns button.
c. Select your preferred data type (that is, Delimited or Fixed width) from the options in the first step presented by the wizard.
d. In the second step of the wizard, select your preferred delimiters from the Delimiters options, or the column separator position from the Fixed width options.
2. Define the data format of your new columns.
a. In the dialog box of the wizard’s third step, select one column at a time and define its data format by clicking your preferred option under Column data format.
b. Click the Finish button. The text chains will now be distributed into columns according to your chosen data format.
How to Quickly Know How Many Lines or Words You Have Typed in MS Word
Quickly Know How Many Lines or Words You Have Typed in MS Word
Right-click the status bar, and then select a parameter. Microsoft Office Word can show you, for example, line details or the number of words typed. This information is useful when you are writing a document that must have a fixed length.
Right-click the status bar, and then select a parameter. Microsoft Office Word can show you, for example, line details or the number of words typed. This information is useful when you are writing a document that must have a fixed length.
How to Turn Off E-Mail Notifications in MS Outlook
Turn Off E-Mail Notifications in MS Outlook
Because an e-mail notification icon appears whenever you receive new e-mail, it's tempting to stop work and open new messages immediately. But you can turn off the notification and then check your e-mail when it's convenient for you. Here’s how:
1. In Microsoft Office Outlook 2007, click Tools, click Options, click E-mail Options, and then click Advanced E-mail Options.
2. In the middle of the dialog box, clear the Display a New Mail Desktop Alert check box.
Because an e-mail notification icon appears whenever you receive new e-mail, it's tempting to stop work and open new messages immediately. But you can turn off the notification and then check your e-mail when it's convenient for you. Here’s how:
1. In Microsoft Office Outlook 2007, click Tools, click Options, click E-mail Options, and then click Advanced E-mail Options.
2. In the middle of the dialog box, clear the Display a New Mail Desktop Alert check box.
How to Change File Properties in MS Vista
Changing File Properties in MS Vista
File properties or metadata can be very useful in labeling, organizing, and subsequently finding your files. Most programs add their own properties when saved; however, with Windows Vista, you can augment these attributes.
1. Click Organize, click Layout, and then click Details Pane (if necessary; you should see the details pane by default at the bottom of the Explorer).
2. Expand the details pane (click and drag the separator above the pane to resize).
3. Select the attribute that you want to change, and enter any information that you want to add.
File properties or metadata can be very useful in labeling, organizing, and subsequently finding your files. Most programs add their own properties when saved; however, with Windows Vista, you can augment these attributes.
1. Click Organize, click Layout, and then click Details Pane (if necessary; you should see the details pane by default at the bottom of the Explorer).
2. Expand the details pane (click and drag the separator above the pane to resize).
3. Select the attribute that you want to change, and enter any information that you want to add.
How to Enter the PowerPoint Slide Show Mode Beginning at Any Point You Want
Enter the PowerPoint Slide Show Mode Beginning at Any Point You Want
Pressing F5 in Microsoft Office PowerPoint starts the slide show, but by default, it will open with the first slide in the deck. To start your slide show with the current or selected slide, press SHIFT+F5 instead.
Pressing F5 in Microsoft Office PowerPoint starts the slide show, but by default, it will open with the first slide in the deck. To start your slide show with the current or selected slide, press SHIFT+F5 instead.
How to use 2003 to 2007 Quick Parts
2003 to 2007 Quick Parts
In Microsoft Office Word 2003, you can use AutoText to automate the typing of oft-repeated text like names and addresses. But what if you want to reuse more than text?
You can use Quick Parts in Microsoft Office Word 2007 to save any document content—text, pictures, Microsoft SmartArt graphics, headers and footers, and more—to an easily accessed Quick Part Gallery.
1. Click the Insert tab, and then select the document content that you want to reuse.
2. Click the Quick Parts button in the Text section, and then click Save Selection to Quick Part Gallery.
3. Enter a name and description, and then click OK.
4. To reuse the content, click the Quick Parts button, and then select the Quick Part that you want to use.
In Microsoft Office Word 2003, you can use AutoText to automate the typing of oft-repeated text like names and addresses. But what if you want to reuse more than text?
You can use Quick Parts in Microsoft Office Word 2007 to save any document content—text, pictures, Microsoft SmartArt graphics, headers and footers, and more—to an easily accessed Quick Part Gallery.
1. Click the Insert tab, and then select the document content that you want to reuse.
2. Click the Quick Parts button in the Text section, and then click Save Selection to Quick Part Gallery.
3. Enter a name and description, and then click OK.
4. To reuse the content, click the Quick Parts button, and then select the Quick Part that you want to use.
How to ms woPreview Type and Color Formatting in MS Word
Preview Type and Color Formatting in MS Word
You can see how formatting will look in Live Preview before applying it to the Microsoft Office Word document you're working on. Select a formatting option (for example, click Page Layout, click Page Color, and then point to a color), and Live Preview will temporarily apply it. To keep the result, just click the color, or keep browsing for alternatives.
You can see how formatting will look in Live Preview before applying it to the Microsoft Office Word document you're working on. Select a formatting option (for example, click Page Layout, click Page Color, and then point to a color), and Live Preview will temporarily apply it. To keep the result, just click the color, or keep browsing for alternatives.
How to Search All Folders in a Mailbox in MS Outlook
Search All Folders in a Mailbox in MS Outlook
You can set Microsoft Office Outlook to automatically search across all your folders at once. Here’s how:
In Outlook, click Tools, click Options, and then click Search Options on the Preferences tab. In the Search Options dialog box, if you click All folders, you can search all folders instead of just the selected one.
You can set Microsoft Office Outlook to automatically search across all your folders at once. Here’s how:
In Outlook, click Tools, click Options, and then click Search Options on the Preferences tab. In the Search Options dialog box, if you click All folders, you can search all folders instead of just the selected one.
How to use Multiple Level Undo, Change Highlighting, and Task Drivers in MS Office Project
Multiple Level Undo, Change Highlighting, and Task Drivers in MS Office Project
In Microsoft Office Project Professional, project managers can visualize the effects of changes and trace back their steps. To turn the Change Highlighting feature on or off, click the View menu, and then click Hide Change Highlighting or Show Change Highlighting. While the feature is enabled, all levels of tasks affected as a result of a change are highlighted with a color as a visual indicator. By using this feature together with the Multiple Level Undo feature, project managers can do what-if analyses by trying a set of changes and then reversing unwanted changes.
If further analysis of a task’s schedule is needed, the project manager can use Task Drivers on the Project menu to determine the factors—such as task dependency, calendar constraints, schedule date, or vacation time—that are driving a task’s start date.
In Microsoft Office Project Professional, project managers can visualize the effects of changes and trace back their steps. To turn the Change Highlighting feature on or off, click the View menu, and then click Hide Change Highlighting or Show Change Highlighting. While the feature is enabled, all levels of tasks affected as a result of a change are highlighted with a color as a visual indicator. By using this feature together with the Multiple Level Undo feature, project managers can do what-if analyses by trying a set of changes and then reversing unwanted changes.
If further analysis of a task’s schedule is needed, the project manager can use Task Drivers on the Project menu to determine the factors—such as task dependency, calendar constraints, schedule date, or vacation time—that are driving a task’s start date.
Use Conditional Formatting to Highlight Data Trends in MS Excel
Use Conditional Formatting to Highlight Data Trends in MS Excel
Conditional formatting can help you highlight trends in your data. First, either open a fully populated Microsoft Office Excel file, or start with an empty document and fill its cells with some values. To apply conditional formatting:
1. Click the Conditional Formatting button on the Home tab of the Ribbon.
2. On the menu that appears, try selecting Data Bars, Icon Sets, or Color Scales and pause over the options. Your data is partitioned according to the rules you set, and it instantly displays visual cues that will aid understanding of the data.
3. If you don't like the options available, you can create your own rules, use your own colors, and establish your own thresholds. Better still, you can reuse your rules each time for consistent and clear presentation. All of these options are available on the Conditional Formatting menu.
Conditional formatting can help you highlight trends in your data. First, either open a fully populated Microsoft Office Excel file, or start with an empty document and fill its cells with some values. To apply conditional formatting:
1. Click the Conditional Formatting button on the Home tab of the Ribbon.
2. On the menu that appears, try selecting Data Bars, Icon Sets, or Color Scales and pause over the options. Your data is partitioned according to the rules you set, and it instantly displays visual cues that will aid understanding of the data.
3. If you don't like the options available, you can create your own rules, use your own colors, and establish your own thresholds. Better still, you can reuse your rules each time for consistent and clear presentation. All of these options are available on the Conditional Formatting menu.
How to Insert Pictures in MS One Note
Insert Pictures in MS One Note
To insert a picture in your notes, click Insert, click Pictures, and then click either From Files or From Scanner or Camera.
To insert a picture in your notes, click Insert, click Pictures, and then click either From Files or From Scanner or Camera.
How to use Quickly Switching to Inbox or Outbox
Quickly Switching to Inbox or Outbox in MS Outlook
To jump to your Inbox, press CTRL+SHIFT+I. To jump to your Outbox, press CTRL+SHIFT+O
To jump to your Inbox, press CTRL+SHIFT+I. To jump to your Outbox, press CTRL+SHIFT+O
How to Generate an Efficient Frontier in Office Project
Generating an Efficient Frontier
You can assess your selected project portfolio against the Efficient Frontier. (Note: These steps assume you have already run an optimization scenario.) Here’s how:
1. Right-click an optimization scenario, and then click Insight Analysis from the Advanced Analysis commands.
2. Wait while the Efficient Frontier is generated.
3. Analyze the constraints (in the right panel) that are prohibiting the portfolio from reaching the Efficient Frontier.
You can assess your selected project portfolio against the Efficient Frontier. (Note: These steps assume you have already run an optimization scenario.) Here’s how:
1. Right-click an optimization scenario, and then click Insight Analysis from the Advanced Analysis commands.
2. Wait while the Efficient Frontier is generated.
3. Analyze the constraints (in the right panel) that are prohibiting the portfolio from reaching the Efficient Frontier.
How to Publish Your Slides to a Slide Library in PowerPoint
How to Publish Your Slides to a Slide Library in PowerPoint
Microsoft SharePoint slide libraries help you to easily share, repurpose, and reuse Microsoft Office PowerPoint slides, reducing the number of times you need to re-create slides. This feature requires the use of a Windows SharePoint Services team workspace.
After saving your presentation, you can publish your slides to a slide library by using the following steps:
1. Click the Office button. On the Publish menu, click Publish Slides.
2. Select the check box next to each slide that you want to publish to your slide library.
3. Type the Web address of your team site in the Publish To text box.
4. Click Publish.
Microsoft SharePoint slide libraries help you to easily share, repurpose, and reuse Microsoft Office PowerPoint slides, reducing the number of times you need to re-create slides. This feature requires the use of a Windows SharePoint Services team workspace.
After saving your presentation, you can publish your slides to a slide library by using the following steps:
1. Click the Office button. On the Publish menu, click Publish Slides.
2. Select the check box next to each slide that you want to publish to your slide library.
3. Type the Web address of your team site in the Publish To text box.
4. Click Publish.
How to Vista Explorer Quick Search
Vista Explorer Quick Search
Folders and most interaction points with Windows Vista are consistent. These windows or Explorers all have similar traits, including a Quick Search box in the upper-right corner. To find a file in this folder:
1. Type the criteria in the Quick Search box.
2. Click the spyglass to search.
Folders and most interaction points with Windows Vista are consistent. These windows or Explorers all have similar traits, including a Quick Search box in the upper-right corner. To find a file in this folder:
1. Type the criteria in the Quick Search box.
2. Click the spyglass to search.
How to Wrap Text in Excel 2007
How to Wrap Text in Excel 2007
In Microsoft Office Excel 2007, if the text you type is too long to be displayed fully in a cell, you can easily set the text to wrap. This setting enables the cell (and the rest of the row) to expand automatically so that the content of the cell is always visible.
1. Click in the cell that you want to wrap.
2. On the Home tab, in the Alignment section, click Wrap Text.
In Microsoft Office Excel 2007, if the text you type is too long to be displayed fully in a cell, you can easily set the text to wrap. This setting enables the cell (and the rest of the row) to expand automatically so that the content of the cell is always visible.
1. Click in the cell that you want to wrap.
2. On the Home tab, in the Alignment section, click Wrap Text.
How to Count Words in MS Word
How to Count Words in MS Word
You can find the number of words in your Microsoft Office Word document by selecting only the text that you want to count. Look at the status bar displayed on the bottom of the screen. It shows you the number of words in the selected text first, and then the count for the entire document.
You can find the number of words in your Microsoft Office Word document by selecting only the text that you want to count. Look at the status bar displayed on the bottom of the screen. It shows you the number of words in the selected text first, and then the count for the entire document.
Rabu, 05 November 2008
How to Set Aside Time to Work on Tasks Contained in E-Mail in Outlook
Set Aside Time to Work on Tasks Contained in E-Mail in Outlook
You can book a slot on your calendar to complete a specific e-mail task. Go to your Inbox, click an e-mail message, and then drag it to your chosen day on the To-Do Bar calendar. This immediately creates a reminder to handle the task on that day. It's then up to you to choose the scheduled time, but drag-and-drop task scheduling makes time management easy.
You can book a slot on your calendar to complete a specific e-mail task. Go to your Inbox, click an e-mail message, and then drag it to your chosen day on the To-Do Bar calendar. This immediately creates a reminder to handle the task on that day. It's then up to you to choose the scheduled time, but drag-and-drop task scheduling makes time management easy.
How to Select a Slide Layout in MS Power Point
Select a Slide Layout in MS Power Point
Whenever you insert a new slide, you can select from a variety of slide layouts. Slide layouts are designed to make it easy for you to precisely place text, graphics, diagrams, and other items on your slides.
1. On either the Home tab or the Insert tab, click the Add Slide icon. (Note: You will need to click the lower half of the icon to choose the type of slide that you want to insert.)
2. Select a layout option from the Add Slide gallery.
3. On your new slide, click a placeholder to add text or slide content.
Microsoft Office PowerPoint 2007 also makes it easy to create and use your own custom slide layouts. If you need unique layouts that aren't part of the standard slide layouts in the Add Slide gallery, search for "Add a Layout" by using Office Help (press the F1 key to get to Office Help at any time).
Whenever you insert a new slide, you can select from a variety of slide layouts. Slide layouts are designed to make it easy for you to precisely place text, graphics, diagrams, and other items on your slides.
1. On either the Home tab or the Insert tab, click the Add Slide icon. (Note: You will need to click the lower half of the icon to choose the type of slide that you want to insert.)
2. Select a layout option from the Add Slide gallery.
3. On your new slide, click a placeholder to add text or slide content.
Microsoft Office PowerPoint 2007 also makes it easy to create and use your own custom slide layouts. If you need unique layouts that aren't part of the standard slide layouts in the Add Slide gallery, search for "Add a Layout" by using Office Help (press the F1 key to get to Office Help at any time).
Sabtu, 25 Oktober 2008
How to use SmartArt Diagram in 2003 to 2007
2003 to 2007 SmartArt Diagram
To make your Microsoft Office PowerPoint 2003 presentation more compelling, you might insert a diagram. Unfortunately, clicking the Insert menu and then clicking Diagram presents only six available commands, and all of your supporting text must be entered in individual text boxes.
With Microsoft SmartArt in the 2007 Microsoft Office system, you can right-click an existing bulleted list in Microsoft Office PowerPoint 2007 or Microsoft Office Word 2007, and then click Convert to SmartArt. Then select from the 20 default options, or click More SmartArt Graphics and browse through a large gallery of available diagrams.
You can use the SmartArt Tools contextual command tabs to change the diagram type or apply interesting effects like three dimensions or color options. To edit SmartArt text, click the diagram, and then edit your text in its familiar list format in a box that appears to the side of the diagram. Watch your diagram dynamically change to match the new text.
To make your Microsoft Office PowerPoint 2003 presentation more compelling, you might insert a diagram. Unfortunately, clicking the Insert menu and then clicking Diagram presents only six available commands, and all of your supporting text must be entered in individual text boxes.
With Microsoft SmartArt in the 2007 Microsoft Office system, you can right-click an existing bulleted list in Microsoft Office PowerPoint 2007 or Microsoft Office Word 2007, and then click Convert to SmartArt. Then select from the 20 default options, or click More SmartArt Graphics and browse through a large gallery of available diagrams.
You can use the SmartArt Tools contextual command tabs to change the diagram type or apply interesting effects like three dimensions or color options. To edit SmartArt text, click the diagram, and then edit your text in its familiar list format in a box that appears to the side of the diagram. Watch your diagram dynamically change to match the new text.
How to Add and Editing Comments in MS Excel
Adding and Editing Comments in MS Office Excel
You can add and edit comments in Microsoft Office Excel by using the keyboard. To add a comment:
1. Press SHIFT+F2 to insert a comment in the current cell.
2. Type the text of your comment, and then press ESC twice.
To edit a comment:
1. Go to the cell that contains the comment and press SHIFT+F2. The comment opens.
2. Make your changes, and then press ESC twice.
You can add and edit comments in Microsoft Office Excel by using the keyboard. To add a comment:
1. Press SHIFT+F2 to insert a comment in the current cell.
2. Type the text of your comment, and then press ESC twice.
To edit a comment:
1. Go to the cell that contains the comment and press SHIFT+F2. The comment opens.
2. Make your changes, and then press ESC twice.
Kamis, 16 Oktober 2008
How to use Color-Code in an Individual Sender's E-Mail Messages in MS Outlook
Color-Code an Individual Sender's E-Mail Messages in MS Outlook
You can color-code your incoming e-mail to spot quickly what's important.
1. Click an e-mail message, and then click Tools.
2. Click Organize.
3. Click Using Colors, and then select your color of choice. All future e-mail from that sender will appear in that color.
You can color-code your incoming e-mail to spot quickly what's important.
1. Click an e-mail message, and then click Tools.
2. Click Organize.
3. Click Using Colors, and then select your color of choice. All future e-mail from that sender will appear in that color.
How to Arrange Your Meetings in One All-Day Session in Office Live Meeting
Arrange Your Meetings in One All-Day Session in Office Live Meeting
Using Microsoft Office Live Meeting to organize several meetings all on the same day, or perhaps over two days, can create a confusing list of different meeting URLs and invitations. So long as the displays used for each meeting aren't confidential, you can create a single meeting to cover the entire day and invite the attendees for each meeting by using the same URL. As the host for each meeting, you can stay signed in to the same meeting for the entire day, while participants need to sign in only for their own meetings. That way, you'll avoid having to send different invitations and different URLs to each attendee. It also means you'll no longer need to continually sign out of one meeting and sign in to another.
Using Microsoft Office Live Meeting to organize several meetings all on the same day, or perhaps over two days, can create a confusing list of different meeting URLs and invitations. So long as the displays used for each meeting aren't confidential, you can create a single meeting to cover the entire day and invite the attendees for each meeting by using the same URL. As the host for each meeting, you can stay signed in to the same meeting for the entire day, while participants need to sign in only for their own meetings. That way, you'll avoid having to send different invitations and different URLs to each attendee. It also means you'll no longer need to continually sign out of one meeting and sign in to another.
Jumat, 10 Oktober 2008
How to Delete E-Mail Messages Permanently in MS Outlook
Deleting E-Mail Messages Permanently in MS Outlook
To delete e-mail messages from Microsoft Office Outlook:
1. Select the e-mail messages that you want to delete. You can select messages that appear in your mailbox consecutively by holding down the SHIFT key while clicking the first and last messages that you want to delete from the list. Alternately, hold down the CTRL key while you click the individual e-mail messages that you want to delete.
2. Hold down the SHIFT key and press DELETE to permanently delete your selected e-mail messages.
3. To complete the deletion, you must confirm it in the dialog box that appears when you close Outlook. But be careful, because permanently deleted e-mail messages are eliminated immediately, not stored in the Deleted Items folder. In other words, they cannot be recovered if you find you've made a mistake.
To delete e-mail messages from Microsoft Office Outlook:
1. Select the e-mail messages that you want to delete. You can select messages that appear in your mailbox consecutively by holding down the SHIFT key while clicking the first and last messages that you want to delete from the list. Alternately, hold down the CTRL key while you click the individual e-mail messages that you want to delete.
2. Hold down the SHIFT key and press DELETE to permanently delete your selected e-mail messages.
3. To complete the deletion, you must confirm it in the dialog box that appears when you close Outlook. But be careful, because permanently deleted e-mail messages are eliminated immediately, not stored in the Deleted Items folder. In other words, they cannot be recovered if you find you've made a mistake.
How to Insert Predefined Fields in MS Office Access
Inserting Predefined Fields in MS Office Access
To insert a predefined field:
1. In datasheet view, on the Ribbon, in the Fields and Columns section, click New Field.
2. In the Field Templates pane, select the field you want, and then drag it to your table.
To insert a predefined field:
1. In datasheet view, on the Ribbon, in the Fields and Columns section, click New Field.
2. In the Field Templates pane, select the field you want, and then drag it to your table.
How to Create Pages, Sections, and Notebooks in MS Office OneNote
Create Pages, Sections, and Notebooks in MS Office OneNote
To create a new notebook:
1. On the File menu, click New. This opens the task pane from which you can create a new page, section, or notebook.
2. On the File menu, click Print.
3. Select Send to Microsoft OneNote in the list of available printers.
4. Click Print.
5. Drag the resulting Microsoft Office OneNote page to the relevant section of your notebook.
To create a new notebook:
1. On the File menu, click New. This opens the task pane from which you can create a new page, section, or notebook.
2. On the File menu, click Print.
3. Select Send to Microsoft OneNote in the list of available printers.
4. Click Print.
5. Drag the resulting Microsoft Office OneNote page to the relevant section of your notebook.
Jumat, 03 Oktober 2008
How to Select Excel Ranges by Using the Name Box
Selecting Excel Ranges by Using the Name Box
In Microsoft Office Excel, you can select a range of cells by typing it in the Name box. This is particularly useful if the range is large and will therefore take time and a lot of scrolling to select by hand
In Microsoft Office Excel, you can select a range of cells by typing it in the Name box. This is particularly useful if the range is large and will therefore take time and a lot of scrolling to select by hand
How to Save a Search in Microsoft Vista
Saving a Search in Microsoft Vista
Whenever you perform a search in a Windows Vista folder, you can save it for reuse. Saving searches can speed up your efforts to find important information, especially as you save more and more files. Here’s how:
Click Save Search. The search file is saved in a separate folder under your user folder, titled Saved Searches.
Whenever you perform a search in a Windows Vista folder, you can save it for reuse. Saving searches can speed up your efforts to find important information, especially as you save more and more files. Here’s how:
Click Save Search. The search file is saved in a separate folder under your user folder, titled Saved Searches.
Kamis, 02 Oktober 2008
How to Use a Voice Command in MS Word
Use a Voice Command in MS Word
You can use sound in Microsoft Office Word.
1. In the Word document, place your cursor where you want your voice message to go.
2. Click Insert, and then in the Text section, click the Insert Object button.
3. In the Object dialog box, on the Create New tab, in the list of object types, select Wave Sound.
4. Click OK, and then record your own voice note
You can use sound in Microsoft Office Word.
1. In the Word document, place your cursor where you want your voice message to go.
2. Click Insert, and then in the Text section, click the Insert Object button.
3. In the Object dialog box, on the Create New tab, in the list of object types, select Wave Sound.
4. Click OK, and then record your own voice note
How to Use the Floating Toolbar for Formatting in Microsoft Office
Use the Floating Toolbar for Formatting in Microsoft Office
You can use a floating toolbar to quickly change document formatting in Microsoft Office. When you use the mouse to select text that you want to change, a floating toolbar appears automatically, giving you easy access to basic formatting commands.
You can use a floating toolbar to quickly change document formatting in Microsoft Office. When you use the mouse to select text that you want to change, a floating toolbar appears automatically, giving you easy access to basic formatting commands.
How to Use Your Outlook Calendar to Schedule Work More Effectively
Using Your Outlook Calendar to Schedule Work More Effectively
You can allocate time slots for work activities as if they were meetings. For example, after each contact with a customer, you can schedule any resulting tasks in your Microsoft Office Outlook calendar as if they were meetings. That way you'll be less likely to forget anything, and you can allocate sufficient time to complete your follow-ups more efficiently.
You can allocate time slots for work activities as if they were meetings. For example, after each contact with a customer, you can schedule any resulting tasks in your Microsoft Office Outlook calendar as if they were meetings. That way you'll be less likely to forget anything, and you can allocate sufficient time to complete your follow-ups more efficiently.
How to do Task Updates and Timesheet Submittal and Approval in MS Office Project
Task Updates and Timesheet Submittal and Approval in MS Office Project
Team members update project work in the Tasks, My Work section of Microsoft Office Project Web Access. After they submit their task updates, the project manager approves or rejects their time on tasks in the Approvals, Task Updates section of Project Web Access.
At the end of each timesheet period, team members use Import Task Progress to show progress on their timesheets along with any other administrative time spent during the period. Resource managers can review, approve, and reconcile timesheets against reported project work, non-project work, and non-working time.
Use the following steps to review and approve timesheets:
1. In Project Web Access, click the Action pane.
2. In the Approvals section, click Timesheet.
3. In Review My Timesheet Summary, click My Timesheet.
4. Click the Review Timesheet Detail page.
5. Click Approve to complete the approval process.
6. In the Approvals section, click Admin Time.
7. Click the Review Admin Time Detail page.
8. Click Approve to complete the approval process.
Team members update project work in the Tasks, My Work section of Microsoft Office Project Web Access. After they submit their task updates, the project manager approves or rejects their time on tasks in the Approvals, Task Updates section of Project Web Access.
At the end of each timesheet period, team members use Import Task Progress to show progress on their timesheets along with any other administrative time spent during the period. Resource managers can review, approve, and reconcile timesheets against reported project work, non-project work, and non-working time.
Use the following steps to review and approve timesheets:
1. In Project Web Access, click the Action pane.
2. In the Approvals section, click Timesheet.
3. In Review My Timesheet Summary, click My Timesheet.
4. Click the Review Timesheet Detail page.
5. Click Approve to complete the approval process.
6. In the Approvals section, click Admin Time.
7. Click the Review Admin Time Detail page.
8. Click Approve to complete the approval process.
Selasa, 30 September 2008
How to Initiate a Chat Session from Within Groove by Using Office Communicator
Initiate a Chat Session from Within Groove by Using Office Communicator
When you are running Microsoft Office Groove 2007 and Microsoft Office Communicator 2007 or 2005, you can view the awareness states (such as online, busy, or away) of your Communicator contacts directly from the Groove Launchbar or a Groove workspace. When a contact is available, you can right-click to initiate a Communicator real-time chat or phone call with that contact directly from the Groove interface.
When you are running Microsoft Office Groove 2007 and Microsoft Office Communicator 2007 or 2005, you can view the awareness states (such as online, busy, or away) of your Communicator contacts directly from the Groove Launchbar or a Groove workspace. When a contact is available, you can right-click to initiate a Communicator real-time chat or phone call with that contact directly from the Groove interface.
How to Set the Print Area in Microsoft Office Excel
Setting the Print Area in Microsoft Office Excel
Have you ever wanted to print only certain rows or columns from a spreadsheet? Here’s how:
1. With a spreadsheet open, select all the rows or columns that you want to print.
2. On the Page Layout tab, in the Page Setup section, click Print Area, and then click Set Print Area.
3. Click the Print icon on the toolbar, or click the Office button, point to Print, and click Print. Only the required content gets printed.
Have you ever wanted to print only certain rows or columns from a spreadsheet? Here’s how:
1. With a spreadsheet open, select all the rows or columns that you want to print.
2. On the Page Layout tab, in the Page Setup section, click Print Area, and then click Set Print Area.
3. Click the Print icon on the toolbar, or click the Office button, point to Print, and click Print. Only the required content gets printed.
How to Use the Status Bar to Show Range Data in MS Excel
Use the Status Bar to Show Range Data in MS Excel
In Microsoft Office Excel 2007, when you select a range of numbers, three data counts (Average, Count, and Sum) appear automatically on the status bar. By right-clicking the status bar, you can customize the parameters that the bar displays. There are plenty of parameters to choose from, including minimums and maximums
In Microsoft Office Excel 2007, when you select a range of numbers, three data counts (Average, Count, and Sum) appear automatically on the status bar. By right-clicking the status bar, you can customize the parameters that the bar displays. There are plenty of parameters to choose from, including minimums and maximums
How to Take Notes in MS OneNote
Take Notes in MS OneNote
Getting started in Microsoft Office OneNote is easy—just click a page and start typing. Unlike in Microsoft Office Word, you can click anywhere on a page to create a new note "container." You can easily reorganize this container by clicking the outline of the note and dragging it elsewhere on the page, or merging it with other containers of notes.
Getting started in Microsoft Office OneNote is easy—just click a page and start typing. Unlike in Microsoft Office Word, you can click anywhere on a page to create a new note "container." You can easily reorganize this container by clicking the outline of the note and dragging it elsewhere on the page, or merging it with other containers of notes.
How to Set Up the Calendar Quickly in MS Outlook
Set Up the Calendar Quickly in MS Outlook
You can customize your Microsoft Office Outlook calendar quickly. When viewing the calendar, press ALT and the number of days that you want to show (for example, ALT+3). Outlook will redraw the calendar to show the selected number of days.
You can customize your Microsoft Office Outlook calendar quickly. When viewing the calendar, press ALT and the number of days that you want to show (for example, ALT+3). Outlook will redraw the calendar to show the selected number of days.
How to Let Your Audience Drill Down to Excel Data in MS Office VIsio
Let Your Audience Drill Down to Excel Data in MS Office VIsio
1. Select the Microsoft Office Excel table that you want to import to your Microsoft Office Visio diagram. On the Ribbon, under Export, click Create Diagram.
2. In the Add Total area of the PivotDiagram panel, select the number of columns that you want to include in your Visio diagram.
3. Select the diagram in your Visio presentation for which you want to create a drill-down facility, and then select the category for your drill-down levels.
4. Add shapes to the categories.
a. Select your diagram, and then click the Apply Shape button in the PivotDiagram panel.
b. Select the shape you require, and then click OK.
5. Filter the data by clicking Configure Column on the Category menu, and then clicking the arrow next to the category name.
1. Select the Microsoft Office Excel table that you want to import to your Microsoft Office Visio diagram. On the Ribbon, under Export, click Create Diagram.
2. In the Add Total area of the PivotDiagram panel, select the number of columns that you want to include in your Visio diagram.
3. Select the diagram in your Visio presentation for which you want to create a drill-down facility, and then select the category for your drill-down levels.
4. Add shapes to the categories.
a. Select your diagram, and then click the Apply Shape button in the PivotDiagram panel.
b. Select the shape you require, and then click OK.
5. Filter the data by clicking Configure Column on the Category menu, and then clicking the arrow next to the category name.
How to Modifying Data Types in MS Access
Modifying Data Types in MS Access
To view or change the data type:
1. Click a cell.
2. In the Datasheet contextual tab, the Data Type and Formatting section displays the data type.
3. To change the data type, in the Data Type box, click the arrow, and then select the type you want. (Note: You may need to retype the value in your cell or cells if the type is not compatible.)
4. In the Format box, click the arrow to format how the data is displayed.
5. Select Is Required if you need to make this field mandatory. To make table and field definitions easier, Microsoft Office Access has a set of predefined templates.
To view or change the data type:
1. Click a cell.
2. In the Datasheet contextual tab, the Data Type and Formatting section displays the data type.
3. To change the data type, in the Data Type box, click the arrow, and then select the type you want. (Note: You may need to retype the value in your cell or cells if the type is not compatible.)
4. In the Format box, click the arrow to format how the data is displayed.
5. Select Is Required if you need to make this field mandatory. To make table and field definitions easier, Microsoft Office Access has a set of predefined templates.
How to open or read a .daa file extension
.daa is a file extension that is created by PowerISO Software. TO open these files you must download this software and install it on your PC. Get more information here about this extension or visit the site here .
This Supports
1. UIF file.
2. Windows Vista.
3. On-the-fly burning.
4. Apple DMG file.
5. Multiple languages.
6. Command-line parameters.
This Supports
1. UIF file.
2. Windows Vista.
3. On-the-fly burning.
4. Apple DMG file.
5. Multiple languages.
6. Command-line parameters.
Senin, 29 September 2008
How to use Structured References in 2003 to 2007
2003 to 2007 Structured References
Working with formulas and functions has not always been the most intuitive process. In Microsoft Office Excel 2003, multiplying gross revenue by the profit margin might mean typing something like =B7*E14. In Microsoft Office Excel 2007, structured referencing enables you to use the column headers in table data to build your formulas. Instead of cryptic cell locations, you can simply multiply =[Gross Revenue]*[Margin].
To use structured referencing, you first need to format your data as a table.
1. Click Format as Table in the Styles section of the Home tab.
2. Select the My table has headers check box.
3. After you have a table, click the cell where you want to insert the formula, and then type the left bracket ([).
4. Select the column that you want to use from the list that appears, press the TAB key, and then close it with the right bracket (]).
5. Repeat as you build out your formula.
Working with formulas and functions has not always been the most intuitive process. In Microsoft Office Excel 2003, multiplying gross revenue by the profit margin might mean typing something like =B7*E14. In Microsoft Office Excel 2007, structured referencing enables you to use the column headers in table data to build your formulas. Instead of cryptic cell locations, you can simply multiply =[Gross Revenue]*[Margin].
To use structured referencing, you first need to format your data as a table.
1. Click Format as Table in the Styles section of the Home tab.
2. Select the My table has headers check box.
3. After you have a table, click the cell where you want to insert the formula, and then type the left bracket ([).
4. Select the column that you want to use from the list that appears, press the TAB key, and then close it with the right bracket (]).
5. Repeat as you build out your formula.
How to Create or Populate Lists on a SharePoint List
Quick Ways to Create or Populate Lists on a SharePoint List
1. Start Microsoft Office Access and open a database by clicking the New Database icon or selecting an existing database.
2. Create a new list.
a. Click Create, click SharePoint lists, and then select whichever list is appropriate.
b. Enter the site address of the Microsoft SharePoint site that you want to use, and then give the list a name.
3. Fill in the data on the data entry page, or populate it from another source by using the data import features of Access.
4. Save the content in Access.
5. Go to your SharePoint site, click Lists, select the list you just created, and it will already have been published.
1. Start Microsoft Office Access and open a database by clicking the New Database icon or selecting an existing database.
2. Create a new list.
a. Click Create, click SharePoint lists, and then select whichever list is appropriate.
b. Enter the site address of the Microsoft SharePoint site that you want to use, and then give the list a name.
3. Fill in the data on the data entry page, or populate it from another source by using the data import features of Access.
4. Save the content in Access.
5. Go to your SharePoint site, click Lists, select the list you just created, and it will already have been published.
How to Add Professional Charts in MS Power Point
Add Professional Charts in MS Power Point
You can quickly add impact to your slides by using the Microsoft Office PowerPoint 2007 charting tools. Use charts to better illustrate, compare, and communicate data to your audience.
1. Go to the Insert tab and click the Chart icon.
2. Select the type of chart that best suits your needs—for example, a line, bar, pie, area, or surface chart.
3. If you have Microsoft Office Excel 2007 installed, the program will open and enable you to change the data behind your chart.
4. Explore and use the options in the contextual tabs under Chart Tools to alter the design, format, and layout of your chart.
You can quickly add impact to your slides by using the Microsoft Office PowerPoint 2007 charting tools. Use charts to better illustrate, compare, and communicate data to your audience.
1. Go to the Insert tab and click the Chart icon.
2. Select the type of chart that best suits your needs—for example, a line, bar, pie, area, or surface chart.
3. If you have Microsoft Office Excel 2007 installed, the program will open and enable you to change the data behind your chart.
4. Explore and use the options in the contextual tabs under Chart Tools to alter the design, format, and layout of your chart.
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 easily save that table for easy insertion into any document. Just select a completed example of your table and save it to the Quick Tables gallery. Here’s how:
Select the table and press ALT+F3 to open the Create New Building Block dialog box. Type a name for your table, and then in the Gallery list, click Tables. You can set other options as well, such as choosing or creating a category for your table, which will affect where in the Quick Tables gallery it appears.
You can also choose an available template in which to store the table. But if you retain the default Save in location, Building Blocks.dotx, your table will be available for you to 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 easily save that table for easy insertion into any document. Just select a completed example of your table and save it to the Quick Tables gallery. Here’s how:
Select the table and press ALT+F3 to open the Create New Building Block dialog box. Type a name for your table, and then in the Gallery list, click Tables. You can set other options as well, such as choosing or creating a category for your table, which will affect where in the Quick Tables gallery it appears.
You can also choose an available template in which to store the table. But if you retain the default Save in location, Building Blocks.dotx, your table will be available for you to use in any document. To access your saved table, on the Insert tab, click Table, and then point to Quick Tables.
How to List Your Contact in the Groove Public Directory in Office Grove
List Your Contact in the Groove Public Directory in Office Grove
If management policies allow it, be sure to list your contact information in the Microsoft Office Groove Public Directory so that other Groove users can find you more easily.
1. From the Options menu, click Preferences.
2. From the Identities tab, select All Contact Information in the Public Groove Directory list.
If management policies allow it, be sure to list your contact information in the Microsoft Office Groove Public Directory so that other Groove users can find you more easily.
1. From the Options menu, click Preferences.
2. From the Identities tab, select All Contact Information in the Public Groove Directory list.
How to Gain Greater Control over Your Out-of-Office Message in MS Outlook
Gain Greater Control over Your Out-of-Office Message in MS Outlook
If you use Microsoft Office Outlook 2007 with Microsoft Exchange Server 2007, you have the increased capability to set distinct out-of-office messages and to schedule the time period when you want your messages to be sent. You retain greater control over the type of information your contacts receive, helping to ensure that it’s relevant and appropriate to their needs.
1. To open Out of Office Assistant, click Tools, and then click Out of Office Assistant.
2. Explore the options. You can set the date range and time frame, and set one message for people inside your organization and a separate one for people outside your organization. Note: Your organization must be using Exchange Server 2007 for you to see these options.
If you use Microsoft Office Outlook 2007 with Microsoft Exchange Server 2007, you have the increased capability to set distinct out-of-office messages and to schedule the time period when you want your messages to be sent. You retain greater control over the type of information your contacts receive, helping to ensure that it’s relevant and appropriate to their needs.
1. To open Out of Office Assistant, click Tools, and then click Out of Office Assistant.
2. Explore the options. You can set the date range and time frame, and set one message for people inside your organization and a separate one for people outside your organization. Note: Your organization must be using Exchange Server 2007 for you to see these options.
How to Create a Project Proposal in Office Project
Create a Project Proposal in Office Project
By using proposals, you can define high-level project plans to provide key project information, milestones, and resource demands.
1. In Microsoft Office Project Web Access, click Proposals and Activity Plans in the left Action pane.
2. On the New menu, click Proposal.
3. In the New and Import section, click New.
4. Enter the name of the project, description, start date, finish date, and plan owner. You can also add details about tasks or resources with a resource plan or build team.
5. Click Publish. You have now created a complete Project proposal, pending approval.
By using proposals, you can define high-level project plans to provide key project information, milestones, and resource demands.
1. In Microsoft Office Project Web Access, click Proposals and Activity Plans in the left Action pane.
2. On the New menu, click Proposal.
3. In the New and Import section, click New.
4. Enter the name of the project, description, start date, finish date, and plan owner. You can also add details about tasks or resources with a resource plan or build team.
5. Click Publish. You have now created a complete Project proposal, pending approval.
How to Find the Correct Format for Excel Formulas in MS Excel
Find the Correct Format for Excel Formulas in MS Excel
You can use Microsoft IntelliSense technology in Microsoft Office Excel 2007 to create formulas. If you want to type a formula in Excel 2007, start by typing the first few characters of the formula (for example, an equal sign and then a letter) to view a list of available formulas. Excel 2007 makes it easy to see all the available types of formulas; the enhanced tooltips in the 2007 Office system provide a detailed explanation of each formula.
You can use Microsoft IntelliSense technology in Microsoft Office Excel 2007 to create formulas. If you want to type a formula in Excel 2007, start by typing the first few characters of the formula (for example, an equal sign and then a letter) to view a list of available formulas. Excel 2007 makes it easy to see all the available types of formulas; the enhanced tooltips in the 2007 Office system provide a detailed explanation of each formula.
How to Use the Ribbon in MS Office System
Using the Ribbon in MS Office System
You can think of the Ribbon of tools and commands in the 2007 Microsoft Office system as your visual gallery to create professional and visually interesting documents.
In the 2007 Microsoft Office system, there are no dialog boxes for formatting text and images. The formatting tools that you are used to using still exist, but they are integrated into the Ribbon. You can use the new tabs to move across various sets of commands or Ribbons that make up the Microsoft Office Fluent user interface.
Additionally, while you are working on a document, the Ribbon automatically presents you with the right formatting tools at the right time and place. It reveals a visual gallery to help you quickly and easily format documents. For example, if you want to change the positioning of a picture you have imported into a Microsoft Office Word document:
1. Double-click the image. A Picture Tools tab opens a gallery that displays options to choose from.
2. Select the Position option from the gallery on the Picture Tools tab to easily define where the photo will sit within the text.
You can think of the Ribbon of tools and commands in the 2007 Microsoft Office system as your visual gallery to create professional and visually interesting documents.
In the 2007 Microsoft Office system, there are no dialog boxes for formatting text and images. The formatting tools that you are used to using still exist, but they are integrated into the Ribbon. You can use the new tabs to move across various sets of commands or Ribbons that make up the Microsoft Office Fluent user interface.
Additionally, while you are working on a document, the Ribbon automatically presents you with the right formatting tools at the right time and place. It reveals a visual gallery to help you quickly and easily format documents. For example, if you want to change the positioning of a picture you have imported into a Microsoft Office Word document:
1. Double-click the image. A Picture Tools tab opens a gallery that displays options to choose from.
2. Select the Position option from the gallery on the Picture Tools tab to easily define where the photo will sit within the text.
How to Create an Electronic Business Card for Your Signature in MS Outlook
Create an Electronic Business Card for Your Signature in MS Outlook
In Microsoft Office Outlook 2007, you can create and share customized electronic business cards, giving you a personalized way to communicate your information. You can customize your contact information by using electronic business cards that include logos and photos, making contacts more personally relevant and easier to locate.
1. Click the arrow next to New, and then click Contact.
2. Type your personal contact information, such as name, title, company, work phone, and work fax number. Note: As you type, a preview of your business card appears in the business card box in the upper-right corner.
3. Click the Business Card button on the Ribbon to open the Edit Business Card dialog box.
4. In the Card Design section, click the Change button next to Image to add your photograph, company logo, or other pictures. Click the Background Color button to change the background color of your business card. In the Edit section, you can change the size, justification, or color of your text.
5. To use your customized electronic business card as your signature, click the Business Card button on the Message tab of the Ribbon.
In Microsoft Office Outlook 2007, you can create and share customized electronic business cards, giving you a personalized way to communicate your information. You can customize your contact information by using electronic business cards that include logos and photos, making contacts more personally relevant and easier to locate.
1. Click the arrow next to New, and then click Contact.
2. Type your personal contact information, such as name, title, company, work phone, and work fax number. Note: As you type, a preview of your business card appears in the business card box in the upper-right corner.
3. Click the Business Card button on the Ribbon to open the Edit Business Card dialog box.
4. In the Card Design section, click the Change button next to Image to add your photograph, company logo, or other pictures. Click the Background Color button to change the background color of your business card. In the Edit section, you can change the size, justification, or color of your text.
5. To use your customized electronic business card as your signature, click the Business Card button on the Message tab of the Ribbon.
How to Send a OneNote Note via Outlook E-Mail
Sending a OneNote Note via Outlook E-Mail
You can send a Microsoft Office OneNote 2007 note via Microsoft Office Outlook in one of two ways:
If the recipient has Office OneNote 2007, click File, and then click E-mail. Office OneNote 2007 will open your Outlook (2007 or 2003) e-mail client and attach your notes as a .one attachment.
If the recipient does not have Office OneNote 2007, you can paste OneNote notebook content as HTML into the body of an e-mail message in Outlook.
You can send a Microsoft Office OneNote 2007 note via Microsoft Office Outlook in one of two ways:
If the recipient has Office OneNote 2007, click File, and then click E-mail. Office OneNote 2007 will open your Outlook (2007 or 2003) e-mail client and attach your notes as a .one attachment.
If the recipient does not have Office OneNote 2007, you can paste OneNote notebook content as HTML into the body of an e-mail message in Outlook.
How to Publish Items to Excel Services in MS Excel
Publishing Items to Excel Services in MS Excel
To publish your Microsoft Office Excel spreadsheets (or single items) to Microsoft Office SharePoint Server 2007:
1. With your spreadsheet open, click the Office button, and then click Publish.
2. Click Excel Services.
3. In the dialog box, select a trusted document library location in Office SharePoint Server 2007, and then click Excel Services Options.
4. Select whether you want to publish the entire spreadsheet, individual worksheets, or only selected items (such as charts, tables, or Microsoft PivotTable dynamic views). Click OK.
Your spreadsheet will be saved to the document library, and only your published items will be visible through the Web browser interface
To publish your Microsoft Office Excel spreadsheets (or single items) to Microsoft Office SharePoint Server 2007:
1. With your spreadsheet open, click the Office button, and then click Publish.
2. Click Excel Services.
3. In the dialog box, select a trusted document library location in Office SharePoint Server 2007, and then click Excel Services Options.
4. Select whether you want to publish the entire spreadsheet, individual worksheets, or only selected items (such as charts, tables, or Microsoft PivotTable dynamic views). Click OK.
Your spreadsheet will be saved to the document library, and only your published items will be visible through the Web browser interface
How to Publish Your Calendar to Microsoft Office Online in MS Outlook
Publish Your Calendar to Microsoft Office Online in MS Outlook
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.
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.
How to Create Organizational Charts in MS Office VIsio
Creating Organizational Charts in MS Office VIsio
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.
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.
Kamis, 25 September 2008
How to use Quick Search in MS Vista
Quick Search in MS Vista
If you need to find a file quickly, the Windows Vista indexed file system makes it easy.
1. Click Start.
2. Type as much information as you know about the file in the text box. As you type, the files that meet your criteria will appear.
If you need to find a file quickly, the Windows Vista indexed file system makes it easy.
1. Click Start.
2. Type as much information as you know about the file in the text box. As you type, the files that meet your criteria will appear.
How to Customize Your Pictures in MS Power Point
Customize Your Pictures in MS Power Point
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.
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.
How to Apply WordArt Text Effects in MS Power Point
Apply WordArt Text Effects in MS Power Point
You can easily liven up your slide titles and text by using WordArt and Text Effects.
1. Highlight the text to which you want to apply effects.
2. On the Format tab, locate the WordArt Quick Styles gallery.
3. Select a WordArt style if you want to apply a predefined style to your text.
4. Add custom effects like reflection, glow, 3-D rotation, and bevel by using the Text Effects gallery.
You can easily liven up your slide titles and text by using WordArt and Text Effects.
1. Highlight the text to which you want to apply effects.
2. On the Format tab, locate the WordArt Quick Styles gallery.
3. Select a WordArt style if you want to apply a predefined style to your text.
4. Add custom effects like reflection, glow, 3-D rotation, and bevel by using the Text Effects gallery.
How to Create a New Table in MS Access
To Create a New Table in MS Access
Microsoft Office Access 2007 has made creating tables easy by providing a handful of common schemas.
1. On the Ribbon, on the Create tab, in the Tables section, click Table.
2. Type the first value in the cell, just as you would in a Microsoft Office Excel spreadsheet, and then press ENTER.
3. Double-click the column heading to rename the field.
Based on the value typed, Access automatically defines the data type, although it does so differently from a spreadsheet. In Access, each field—a column in your datasheet—is defined by a data type.
Microsoft Office Access 2007 has made creating tables easy by providing a handful of common schemas.
1. On the Ribbon, on the Create tab, in the Tables section, click Table.
2. Type the first value in the cell, just as you would in a Microsoft Office Excel spreadsheet, and then press ENTER.
3. Double-click the column heading to rename the field.
Based on the value typed, Access automatically defines the data type, although it does so differently from a spreadsheet. In Access, each field—a column in your datasheet—is defined by a data type.
How to Use Voting Buttons in MS Outlook
Using Voting Buttons in MS Outlook
You can easily collect information from your coworkers. The redesigned Microsoft Office Fluent user interface makes it easier than ever to use voting buttons to collect information through e-mail. Here’s how:
1. Create a new message in Outlook, or reply to an existing message.
2. On the Options tab, in the Tracking section, click Use Voting Buttons.
3. Click the option you prefer. For additional message options, click Custom
You can easily collect information from your coworkers. The redesigned Microsoft Office Fluent user interface makes it easier than ever to use voting buttons to collect information through e-mail. Here’s how:
1. Create a new message in Outlook, or reply to an existing message.
2. On the Options tab, in the Tracking section, click Use Voting Buttons.
3. Click the option you prefer. For additional message options, click Custom
How to Avoid PowerPoint Animations in Office Live Meeting
Avoid PowerPoint Animations in Office Live Meeting
If you’re creating a Microsoft Office PowerPoint presentation that you plan to deliver in Microsoft Office Live Meeting, think twice before spending time on animations and slide transitions. Microsoft Office PowerPoint Viewer will display them, but they occupy a lot of bandwidth; and if you’re recording the meeting, they won’t be preserved.
If you’re creating a Microsoft Office PowerPoint presentation that you plan to deliver in Microsoft Office Live Meeting, think twice before spending time on animations and slide transitions. Microsoft Office PowerPoint Viewer will display them, but they occupy a lot of bandwidth; and if you’re recording the meeting, they won’t be preserved.
How to Manage Rules in MS Excel
Managing Rules in MS Excel
To view conditional formatting rules or to perform changes:
1. On the Home tab, in the Styles group, click Conditional Formatting, and then click Manage Rules.
2. Select the rule that you want to view or modify, and then click Edit Rule.
3. Edit the rule in the dialog box, and then click OK.
To view conditional formatting rules or to perform changes:
1. On the Home tab, in the Styles group, click Conditional Formatting, and then click Manage Rules.
2. Select the rule that you want to view or modify, and then click Edit Rule.
3. Edit the rule in the dialog box, and then click OK.
How to Restore Previous Version of a Recent File in Microsoft Vista
Restore Previous Version of a Recent File in Microsoft Vista
On occasion you make a mistake, and you want to revert to a previous version of a file you have been working on. After System Protection is configured, you can do so with Windows Vista. Right-click the file, and then select the version you want.
Note: System Protection must be configured, and you must have sufficient disk space.
On occasion you make a mistake, and you want to revert to a previous version of a file you have been working on. After System Protection is configured, you can do so with Windows Vista. Right-click the file, and then select the version you want.
Note: System Protection must be configured, and you must have sufficient disk space.
How to Send Information from Outlook to OneNote
Sending Information from Outlook to OneNote
Microsoft Office Outlook 2007 has a Send to OneNote button for inserting relevant content from an e-mail thread into your Microsoft Office OneNote notebook. Click the Send to OneNote button in your Inbox, and both the e-mail thread and metadata such as date, time, sender, and subject will be inserted into the Unfiled Notes section of your OneNote notebook.
Microsoft Office Outlook 2007 has a Send to OneNote button for inserting relevant content from an e-mail thread into your Microsoft Office OneNote notebook. Click the Send to OneNote button in your Inbox, and both the e-mail thread and metadata such as date, time, sender, and subject will be inserted into the Unfiled Notes section of your OneNote notebook.
How to Work on Large Documents in MS Word
Work on Large Documents in MS Word
In Microsoft Office Word and Microsoft Office Excel, you can split the screen to see two separate parts of a document at once.
On the View tab, in the Window section, click Split, and then click the screen where you want the split to appear. You can then navigate parts of the document separately in each window.
Excel adds both a horizontal and a vertical split to the screen. If you don't want one of them, drag the line up to the top or the left side and drop it at the edge of the screen, where it will disappear.
To return to the single-screen view of the document in either Word or Excel, go back to the Window section and click Remove Split.
In Microsoft Office Word and Microsoft Office Excel, you can split the screen to see two separate parts of a document at once.
On the View tab, in the Window section, click Split, and then click the screen where you want the split to appear. You can then navigate parts of the document separately in each window.
Excel adds both a horizontal and a vertical split to the screen. If you don't want one of them, drag the line up to the top or the left side and drop it at the edge of the screen, where it will disappear.
To return to the single-screen view of the document in either Word or Excel, go back to the Window section and click Remove Split.
How to use RSS Feeds in MS Out Look
RSS Feeds in MS Out Look
Really Simple Syndication (RSS) feeds are an easy way to subscribe to interesting information like world news, sport scores, or blogs. With Microsoft Office Outlook 2007, it’s easy to start adding and reading RSS subscriptions.
1. Click the mail folder called RSS Feeds.
2. Choose a feed that interests you from the RSS Feeds content directory.
3. Outlook prompts you to add this feed to your list. Click OK.
4. Outlook creates a specific RSS subscription folder for this feed below the main RSS Feeds folder.
Note: When using Office Outlook 2007 with Windows Internet Explorer 7, you can keep a synchronized list of subscriptions between the two programs.
Really Simple Syndication (RSS) feeds are an easy way to subscribe to interesting information like world news, sport scores, or blogs. With Microsoft Office Outlook 2007, it’s easy to start adding and reading RSS subscriptions.
1. Click the mail folder called RSS Feeds.
2. Choose a feed that interests you from the RSS Feeds content directory.
3. Outlook prompts you to add this feed to your list. Click OK.
4. Outlook creates a specific RSS subscription folder for this feed below the main RSS Feeds folder.
Note: When using Office Outlook 2007 with Windows Internet Explorer 7, you can keep a synchronized list of subscriptions between the two programs.
How to Apply Conditional Formatting in MS Excel
Applying Conditional Formatting in MS Excel
Conditional formatting is a feature that enables users to apply formatting to cells automatically depending on the value of the cell or the value of a formula. By visualizing data in a graphical way, you can identify trends and exceptions more quickly.
To visualize the value of a cell relative to other cells in the same range:
1. Select a range of cells.
2. On the Home tab, in the Style group, click Conditional Formatting, click Data Bars, and then select a data bar icon.
To classify data into three to five categories separated by a threshold value, use icon sets:
1. Select a range of cells.
2. On the Home tab, in the Style group, click Conditional Formatting, click Icon Set, and then select an icon set.
Conditional formatting is a feature that enables users to apply formatting to cells automatically depending on the value of the cell or the value of a formula. By visualizing data in a graphical way, you can identify trends and exceptions more quickly.
To visualize the value of a cell relative to other cells in the same range:
1. Select a range of cells.
2. On the Home tab, in the Style group, click Conditional Formatting, click Data Bars, and then select a data bar icon.
To classify data into three to five categories separated by a threshold value, use icon sets:
1. Select a range of cells.
2. On the Home tab, in the Style group, click Conditional Formatting, click Icon Set, and then select an icon set.
How to Exchange Contact Information—Sending Your Contact to Others in MS Groove
Exchanging Contact Information—Sending Your Contact to Others in MS Groove
You can send your Microsoft Office Groove 2007 contact to others right from the Common Tasks pane on the Contacts tab in the Launchbar.
1. Click Send My Contact via E-mail.
2. Type the e-mail addresses of the people whom you want to receive your contact.
3. Recipients receive an e-mail message with a hyperlink that automatically adds your contact to their list in the Groove Launchbar.
You can send your Microsoft Office Groove 2007 contact to others right from the Common Tasks pane on the Contacts tab in the Launchbar.
1. Click Send My Contact via E-mail.
2. Type the e-mail addresses of the people whom you want to receive your contact.
3. Recipients receive an e-mail message with a hyperlink that automatically adds your contact to their list in the Groove Launchbar.
How to Access Information in One Click by Using Attachment Preview in MS OutLook
Access Information in One Click by Using Attachment Preview in MS OutLook
Accessing mail attachments is often a multistep process that provides no easy way to gain quick insight to that content. With Attachment Preview, you can preview your attachments in one click directly from within Microsoft Office Outlook, saving you time and effort.
1. Click the attachment in the e-mail message or reading pane.
2. Scroll through the document or presentation by using the scroll bar on the right. To return to the e-mail message, click the message box to the left of the attachment.
Note: The presentation or document is a read-only copy. To make edits or comments, you need to save a local version on your computer.
Accessing mail attachments is often a multistep process that provides no easy way to gain quick insight to that content. With Attachment Preview, you can preview your attachments in one click directly from within Microsoft Office Outlook, saving you time and effort.
1. Click the attachment in the e-mail message or reading pane.
2. Scroll through the document or presentation by using the scroll bar on the right. To return to the e-mail message, click the message box to the left of the attachment.
Note: The presentation or document is a read-only copy. To make edits or comments, you need to save a local version on your computer.
How to Insert and Format Charts in MS Excel
Insert and Format Charts in MS Excel
In Microsoft Office Excel 2007, you will find many new professional-looking charts to help you visualize your data and communicate it more effectively. To insert a chart:
1. On the worksheet, arrange the data that you want to use in a chart.
2. Select the cells that contain the data that you want to use for the chart.
3. On the Insert tab, in the Charts group, click the chart type, and then click a chart subtype that you want to use.
To see all available chart types, click a chart type, and then click All Chart Types. Excel will select the default formatting layout, but you can quickly modify it:
1. On the contextual Design tab, select a chart layout from the gallery to display the legend, axis, and title the way you want.
2. Select a chart style to modify color and effects.
In Microsoft Office Excel 2007, you will find many new professional-looking charts to help you visualize your data and communicate it more effectively. To insert a chart:
1. On the worksheet, arrange the data that you want to use in a chart.
2. Select the cells that contain the data that you want to use for the chart.
3. On the Insert tab, in the Charts group, click the chart type, and then click a chart subtype that you want to use.
To see all available chart types, click a chart type, and then click All Chart Types. Excel will select the default formatting layout, but you can quickly modify it:
1. On the contextual Design tab, select a chart layout from the gallery to display the legend, axis, and title the way you want.
2. Select a chart style to modify color and effects.
How to Share Charting in 2003 to 2007
2003 to 2007 Shared Charting
Copying and pasting a Microsoft Office Excel 2003 chart into Microsoft Office PowerPoint 2003 is easy. The real challenge is editing the chart after it's part of your presentation, because the charting tools are different between the applications. With the shared charting engine in the 2007 Microsoft Office system, you can use the same charting tools to create and customize your charts in Microsoft Office Excel 2007, Microsoft Office PowerPoint 2007, and Microsoft Office Word 2007.
To insert a chart in Excel 2007, click the Insert tab, and then select the type of chart you want from the Charts group. To customize an existing chart, click inside the chart, and then use the contextual Chart Tools command tabs that appear on the Ribbon
Copying and pasting a Microsoft Office Excel 2003 chart into Microsoft Office PowerPoint 2003 is easy. The real challenge is editing the chart after it's part of your presentation, because the charting tools are different between the applications. With the shared charting engine in the 2007 Microsoft Office system, you can use the same charting tools to create and customize your charts in Microsoft Office Excel 2007, Microsoft Office PowerPoint 2007, and Microsoft Office Word 2007.
To insert a chart in Excel 2007, click the Insert tab, and then select the type of chart you want from the Charts group. To customize an existing chart, click inside the chart, and then use the contextual Chart Tools command tabs that appear on the Ribbon
Rabu, 24 September 2008
How to Use the Quick Access Toolbar in MS Office
Use the Quick Access Toolbar in MS Office
You can add your favorite—or most commonly used—commands to the Quick Access Toolbar in the 2007 Microsoft Office system, so that these tools are always easy to find. You’ll find the Quick Access Toolbar next to the Office button above the Ribbon.
The default commands on the Quick Access Toolbar are Save, Undo, and Repeat. You can add your most-used favorites by clicking the expandable arrow to the right of the Quick Access Toolbar to open the Customize Quick Access Toolbar menu. Here, you can select the set of commands that you want on the Quick Access Toolbar.
To add commands that aren't on the list, click More Commands. If you're adding a lot of new commands to the Quick Access Toolbar, use the Customize menu and click Show Below the Ribbon. This will move your Quick Access Toolbar to below the Ribbon to give it more room to expand.
You can add your favorite—or most commonly used—commands to the Quick Access Toolbar in the 2007 Microsoft Office system, so that these tools are always easy to find. You’ll find the Quick Access Toolbar next to the Office button above the Ribbon.
The default commands on the Quick Access Toolbar are Save, Undo, and Repeat. You can add your most-used favorites by clicking the expandable arrow to the right of the Quick Access Toolbar to open the Customize Quick Access Toolbar menu. Here, you can select the set of commands that you want on the Quick Access Toolbar.
To add commands that aren't on the list, click More Commands. If you're adding a lot of new commands to the Quick Access Toolbar, use the Customize menu and click Show Below the Ribbon. This will move your Quick Access Toolbar to below the Ribbon to give it more room to expand.
How to Create SmartArt Diagrams in MS Power Point
Create SmartArt Diagrams in MS Power Point
Microsoft SmartArt graphics make it easy for you to create high-impact, professional diagrams. Instead of spending hours designing your own diagrams, you can use Microsoft Office PowerPoint 2007 to focus on the visual message that you want to communicate.
1. On the Insert tab, click the SmartArt button.
2. In the list of diagram categories, select the type of diagram that you want to add to your presentation.
3. Under Type your text here, type a list of the information that you want reflected in your diagram.
4. Click the Design tab, and then select colors and styles from the available galleries to make your diagram look great.
Microsoft SmartArt graphics make it easy for you to create high-impact, professional diagrams. Instead of spending hours designing your own diagrams, you can use Microsoft Office PowerPoint 2007 to focus on the visual message that you want to communicate.
1. On the Insert tab, click the SmartArt button.
2. In the list of diagram categories, select the type of diagram that you want to add to your presentation.
3. Under Type your text here, type a list of the information that you want reflected in your diagram.
4. Click the Design tab, and then select colors and styles from the available galleries to make your diagram look great.
Selasa, 23 September 2008
How to Organize Information with Color Categories in MS Outlook
Organize Information with Color Categories in MS Outlook
Color categories give you a simple, visual way to distinguish items from one another, making it easy to organize your data and search for information.
1. Right-click the box next to an e-mail message.
2. Click All Categories.
3. Assign titles to your color categories, such as personal, work, finance, family, or birthdays.
4. Click OK.
5. Right-click the category box next to an e-mail message and assign a color category to it.
6. Arrange your e-mail list, or search by color categories.
Color categories give you a simple, visual way to distinguish items from one another, making it easy to organize your data and search for information.
1. Right-click the box next to an e-mail message.
2. Click All Categories.
3. Assign titles to your color categories, such as personal, work, finance, family, or birthdays.
4. Click OK.
5. Right-click the category box next to an e-mail message and assign a color category to it.
6. Arrange your e-mail list, or search by color categories.
How to use Multiple Level Undo, Change Highlighting, and Task Drivers in MS Office Project
Multiple Level Undo, Change Highlighting, and Task Drivers in MS Office Project
In Microsoft Office Project Professional 2007, project managers can visualize the impact of changes and trace back their steps. To turn the Change Highlighting feature on or off, click the View menu, and then click Hide Change Highlighting or Show Change Highlighting. While the feature is enabled, all levels of tasks affected as a result of a change are highlighted with a color as a visual indicator. Using this feature together with the Multiple Level Undo feature, project managers can do "what-if analysis" by trying a set of changes and then reversing unwanted changes. If further analysis of a task's schedule is needed, the project manager can use Task Drivers on the Project menu to determine the factors (such as task dependency, calendar constraints, schedule date, or vacation time) that are driving a task's start date.
In Microsoft Office Project Professional 2007, project managers can visualize the impact of changes and trace back their steps. To turn the Change Highlighting feature on or off, click the View menu, and then click Hide Change Highlighting or Show Change Highlighting. While the feature is enabled, all levels of tasks affected as a result of a change are highlighted with a color as a visual indicator. Using this feature together with the Multiple Level Undo feature, project managers can do "what-if analysis" by trying a set of changes and then reversing unwanted changes. If further analysis of a task's schedule is needed, the project manager can use Task Drivers on the Project menu to determine the factors (such as task dependency, calendar constraints, schedule date, or vacation time) that are driving a task's start date.
Senin, 22 September 2008
How to Chang Table Styles in MS Excel
Changing Table Styles in MS Excel
To change table style:
1. Click inside the table you’d like to change.
2. On the contextual Design tab, pause on any table style for a live preview, and click when you want to confirm the change (click the arrows in the gallery to view more styles).
3. Make selections in the Table Style Options group to change formatting of the first and last column, to add a Totals Row, or to have banded rows or columns.
To change table style:
1. Click inside the table you’d like to change.
2. On the contextual Design tab, pause on any table style for a live preview, and click when you want to confirm the change (click the arrows in the gallery to view more styles).
3. Make selections in the Table Style Options group to change formatting of the first and last column, to add a Totals Row, or to have banded rows or columns.
How to Keep Organizational Charts Updated in MS Office Visio
Keeping Organizational Charts Updated in MS Office Visio
You can add new people quickly to an organizational chart.
1. Start Microsoft Office Visio, and then click OrgChart Assistant.
2. Click Information Stored, and then click Microsoft Exchange Server.
3. Click Next in the subsequent two dialog boxes.
4. Click Automatically Break Organization Chart, enter the details for the person you want to add to the chart, and then click Finish. Repeat this process for each individual you want to add to your chart.
You can add new people quickly to an organizational chart.
1. Start Microsoft Office Visio, and then click OrgChart Assistant.
2. Click Information Stored, and then click Microsoft Exchange Server.
3. Click Next in the subsequent two dialog boxes.
4. Click Automatically Break Organization Chart, enter the details for the person you want to add to the chart, and then click Finish. Repeat this process for each individual you want to add to your chart.
How to Access Programs Quickly in Vista Explorer
Access Programs Quickly in Vista Explorer
As you settle in to using Windows Vista, you will want to access your most important programs quickly from the Quick Launch bar.
1. Click the Start button.
2. Click All Programs.
3. Find and right-click your program.
4. Click Add to Quick Launch.
As you settle in to using Windows Vista, you will want to access your most important programs quickly from the Quick Launch bar.
1. Click the Start button.
2. Click All Programs.
3. Find and right-click your program.
4. Click Add to Quick Launch.
How to Edit Lengthy Documents More Efficiently in MS Word
Edit Lengthy Documents More Efficiently in MS Word
To save time scrolling back and forth when you're editing a long document, you can use the keyboard shortcut SHIFT+F5. This shortcut switches back to the area of the document on which you were working previously. For example, if you were working on the tactics part of your plan and moved to edit something in the budget, by pressing SHIFT+F5, you immediately return to the tactics section.
To save time scrolling back and forth when you're editing a long document, you can use the keyboard shortcut SHIFT+F5. This shortcut switches back to the area of the document on which you were working previously. For example, if you were working on the tactics part of your plan and moved to edit something in the budget, by pressing SHIFT+F5, you immediately return to the tactics section.
How to use To-Do Bar in MS OutLook
To-Do Bar in MS OutLook
You can check your priorities for the day by looking at the To-Do Bar, where your flagged mail messages and tasks are clearly laid out. To customize the view of your To-Do Bar:
1. Click View, click To-Do Bar, and then click Options.
2. In the To-Do Bar Options dialog box, you can customize how many months are shown and how many upcoming appointments are displayed.
You can check your priorities for the day by looking at the To-Do Bar, where your flagged mail messages and tasks are clearly laid out. To customize the view of your To-Do Bar:
1. Click View, click To-Do Bar, and then click Options.
2. In the To-Do Bar Options dialog box, you can customize how many months are shown and how many upcoming appointments are displayed.
How to Link Office OneNote 2007 and Outlook Contacts in Office OneNote
Linking Office OneNote 2007 and Outlook Contacts in Office OneNote
You can link meeting notes or other content from your Microsoft Office OneNote 2007 notebook to your calendar or contacts in Microsoft Office Outlook 2007. Later, if you need to find information about the meeting or the contact details associated with that person, you can either click the link in Office OneNote 2007 or click the link in your calendar or contacts list in Office Outlook 2007 to access the information saved in OneNote.
You can link meeting notes or other content from your Microsoft Office OneNote 2007 notebook to your calendar or contacts in Microsoft Office Outlook 2007. Later, if you need to find information about the meeting or the contact details associated with that person, you can either click the link in Office OneNote 2007 or click the link in your calendar or contacts list in Office Outlook 2007 to access the information saved in OneNote.
How to Remove Comments and Changes from a Document in MS Word
Removing Comments and Changes from a Document in MS Word
Have you ever sent a Microsoft Office Word document that contained comments or tracked changes that you didn’t want visible? Document Inspector eliminates this worry.
1. Click the Office icon, point to Prepare, and then click Inspect Document.
2. By default, all check boxes are selected in Document Inspector. Clear the check box next to any items that you don't want Document Inspector to look for, and then click Inspect.
3. Remove items not for publication. Document Inspector indicates what it finds in your document, so you can choose what you want to remove, and then confidently publish your document.
Have you ever sent a Microsoft Office Word document that contained comments or tracked changes that you didn’t want visible? Document Inspector eliminates this worry.
1. Click the Office icon, point to Prepare, and then click Inspect Document.
2. By default, all check boxes are selected in Document Inspector. Clear the check box next to any items that you don't want Document Inspector to look for, and then click Inspect.
3. Remove items not for publication. Document Inspector indicates what it finds in your document, so you can choose what you want to remove, and then confidently publish your document.
Sabtu, 20 September 2008
Some Links
Computer And Technology
1. How To - Computer :- Learn Some tricks for your computer,
know how to change settings,how to use it in a better way
2. Computer Universe:- Everything related to computer happening in this world
3. Download Softwares and Updates :-Want to download any Software
just find here,need any update go and search, Some interesting
Softwares that you like ForEver
4. How To Web Programming :-Any Problem in Web programming ,
or want to learn Programming, Visit Here
6. How To Blogger :-If you want to Start Your own Blog, Or any blog
related help, go and learn
7. What IS and How To :- Check here for anyhting that you want
to know that “How To Do That” Just Go here and Learn
Entertainment Movies And Songs
1. Download Free Movies :- Download Some movies for Free,
so just go and see if there is any for you2. Download Hindi Movie Songs :-Here you can Download All
hindi movie songs by movies, Old and New movie songs,
singes, Music Directors and so on
3. Download Old Hindi Songs :-This is for Oldies Lovers,
just check for any old song that you like but you ave don’t
4. Songs By Lata Mangeshkar :-Some Old and good songs in
Melody Queen’s Sound, Download some and enjoy
5. Songs By Mohammad Rafi :- Some songs in Legends voice,
Free downloads, go and GET
6. Free SMS And Pics :- Some Friendship SMS, Love SMS,
Jokes, Funny SMS, And some Pics
Health
1. My Helath: - Know health related Tips
2. Beauty Tips :- Know sone tips for your body
3. Love Tips :- Some Love Tips
Regional
1. Whats New in Himachal :-Something About Himachal Pradesh,
Know about Hilly State, whats going on there and so on
2. Whats New in Chandigarh :-Check for news update in Chandigarh
Money Making Tips
1. Money Making Tips :-Want to earn some good income using Internet
or with your PC, Check here and Start Your Earning NOW
The Nature
1. Prakriti The Nature :- Go and see the Nature, the Prakriti
Selasa, 16 September 2008
How to Flag E-Mail as a Task in MS Out Look
Flag E-Mail as a Task in MS Out Look
Flagging mail messages as tasks automatically adds them to your To-Do Bar so that you can easily track and complete them.
1. Right-click the flag icon next to an e-mail message.
2. Designate a date by which you want to follow up on this message.
3. View the message on your To-Do Bar.
Flagging mail messages as tasks automatically adds them to your To-Do Bar so that you can easily track and complete them.
1. Right-click the flag icon next to an e-mail message.
2. Designate a date by which you want to follow up on this message.
3. View the message on your To-Do Bar.
How to Work with Prebuilt Templates in MS Access
Working with Prebuilt Templates in MS Access
The new Getting Started window includes a variety of prebuilt database solutions. You can use these solutions right out of the box, or you can enhance and refine them to accommodate the kind of information you want to track or the way in which you want to track it. To open a template:
1. Start Microsoft Office Access 2007.
2. Browse the categories to find the template you want, and then click it.
3. Browse for a folder, and then click Download
The new Getting Started window includes a variety of prebuilt database solutions. You can use these solutions right out of the box, or you can enhance and refine them to accommodate the kind of information you want to track or the way in which you want to track it. To open a template:
1. Start Microsoft Office Access 2007.
2. Browse the categories to find the template you want, and then click it.
3. Browse for a folder, and then click Download
How to Increase 2003 to 2007 Worksheet Capacity in MS Excel
2003 to 2007 Increased Worksheet Capacity in MS Excel
Do you regularly work with data sets larger than the capacity of 65,536 rows by 256 columns in Microsoft Office Excel 2003? Microsoft Office Excel 2007 supports up to 1,048,576 rows by 16,384 columns, so you no longer have to use many different worksheets to support your data. You can use the zoom slider at the lower right of the Office Excel 2007 window to zoom out for a bird's-eye view of how much data your worksheet can hold.
To support a bigger grid, Office Excel 2007 uses several other increased limits. For example, the number of rows allowed in a Microsoft PivotTable chart has increased from 64,000 to more than 1 million, and the amount of memory that Excel can use has increased from 1 gigabyte (GB) to the maximum allowed by the Windows operating system. The limit on the number of rows in a column or columns that can be referred to in an array formula has been completely eliminated.
Do you regularly work with data sets larger than the capacity of 65,536 rows by 256 columns in Microsoft Office Excel 2003? Microsoft Office Excel 2007 supports up to 1,048,576 rows by 16,384 columns, so you no longer have to use many different worksheets to support your data. You can use the zoom slider at the lower right of the Office Excel 2007 window to zoom out for a bird's-eye view of how much data your worksheet can hold.
To support a bigger grid, Office Excel 2007 uses several other increased limits. For example, the number of rows allowed in a Microsoft PivotTable chart has increased from 64,000 to more than 1 million, and the amount of memory that Excel can use has increased from 1 gigabyte (GB) to the maximum allowed by the Windows operating system. The limit on the number of rows in a column or columns that can be referred to in an array formula has been completely eliminated.
How to use Instant Search in MS Out Look
Instant Search in MS Out Look
You can rapidly search for keywords or other criteria to locate items in your e-mail, calendar, contacts, or tasks, saving you valuable time.
1. Type a keyword in the Instant Search box above your e-mail list.
2. Expand the search box by using the arrow on the right to add more search criteria.
3. Expand your search results to your desktop or all mail items by using the arrow to the right of the magnifying glass
You can rapidly search for keywords or other criteria to locate items in your e-mail, calendar, contacts, or tasks, saving you valuable time.
1. Type a keyword in the Instant Search box above your e-mail list.
2. Expand the search box by using the arrow on the right to add more search criteria.
3. Expand your search results to your desktop or all mail items by using the arrow to the right of the magnifying glass
How to Use PowerPoint Themes
Using PowerPoint Themes
With Microsoft Office PowerPoint 2007, you can easily change the look of your entire presentation with just one click. By applying a theme, you can be confident that your entire presentation has a professional look.
1. Go to the Design tab.
2. Pause on different themes in the Themes gallery to see a preview of how the presentation looks with the theme applied.
3. Click the theme that you want to apply to your presentation.
With Microsoft Office PowerPoint 2007, you can easily change the look of your entire presentation with just one click. By applying a theme, you can be confident that your entire presentation has a professional look.
1. Go to the Design tab.
2. Pause on different themes in the Themes gallery to see a preview of how the presentation looks with the theme applied.
3. Click the theme that you want to apply to your presentation.
How to Use InfoPath Forms in Groove
Using InfoPath Forms in Groove
You can use Microsoft Office Groove 2007 to share Microsoft Office InfoPath forms within a Groove workspace. Sharing forms enables a team to gather, view, and track structured data, even if team members are offline or cannot access the corporate network.
When you have built your form in Office InfoPath 2007, you can use the new Groove InfoPath Forms tool to import the form into the workspace. After the form is imported, members of the workspace can fill it out at any time, whether they are online or offline. Completed copies of the form—called "records"—are collected and displayed in the tool and can be viewed and tracked in different ways.
The InfoPath Forms tool also takes advantage of the automatic alerts and unread marks in Office Groove 2007, which help team members stay up to date as new forms are filled out.
You can use Microsoft Office Groove 2007 to share Microsoft Office InfoPath forms within a Groove workspace. Sharing forms enables a team to gather, view, and track structured data, even if team members are offline or cannot access the corporate network.
When you have built your form in Office InfoPath 2007, you can use the new Groove InfoPath Forms tool to import the form into the workspace. After the form is imported, members of the workspace can fill it out at any time, whether they are online or offline. Completed copies of the form—called "records"—are collected and displayed in the tool and can be viewed and tracked in different ways.
The InfoPath Forms tool also takes advantage of the automatic alerts and unread marks in Office Groove 2007, which help team members stay up to date as new forms are filled out.
How to Create a Hyperlink in MS Excel
To Create a Hyperlink in MS Excel
In Microsoft Office Excel 2007, you will find a style gallery in the Ribbon. A cell style combines a preset font format, a cell background, and borders. To apply a cell style to a cell:
1. Click the Insert tab on the Ribbon.
2. In the Links section, click Hyperlink.
3. In the Address box, type the URL of the Web page to which you want to link.
NOTE: You can also use the controls in the Insert Hyperlink dialog box to create hyperlinks to locations within the current workbook or to other documents, and links that can be used to send an e-mail message.
In Microsoft Office Excel 2007, you will find a style gallery in the Ribbon. A cell style combines a preset font format, a cell background, and borders. To apply a cell style to a cell:
1. Click the Insert tab on the Ribbon.
2. In the Links section, click Hyperlink.
3. In the Address box, type the URL of the Web page to which you want to link.
NOTE: You can also use the controls in the Insert Hyperlink dialog box to create hyperlinks to locations within the current workbook or to other documents, and links that can be used to send an e-mail message.
How to Automatically Update Data (Such as User Information) Throughout Your Document
Automatically Update Data (Such as User Information) Throughout Your Document
Content controls, a new feature in Microsoft Office Word 2007, provide the ability to structure content in a document—similar to, but with more flexibility than, traditional form controls. Among other uses, content controls enable you to bind text in your document to data sources, such as file properties or Windows SharePoint Services properties. In fact, some built-in content controls called Document Property Quick Parts are set to automatically bind to your information. As a result, if you insert a Document Property Quick Part—such as the author name or the document title—into your document, that information will automatically update in the document when it changes in file properties.
To insert a Document Property Quick Part into your document, on the Insert tab, in the Text group, click Quick Parts, point to Document Property, and then click to insert the type of property you need from the options listed.
Note that if you insert several of the same type of control (such as Title) in the same document, the text in all of those controls will update to match if any one of them is changed. Also note that some types of document building blocks (such as a cover page or a header that you can insert from applicable galleries on the Insert tab) contain Document Property Quick Parts.
Content controls, a new feature in Microsoft Office Word 2007, provide the ability to structure content in a document—similar to, but with more flexibility than, traditional form controls. Among other uses, content controls enable you to bind text in your document to data sources, such as file properties or Windows SharePoint Services properties. In fact, some built-in content controls called Document Property Quick Parts are set to automatically bind to your information. As a result, if you insert a Document Property Quick Part—such as the author name or the document title—into your document, that information will automatically update in the document when it changes in file properties.
To insert a Document Property Quick Part into your document, on the Insert tab, in the Text group, click Quick Parts, point to Document Property, and then click to insert the type of property you need from the options listed.
Note that if you insert several of the same type of control (such as Title) in the same document, the text in all of those controls will update to match if any one of them is changed. Also note that some types of document building blocks (such as a cover page or a header that you can insert from applicable galleries on the Insert tab) contain Document Property Quick Parts.
How to Change Classic Start Menu in MS Vista
Classic Start Menu in MS Vista
As you transition your skills and knowledge from previous versions of Windows, you might want to fall back on the classic Start menu configuration.
1. Right-click the Windows Vista Start button.
2. Click Properties.
3. Click the Classic Start menu option.
4. Click OK.
As you transition your skills and knowledge from previous versions of Windows, you might want to fall back on the classic Start menu configuration.
1. Right-click the Windows Vista Start button.
2. Click Properties.
3. Click the Classic Start menu option.
4. Click OK.
How to Create Multiple Calendars for Different Purposes in MS Out Look
Create Multiple Calendars for Different Purposes in MS Out Look
In addition to the default Microsoft Office Outlook calendar, you can create other Outlook calendars. You might want a separate calendar for your personal appointments, for example.
To open a new calendar:
1. On the File menu, point to New, and then click Folder. (There's a keyboard shortcut for this too: CTRL+SHIFT+E.)
2. In the Create New Folder dialog box that appears, type a name for the folder in the Name box.
3. In the Folder contains list, click Calendar Items.
4. In the Select where to place the folder list, select Calendar, and then click OK.
In addition to the default Microsoft Office Outlook calendar, you can create other Outlook calendars. You might want a separate calendar for your personal appointments, for example.
To open a new calendar:
1. On the File menu, point to New, and then click Folder. (There's a keyboard shortcut for this too: CTRL+SHIFT+E.)
2. In the Create New Folder dialog box that appears, type a name for the folder in the Name box.
3. In the Folder contains list, click Calendar Items.
4. In the Select where to place the folder list, select Calendar, and then click OK.
How to Excel Services in 2003 to 2007
2003 to 2007 Excel Services
Microsoft Office Excel 2003 lists are called tables in Microsoft Office Excel 2007. Just as you can convert a data range to a list in Excel 2003, you can format a data range as a table in Excel 2007 by using the Format as Table command in the Styles section of the Home tab. Excel 2003 lists can be published to Windows SharePoint Services 2.0 sites and viewed in Windows Internet Explorer, so that you can share your data with others without having to share your entire worksheet.
With Excel 2007 and Microsoft Office SharePoint Server 2007, you can publish Excel tables to Excel Services, so that you can share Excel information through the browser by using Microsoft Office Excel Web Access. Excel Web Access presents the information in an Excel-like view rather than the list view of Windows SharePoint Services 2.0. This view enables the people you are sharing with to work in a familiar environment, even manipulating certain sets of data in the browser, without having access to any proprietary information contained in other parts of the worksheet.
To publish an Excel 2007 table to Excel Services, you must first save the worksheet to a Windows SharePoint Services 3.0 document library. Here’s how:
1. Open the online file, click the Office button, and point to Publish.
2. Click Excel Services, and then click Excel Services Options.
3. On the Show tab, click the drop-down arrow, click Sheets, and then select the individual sheets that you want to publish.
4. Click OK, and then save the file.
Microsoft Office Excel 2003 lists are called tables in Microsoft Office Excel 2007. Just as you can convert a data range to a list in Excel 2003, you can format a data range as a table in Excel 2007 by using the Format as Table command in the Styles section of the Home tab. Excel 2003 lists can be published to Windows SharePoint Services 2.0 sites and viewed in Windows Internet Explorer, so that you can share your data with others without having to share your entire worksheet.
With Excel 2007 and Microsoft Office SharePoint Server 2007, you can publish Excel tables to Excel Services, so that you can share Excel information through the browser by using Microsoft Office Excel Web Access. Excel Web Access presents the information in an Excel-like view rather than the list view of Windows SharePoint Services 2.0. This view enables the people you are sharing with to work in a familiar environment, even manipulating certain sets of data in the browser, without having access to any proprietary information contained in other parts of the worksheet.
To publish an Excel 2007 table to Excel Services, you must first save the worksheet to a Windows SharePoint Services 3.0 document library. Here’s how:
1. Open the online file, click the Office button, and point to Publish.
2. Click Excel Services, and then click Excel Services Options.
3. On the Show tab, click the drop-down arrow, click Sheets, and then select the individual sheets that you want to publish.
4. Click OK, and then save the file.
How to Manage Resources in Office Project
Managing Resources in Office Project
When you start assigning resources to tasks in Microsoft Office Project, the durations of the tasks automatically change. To understand why, you need to understand how Project allocates resources.
Project follows one formula for all internal resourcing calculations: Work = Duration × Resources. In other words, if two men take two hours to mow a lawn, one man will take four hours, or four men will take one hour, to mow the same lawn. Now you know why task durations constantly change if you add or remove the resources allocated to those tasks.
You can stop Project from recalculating time schedules in this way by configuring it to keep one parameter fixed and calculate just the others.
1. Open the task's properties.
2. On the Advanced tab, configure the task type as being Fixed Duration, Fixed Work, or Fixed Units (that is, resources). By changing this setting, you can tell Project what parameters in the equation should remain the same, no matter what changes you make to the task.
When you start assigning resources to tasks in Microsoft Office Project, the durations of the tasks automatically change. To understand why, you need to understand how Project allocates resources.
Project follows one formula for all internal resourcing calculations: Work = Duration × Resources. In other words, if two men take two hours to mow a lawn, one man will take four hours, or four men will take one hour, to mow the same lawn. Now you know why task durations constantly change if you add or remove the resources allocated to those tasks.
You can stop Project from recalculating time schedules in this way by configuring it to keep one parameter fixed and calculate just the others.
1. Open the task's properties.
2. On the Advanced tab, configure the task type as being Fixed Duration, Fixed Work, or Fixed Units (that is, resources). By changing this setting, you can tell Project what parameters in the equation should remain the same, no matter what changes you make to the task.
How to Use Follow-ups on Sent E-Mail Messages in MS Out Look
Use Follow-ups on Sent E-Mail Messages in MS Out Look
You're probably used to setting follow-up flags on e-mail messages in your Inbox. Until now, though, there wasn't much point setting follow-up flags on sent e-mail messages, because you rarely view your Sent Items folder. Yet it's often useful to set a follow-up flag on a sent e-mail message; for example, a sales e-mail message might warrant following up after a couple of days. It's now worth setting follow-up flags on sent e-mail messages, because they will appear on the To-Do Bar.
To do this:
1. Click the Follow Up flag on the Message tab of the Ribbon when writing your message.
2. Click the follow-up flag you want to use, or set a reminder for the e-mail's recipients.
You can customize the follow-up flag. When you set your flag, some basic options like Today and Tomorrow are instantly available, but if you click Custom, plenty more follow-up options appear. These include start and end times for the follow-up and required activities. All this information will appear on your To-Do Bar
You're probably used to setting follow-up flags on e-mail messages in your Inbox. Until now, though, there wasn't much point setting follow-up flags on sent e-mail messages, because you rarely view your Sent Items folder. Yet it's often useful to set a follow-up flag on a sent e-mail message; for example, a sales e-mail message might warrant following up after a couple of days. It's now worth setting follow-up flags on sent e-mail messages, because they will appear on the To-Do Bar.
To do this:
1. Click the Follow Up flag on the Message tab of the Ribbon when writing your message.
2. Click the follow-up flag you want to use, or set a reminder for the e-mail's recipients.
You can customize the follow-up flag. When you set your flag, some basic options like Today and Tomorrow are instantly available, but if you click Custom, plenty more follow-up options appear. These include start and end times for the follow-up and required activities. All this information will appear on your To-Do Bar
How to Enter a Series of Data Using Fill Series in MS Excel
To Enter a Series of Data Using Fill Series in MS Excel
1. Type the first value in the series into a cell.
2. Type the second value into a cell below or to the right of the first cell.
3. Select the cells.
4. Drag the Fill Handle (a black square that appears at the bottom right corner of the last selected cell) over the cells into which you want to extend the series.
1. Type the first value in the series into a cell.
2. Type the second value into a cell below or to the right of the first cell.
3. Select the cells.
4. Drag the Fill Handle (a black square that appears at the bottom right corner of the last selected cell) over the cells into which you want to extend the series.
How to Use Messaging in MS Office Grove
Using Messaging in MS Office Grove
Microsoft Office Groove 2007 includes a basic messaging feature that you can use to send quick text or voice messages to one or more contacts outside a workspace.
1. Double-click any contact name in any workspace or from the Launchbar.
2. Optionally, add additional contacts by clicking Add More. Type your message, and then click Send.
Messages appear as pop-up windows above the Office Groove 2007 icon on the Windows taskbar, and are delivered rapidly if recipients are online. Offline recipients receive messages when they go online.
Note: After you’ve closed a message, you can access it again in your Message History. Click the icon in the lower-left corner of the Launchbar or any workspace.
Microsoft Office Groove 2007 includes a basic messaging feature that you can use to send quick text or voice messages to one or more contacts outside a workspace.
1. Double-click any contact name in any workspace or from the Launchbar.
2. Optionally, add additional contacts by clicking Add More. Type your message, and then click Send.
Messages appear as pop-up windows above the Office Groove 2007 icon on the Windows taskbar, and are delivered rapidly if recipients are online. Offline recipients receive messages when they go online.
Note: After you’ve closed a message, you can access it again in your Message History. Click the icon in the lower-left corner of the Launchbar or any workspace.
Senin, 15 September 2008
How to Synchronize with Outlook
Synchronize with Outlook
Two-way synchronization with Microsoft Office Outlook 2003 and Microsoft Office Outlook 2007 enables you to link information between Microsoft Office OneNote 2007 and Outlook so that you can more easily manage your tasks and contacts, and keep track of meeting details.
To create a task in Office OneNote 2007 that will synchronize with Office Outlook 2007:
1. Click the note that you want to make into a task.
2. On the standard toolbar, click the Notes About This Item button.
3. Switch to the Unfiled Notes section of OneNote. You will find the contact or calendar information on a page, on which you can take further notes, with a link back to the contact or calendar item in Outlook. Even if you move this page in your notebook, OneNote will maintain the link with the Outlook contact.
Two-way synchronization with Microsoft Office Outlook 2003 and Microsoft Office Outlook 2007 enables you to link information between Microsoft Office OneNote 2007 and Outlook so that you can more easily manage your tasks and contacts, and keep track of meeting details.
To create a task in Office OneNote 2007 that will synchronize with Office Outlook 2007:
1. Click the note that you want to make into a task.
2. On the standard toolbar, click the Notes About This Item button.
3. Switch to the Unfiled Notes section of OneNote. You will find the contact or calendar information on a page, on which you can take further notes, with a link back to the contact or calendar item in Outlook. Even if you move this page in your notebook, OneNote will maintain the link with the Outlook contact.
Senin, 08 September 2008
How to Safe Senders and Junk E-Mail in MS Out Look
Safe Senders and Junk E-Mail in MS Out Look
In Microsoft Office Outlook 2007, you can add e-mail addresses to a safe recipients list. Messages received from safe recipients, and messages you send to them, will then never be treated as junk e-mail. Here’s how:
1. In an Outlook 2007 mail folder, right-click a message sent to you by the person you want to identify as a safe recipient.
2. Point to Junk E-mail, and then click Add Recipient to Safe Recipients List.
In Microsoft Office Outlook 2007, you can add e-mail addresses to a safe recipients list. Messages received from safe recipients, and messages you send to them, will then never be treated as junk e-mail. Here’s how:
1. In an Outlook 2007 mail folder, right-click a message sent to you by the person you want to identify as a safe recipient.
2. Point to Junk E-mail, and then click Add Recipient to Safe Recipients List.
How to Apply Formatting from Any 2007 Office Release Document to Any Other in Office
Apply Formatting from Any 2007 Office Release Document to Any Other in Office
You may already know that you can use Document Themes to apply consistent fonts, colors, and graphic effects all at once throughout your 2007 Microsoft Office release Word, Excel, or PowerPoint document. But did you know that you can apply the theme formatting from any 2007 release Word, Excel, or PowerPoint file to any other?
To do this, on the Page Layout tab (in Word or Excel) or the Design tab (in PowerPoint), click to expand the Themes gallery, and then click Browse for Themes. You can then choose any 2007 release Word, Excel, or PowerPoint file (or any theme file) and apply its theme formatting to your active document.
You may already know that you can use Document Themes to apply consistent fonts, colors, and graphic effects all at once throughout your 2007 Microsoft Office release Word, Excel, or PowerPoint document. But did you know that you can apply the theme formatting from any 2007 release Word, Excel, or PowerPoint file to any other?
To do this, on the Page Layout tab (in Word or Excel) or the Design tab (in PowerPoint), click to expand the Themes gallery, and then click Browse for Themes. You can then choose any 2007 release Word, Excel, or PowerPoint file (or any theme file) and apply its theme formatting to your active document.
How to Change the Desktop Appearance in MS Vista
Changing the Desktop Appearance in MS Vista
The easiest way to change the look of the Windows Vista desktop is through personalization. Here’s how:
1. Right-click the desktop.
2. Click Personalize, and then begin customizing to fit your style.
The easiest way to change the look of the Windows Vista desktop is through personalization. Here’s how:
1. Right-click the desktop.
2. Click Personalize, and then begin customizing to fit your style.
How to Select Shapes Using the SmartArt Text Pane in MS Power Point
Select Shapes Using the SmartArt Text Pane in MS Power Point
When editing a SmartArt graphic, you can edit the text directly in the diagram shapes or in the SmartArt text pane. You can also select shapes just by selecting their associated text in the text pane.
To do this, click into your SmartArt graphic. If the text pane does not automatically appear, click the arrow icons that appear on the left edge of the diagram selection frame. Then either click into a bulleted paragraph in the text pane to select the related shape, or drag your insertion point to select text in several bulleted paragraphs in order to select multiple shapes. You can also hold the CTRL key while dragging to select non-contiguous paragraphs.
Note that you can use the text pane to select shapes whether your SmartArt graphic is in the 2007 release of Microsoft Office PowerPoint, Word, or Excel.
When editing a SmartArt graphic, you can edit the text directly in the diagram shapes or in the SmartArt text pane. You can also select shapes just by selecting their associated text in the text pane.
To do this, click into your SmartArt graphic. If the text pane does not automatically appear, click the arrow icons that appear on the left edge of the diagram selection frame. Then either click into a bulleted paragraph in the text pane to select the related shape, or drag your insertion point to select text in several bulleted paragraphs in order to select multiple shapes. You can also hold the CTRL key while dragging to select non-contiguous paragraphs.
Note that you can use the text pane to select shapes whether your SmartArt graphic is in the 2007 release of Microsoft Office PowerPoint, Word, or Excel.
How To Enter the Same Value into Multiple Cells Simultaneously in MS Excel
To Enter the Same Value into Multiple Cells Simultaneously in MS Excel
1. Select the cells into which you want to enter the value.
2. Type the value in the active cell.
3. Press CTRL+ENTER.
1. Select the cells into which you want to enter the value.
2. Type the value in the active cell.
3. Press CTRL+ENTER.
How to Customize Where Building Blocks Are Inserted in Your Document (Such as Cover Pages) in MS Word
Customize Where Building Blocks Are Inserted in Your Document (Such as Cover Pages) in MS Word
You may have already used the document building blocks functionality in Microsoft Office Word 2007 to insert complete, formatted document components, such as a cover page or table of contents, with just a click. You may also have noticed that when you click to insert some types of building blocks, your selection is automatically added to a specific place in the document, such as the first page, in the case of a cover page.
But what if you want more than one of the same type of building block in the document, perhaps at a different position? Many types of building blocks provide the option to insert additional entries at specified points in the document. Instead of clicking to insert your selection, right-click for a set of options. For example, right-click an entry in the Cover Page gallery (on the Insert tab) for the options to insert the selected cover page at the beginning or end of the document or section, or at your current position in the document.
You may have already used the document building blocks functionality in Microsoft Office Word 2007 to insert complete, formatted document components, such as a cover page or table of contents, with just a click. You may also have noticed that when you click to insert some types of building blocks, your selection is automatically added to a specific place in the document, such as the first page, in the case of a cover page.
But what if you want more than one of the same type of building block in the document, perhaps at a different position? Many types of building blocks provide the option to insert additional entries at specified points in the document. Instead of clicking to insert your selection, right-click for a set of options. For example, right-click an entry in the Cover Page gallery (on the Insert tab) for the options to insert the selected cover page at the beginning or end of the document or section, or at your current position in the document.
How to Look Up People Mentioned in E-Mail Messages in Ms OutLook
Look Up People Mentioned in E-Mail Messages in Ms OutLook
Here is a common situation: You are reading a long mail thread in the Microsoft Office Outlook preview pane. Because it is a long thread, people have been added and removed from the thread as the e-mail conversation has been passed along. You see the name of a person whom you want to send e-mail to, call, or chat with. But the name is not on the active To or Cc line of the e-mail message, so you have no hyperlinked contact information.
In that case, you can select the full name, right-click, and then click Who Is. If the name appears in your address book, the Outlook Properties window for that person will appear. From there, you can easily find an e-mail address or phone number, or add the person to your instant messaging contacts by clicking Actions.
Here is a common situation: You are reading a long mail thread in the Microsoft Office Outlook preview pane. Because it is a long thread, people have been added and removed from the thread as the e-mail conversation has been passed along. You see the name of a person whom you want to send e-mail to, call, or chat with. But the name is not on the active To or Cc line of the e-mail message, so you have no hyperlinked contact information.
In that case, you can select the full name, right-click, and then click Who Is. If the name appears in your address book, the Outlook Properties window for that person will appear. From there, you can easily find an e-mail address or phone number, or add the person to your instant messaging contacts by clicking Actions.
How to Compare Versions 2003 to 2007
2003 to 2007 Compare Versions
In Windows SharePoint Services 2.0 and Windows SharePoint Services 3.0, document libraries have the ability to track document versions. However, versioning must first be enabled in the document library settings. After you enable versioning, you can click the document menu, and then click Version History to open each version of a particular document.
With Microsoft Office Word 2007, you can use the Compare feature to compare online document versions and see exactly what changes were made.
1. Click the Review tab, and then click the Compare button.
2. Click Compare, click Compare again, and choose the original document and the revised version that you want to compare. Depending on the type of versioning enabled in the document library, you can compare the open version against the last version, the last major version, or any specific version saved to the server.
In Windows SharePoint Services 2.0 and Windows SharePoint Services 3.0, document libraries have the ability to track document versions. However, versioning must first be enabled in the document library settings. After you enable versioning, you can click the document menu, and then click Version History to open each version of a particular document.
With Microsoft Office Word 2007, you can use the Compare feature to compare online document versions and see exactly what changes were made.
1. Click the Review tab, and then click the Compare button.
2. Click Compare, click Compare again, and choose the original document and the revised version that you want to compare. Depending on the type of versioning enabled in the document library, you can compare the open version against the last version, the last major version, or any specific version saved to the server.
How to Create a Workspace in Office Groove
Creating a Workspace in Office Groove
Each Microsoft Office Groove workspace is a separate window, opened from the Launchbar, which contains people's names, tools, and information. The number and variety of tools in each workspace depend on the tasks you are trying to accomplish with your team members.
You can create workspaces from the Launchbar or from the File menu.
1. From the Launchbar Workspaces tab, click New Workspace. Or from the File menu, point to New, and then click Workspace.
2. Type a descriptive name for your workspace.
3. Select the type of workspace that you want. There are three different types to choose from depending on your team’s needs.
Each Microsoft Office Groove workspace is a separate window, opened from the Launchbar, which contains people's names, tools, and information. The number and variety of tools in each workspace depend on the tasks you are trying to accomplish with your team members.
You can create workspaces from the Launchbar or from the File menu.
1. From the Launchbar Workspaces tab, click New Workspace. Or from the File menu, point to New, and then click Workspace.
2. Type a descriptive name for your workspace.
3. Select the type of workspace that you want. There are three different types to choose from depending on your team’s needs.
How to See that How a Query Is Progressing
See How a Query Is Progressing in MS office Excel
Because Microsoft Office Excel 2007 can now display more than 1 million rows in a spreadsheet, you can run queries that return a lot of data and therefore take a long time. By setting a query to refresh in the background, you can still work in Excel while data is being retrieved.
On the left side of the status bar is a little spinning globe, which lets you know that the query is still running. Clicking the globe opens a dialog box where you can see the queries that are being executed in the background, how long they have been running, and how many records have been returned so far. You can even stop the query if you want to.
Because Microsoft Office Excel 2007 can now display more than 1 million rows in a spreadsheet, you can run queries that return a lot of data and therefore take a long time. By setting a query to refresh in the background, you can still work in Excel while data is being retrieved.
On the left side of the status bar is a little spinning globe, which lets you know that the query is still running. Clicking the globe opens a dialog box where you can see the queries that are being executed in the background, how long they have been running, and how many records have been returned so far. You can even stop the query if you want to.
How to See More in the To-Do Bar in MS Outlook
See More in the To-Do Bar in MS Outlook
The To-Do Bar is extremely flexible; you can customize it to your needs. Click View, click To-Do Bar, and then click Options. From here you can turn elements of the To-Do Bar on or off, and also select how many appointments you want to see. This is useful on busy days with multiple appointments, because you can see them all at a glance.
The To-Do Bar is extremely flexible; you can customize it to your needs. Click View, click To-Do Bar, and then click Options. From here you can turn elements of the To-Do Bar on or off, and also select how many appointments you want to see. This is useful on busy days with multiple appointments, because you can see them all at a glance.
How to use 2003 to 2007 Custom Slide Layout
2003 to 2007 Custom Slide Layout
The Slide Layout task pane in Microsoft Office PowerPoint 2003 provides a number of different options for structuring your slide layout. But what if you need something a little more customized? You can create a blank slide and manually insert text boxes, charts, and pictures, but there's no easy way to reuse the same layout later in the presentation.
In Microsoft Office PowerPoint 2007, you can add custom layouts to the slide master, making your new layout available to you any time you need it.
1. Click the View tab, and then click Slide Master in the Presentation Views section.
2. Click Insert Layout, and then use the Insert Placeholder button to add content placeholders to your layout.
3. Right-click the layout and rename it to something easy to remember.
4. Click Close Master View to return to your presentation.
5. To apply your new layout, click the Layout list in the Slides section of the Home tab, and then click your layout.
The Slide Layout task pane in Microsoft Office PowerPoint 2003 provides a number of different options for structuring your slide layout. But what if you need something a little more customized? You can create a blank slide and manually insert text boxes, charts, and pictures, but there's no easy way to reuse the same layout later in the presentation.
In Microsoft Office PowerPoint 2007, you can add custom layouts to the slide master, making your new layout available to you any time you need it.
1. Click the View tab, and then click Slide Master in the Presentation Views section.
2. Click Insert Layout, and then use the Insert Placeholder button to add content placeholders to your layout.
3. Right-click the layout and rename it to something easy to remember.
4. Click Close Master View to return to your presentation.
5. To apply your new layout, click the Layout list in the Slides section of the Home tab, and then click your layout.
How to To Change the Color of a Sheet Tab in MS excel
To Change the Color of a Sheet Tab in MS excel
1. Right-click the sheet tab.
2. Click Tab Color.
3. Click the color from the palette that appears.
1. Right-click the sheet tab.
2. Click Tab Color.
3. Click the color from the palette that appears.
How to Collect Data via E-Mail in MS Access
Collecting Data via E-Mail in MS Access
Microsoft Office Access 2007 simplifies the process of collecting information from others. It builds the data collection form automatically by using Microsoft Office InfoPath 2007 or HTML in the body of an e-mail message. Microsoft Office Outlook 2007 processes the incoming forms and helps you save the data in your Office Access 2007 data store—effectively updating the database without retyping.
To collect new information via e-mail:
1. Open or select the table containing the fields that you want to collect.
2. On the External Data tab, click Create E-mail.
3. Follow the wizard to create an e-mail form.
a. Select HTML or InfoPath form (if you select the latter, the recipients must have Office InfoPath 2007 and Office Outlook 2007 deployed).
b. Select Automatically process replies and add data to Table if you don’t have to approve each entry before it is saved in the database.
Returned forms will go to a newly created folder named Access Data Collections in your Inbox in Office Outlook 2007. Each time you receive a filled form, it will be flagged as a task for you to review.
To export collected data to Access:
1. If you have not selected automatic processing, right-click the returned e-mail message, and then click Export to Access. Or you can open the message and click the same command from the Ribbon.
2. Green or red icons will flag whether the export was successful or not.
After sending a data collection e-mail message, you can use the Manage Replies command on the External Data tab of the Ribbon to change some of the message options and resend the message.
Microsoft Office Access 2007 simplifies the process of collecting information from others. It builds the data collection form automatically by using Microsoft Office InfoPath 2007 or HTML in the body of an e-mail message. Microsoft Office Outlook 2007 processes the incoming forms and helps you save the data in your Office Access 2007 data store—effectively updating the database without retyping.
To collect new information via e-mail:
1. Open or select the table containing the fields that you want to collect.
2. On the External Data tab, click Create E-mail.
3. Follow the wizard to create an e-mail form.
a. Select HTML or InfoPath form (if you select the latter, the recipients must have Office InfoPath 2007 and Office Outlook 2007 deployed).
b. Select Automatically process replies and add data to Table if you don’t have to approve each entry before it is saved in the database.
Returned forms will go to a newly created folder named Access Data Collections in your Inbox in Office Outlook 2007. Each time you receive a filled form, it will be flagged as a task for you to review.
To export collected data to Access:
1. If you have not selected automatic processing, right-click the returned e-mail message, and then click Export to Access. Or you can open the message and click the same command from the Ribbon.
2. Green or red icons will flag whether the export was successful or not.
After sending a data collection e-mail message, you can use the Manage Replies command on the External Data tab of the Ribbon to change some of the message options and resend the message.
How to Generate Random Text in Word 2007
Generate Random Text in Word 2007
On a blank line in a Microsoft Office Word document, type =rand followed by (PC,SC)—where PC stands for paragraph count and SC stands for sentence count—and then press ENTER. For example, =rand(2,3) will create two paragraphs of three sentences each.
Word inserts some random text based on your specification. You can use this new text for testing form controls such as text boxes or paragraph alignments.
On a blank line in a Microsoft Office Word document, type =rand followed by (PC,SC)—where PC stands for paragraph count and SC stands for sentence count—and then press ENTER. For example, =rand(2,3) will create two paragraphs of three sentences each.
Word inserts some random text based on your specification. You can use this new text for testing form controls such as text boxes or paragraph alignments.
Langganan:
Postingan (Atom)