How to Apply a Sum or Other Function to Every Row in a Data Range in One Step MS Excel

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.