Its My Computer

How to Upgrade Old Documents to 2007 Versions

2009-06-05T10:13:00.000-07:00

127. How to Create Tables to Your Own Specifications
128. How to Upgrade Old Documents to 2007 Versions
129. How to Find Tooltips for Keyboard Shortcuts

127. Create Tables to Your Own Specifications
Want to add a table with specific dimensions to your Word document? Here’s how:
1. Position the cursor on the area of the document where you want to insert your table.
2. On the Insert tab of the Ribbon, click Table, and then click Draw Table.
3. Define the table size. Right-click to select the area where you want the table to appear.
4. Use the mouse to draw the internal table lines the way you want them. To erase any lines you've drawn by mistake, press the SHIFT key, and the pointer will change from a pencil to an eraser.
Note: The design tools in Microsoft Office Word 2007 give you plenty more features—for example, the ability to create other tables within those you've already designed.

128. Upgrade Old Documents to 2007 Versions
If you receive a document from a colleague who is not yet running the 2007 Microsoft Office system, the 2007 Office system will automatically open it in Compatibility Mode. However, not all the new features will be available to you. When you close the document, it will be saved in its original format, not in the format of the 2007 release.
If you want to upgrade the file to the 2007 Office system:
1. Click the Office button, and then click Convert.
2. In the Microsoft Office Word dialog box, click OK, and then click Save.
Note: You may want to make a backup copy of the file before you upgrade it. Also, to see when you are working in Compatibility Mode, look at the top of the screen. The phrase Compatibility Mode will appear in brackets to the right of the file name.

129. Find Tooltips for Keyboard Shortcuts
If you press and hold the ALT key, tooltips appear above the commands at the top of the page. You can then press the appropriate letter for a simple keyboard shortcut.

How to Derive a Strategic Value Score for Projects

2009-06-05T10:08:00.000-07:00

124. How To use Task Updates and Timesheet Submittal and Approval
125. How to Derive a Strategic Value Score for Projects
126. How to Create a Project Proposal

124. Task Updates and Timesheet Submittal and Approval
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.

125. Derive a Strategic Value Score for Projects
You can use the intuitive Prioritization Wizard in Portfolio Optimizer to derive a strategic value score for projects. Here’s how:
1. In the Builder Scorecard, select an organization, and then in the main navigation bar, click Optimizer.
2. Click the Analyze link to open the Open Dialog page in the Prioritization Wizard.
3. Select a completed pair-wise comparison matrix and impact matrix, and then start the Prioritization Wizard.
4. Click the button to automatically derive the business driver priorities.
5. Click the button to open the project to business driver impact matrix.
6. Click the button to automatically derive a strategic value score for each project.

126. Create a Project Proposal
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 with 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 Move PowerPoint Pictures Around Quickly

2009-06-01T23:52:00.000-07:00

121. How to Move PowerPoint Pictures Around Quickly
122. How to Add More Levels of Undo
123. How I can Turn Any 2-D Shape into a 3-D Object

121. Move PowerPoint Pictures Around Quickly
Microsoft Office PowerPoint 2007 removes the hassle normally involved in adjusting the size and position of overlapping images on slides. You can simply drag one picture over another. The top picture will become transparent, so that you can position it accurately over the other.

122. Add More Levels of Undo
You can go back farther in Microsoft Office PowerPoint to undo actions.
1. With PowerPoint open, click the Office button, and then click PowerPoint Options.
2. On the Advanced tab, change the Maximum number of undos from the default 20 to any number from 3 to 150.

123. Turn Any 2-D Shape into a 3-D Object
Want to convert a flat shape in Microsoft Office PowerPoint 2007 into a 3-D object? Here’s how:
1. With a slide open, click the Insert tab, and then select any shape from the Shapes ribbon. Alternately, select a shape you have created yourself.
2. Click the slide's surface to add the shape to the slide.
3. Right-click the shape, and then click Format Shape.
4. Select a solid or gradient fill. This step is not required but will enhance the 3-D look of your object.
5. Transform your shape into a 3-D object. You can add depth, bevel, contour, and surface type via the 3-D Format tab.
6. Give perspective to your 3-D shape. Rotate the object via the 3-D Rotation tab.

How I can Attach Files to Pages of Notes in Notebook

2009-05-03T20:00:00.000-07:00

118. How To Use Taking Mobile Notes
119. How To Attach Files to Pages of Notes in Your Notebook
120. How To Record Audio and Video Clips

118. Taking Mobile Notes
Microsoft Office OneNote 2007 provides two-way synchronization with Windows Mobile–powered Smartphones or Pocket PCs so that you can stay productive no matter where you are.

To synchronize Office OneNote 2007 with your mobile device:
1. Connect the device to your computer. Microsoft ActiveSync starts.
2. When prompted, download Microsoft Office OneNote Mobile to your device.
3. Take notes on your mobile device.
4. The next time you connect your mobile device to your computer and open OneNote, the notes you took will be copied to the OneNote Mobile Notes notebook in OneNote. Information you put in the Mobile Notes notebook will be viewable on your device.

119.Attach Files to Pages of Notes in Your Notebook
You can drag or insert files onto a page in your notebook. The file appears as an icon, as in Windows Explorer, and Microsoft Office OneNote keeps track of the location of the original file (even if you move it around), so you can easily open it at any time.
1. Drag the file that you want to attach from Windows Explorer onto a OneNote page.
2. When you release the mouse button, you’ll see a dialog box. Select the Insert a copy of the file onto the page check box.
3. To open the file, double-click the file icon.

120. Record Audio and Video Clips
With your computer’s internal microphone or an external microphone attached to your computer, or a webcam or its equivalent, you can record audio and video clips by using Microsoft Office OneNote. The audio will be linked to your typed or digitally handwritten notes, so you can easily jump to specific points in the recordings by clicking the relevant typed notes.

To record audio or video clips:
1. Attach the recording device to your computer (not necessary if you're using the internal microphone on your computer).
2. Click the page on which you want to create the recording.
3. On the Insert menu, click Audio Recording or Video Recording.
4. Start and stop the recording by using the Audio and Video Recording toolbar.
5. To play back the recording, double-click the Windows Media icon on the page where you made the recording. You can skip to certain points in the recording by clicking a word in your linked text notes, and then clicking Play in the margin.

How i can Use my Own Pictures in SmartArt

2009-04-22T18:31:00.000-07:00

115. How to Reuse Slides from a Slide Library
116. How to Use Your Own Pictures in SmartArt
117. how to Save PowerPoint Picture to Picture Files

115. Reuse Slides from a Slide Library
When you create a presentation, you may want to reuse slides already created and published by someone else in your organization. Microsoft Office PowerPoint can optionally notify you when the original slide is updated by its creator and synchronize the updated slide.
1. On the Home tab, click the New Slide icon. (Note: You must click the lower half of the icon to choose the types of slide that you want to insert.)
2. Click Reuse Slides at the bottom of the New Slide gallery.
3. In the text box below Insert slide from, type the Web address of the Microsoft SharePoint slide library that contains the slides that you want to reuse. PowerPoint retrieves a list of slides available from this location. Notice that as you pause on each of the slides, you can get a more detailed look at its contents.
4. Click a slide that you want to add to your presentation. If you want to be notified if this slide changes, select the Tell me when this slide changes text box.

116. Use Your Own Pictures in SmartArt
You can insert your own pictures into Microsoft SmartArt graphics in your presentation.
1. Click the Insert tab on the Ribbon, click SmartArt, and then click the SmartArt graphic that you want to insert.
2. Select the picture that you want to add to your presentation.
3. Right-click an individual shape in SmartArt, and then click Paste to insert the picture you selected.
4. Repeat steps 2 and 3 for each shape.
5. Complete your presentation by applying your preferred background design.

117. Save PowerPoint Picture to Picture Files
To save a picture from a Microsoft Office PowerPoint 2007 presentation in any popular picture format:
Right-click the image, click Save as, and then click Picture.

How i can use Windows Mail

2009-04-22T18:21:00.000-07:00

112. How to Navigation with the Address Bar
113. How to use Command Prompt
114. How to use Windows Mail

112. Navigation with the Address Bar
After you open a folder in Windows Vista, you will see the address bar at the top of the Explorer. Each folder is part of the hierarchical structure of your system. The top level is your computer, desktop, and so on. Under the top level is the user level, and user folders are under that level. The address bar shows this structure from left to right; with each level, you can use a flyout arrow to display and browse to the folder available on that level.

113. Command Prompt
You can run your programs via the command prompt as follows:
1. Click Start.
2. Type command in the Quick Search box.
3. Click Command prompt.
Alternately, you can simply type the program name in the Quick Search box, and use any parameters that may be required.

114. Windows Mail
Windows Vista includes a program that can provide you with communications and e-mail access. Although not as comprehensive as many e-mail and communication software packages, it does offer basic management capabilities.

Here’s how to access Windows Mail:
1. Click Start.
2. Click All Programs.
3. Click Windows Mail.

How I can Pre-define the Format for Pasting in Word 2007

2009-04-14T22:24:00.000-07:00

109. How to use Line Breaks Without Bullets
110. How to use Pre-define the Format for Pasting in Word 2007
111. How to Reuse Tables in Word

109. Line Breaks Without Bullets
When you're creating a bulleted or numbered list in Microsoft Office Word or Microsoft Office PowerPoint, you might want an item to appear in the list without a bullet or without incrementing the number. You can start a new line without a bullet by pressing SHIFT+ENTER. The next time you press the ENTER key, the new line will continue the bulleted or numbered list.

110. Pre-define the Format for Pasting in Word 2007
In a Microsoft Office Word 2003 document, each time you paste some text or an image, you can select the format (source formatting, destination formatting, or text only) by clicking the clipboard icon. In Microsoft Office Word 2007 and Microsoft Office Outlook 2007, you can still do this manually or, more conveniently, set the default paste formatting mode. Here’s how:
Go to Advanced Options or click the Set Default Paste option when the clipboard icon appears, and then set your preferences. The pasted text and images will now be formatted automatically according to your settings.

111. Reuse Tables in Word
To save a table in Microsoft Office Word for reuse in the future:
1. Select the table that you want to save.
2. On the Insert tab of the Ribbon, click Table, point to Quick Tables, and then click Save Selection to Quick Tables Gallery.
3. In the Create New Building Block dialog box, give the table a name, classify it with some basic parameters, and then click OK.

To reuse a saved table:
1. Position your cursor where you want to insert a saved table.
2. On the Ribbon, click Insert, click Table, and then point to Quick Tables.
3. From the list, click the table you saved previously. This table will now be inserted into the document.

How I can Derive a Strategic Value Score for Projects

2009-03-29T20:21:00.000-07:00

106. How to Create a Project Proposal
107. How to Derive a Strategic Value Score for Projects
108. How to Create a Resource Plan

106. Create a Project Proposal
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.

107. Derive a Strategic Value Score for Projects
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.

108. Create a Resource Plan
Resource managers and project managers can make resource assignments to projects that have not yet been fully developed, reducing the availability of the resource for project work. You can assign resources to projects by using the following steps:
1. In Microsoft Office Project Web Access, under the Projects section of the left Action pane, click Proposals and Activity Plans.
2. On the New menu, click Activity Plan.
3. Complete your new activity plan, and then click Save (or Publish).
4. After saving, click Resource Plan on the Activity Plan page.
5. Click Build Team, click Add, and then click Save to select resources for the project.
6. On the Resource Plan page, click View Options to define the date range, resource units, and utilization settings for the resource plan, and then click Apply.
7. Define the hours for each resource in the resource plan, and then click Save (or Publish).

How i can use Automatic Save

2009-03-29T20:17:00.000-07:00

103. How to Print Information into Office OneNote 2007
104. How to use Automatic Save
105. How to use Meeting Notes

103.Print Information into Office OneNote 2007
Use the Microsoft Office OneNote 2007 print driver to print any document as an image into your notebook. You can annotate printed documents in your notebook, similar to printing a document and taking notes on the paper printout. You can quickly find text within these documents printed to OneNote by performing a simple keyword search.
To print a document to OneNote:
1. Open the document, such as a Microsoft Office Word document or a Web page, that you want to print.
2. Click the Office button, point to Print, and click Print.
3. Select Send to Microsoft OneNote in the list of available printers.
4. Click Print.
5. Drag the resulting OneNote page to the relevant section of your notebook.

104. Automatic Save
Can’t find the Save button? There isn’t one. Microsoft Office OneNote 2007 automatically saves and backs up your notes as you type them. To customize backup options, click Tools, click Options, and then click Backup.

105. Meeting Notes
You can use a preformatted page template to easily collect meeting notes and more. To select a template, click the arrow next to the New Page tab.

How I can nsert a Predefined Table

2009-03-29T20:14:00.000-07:00

100. How to Use the Bcc Field in Outlook 2007
101. How to Insert a Predefined Table
102. How to Attach Multiple E-Mail Attachments Quickly in Microsoft Office Outlook 2007

100. How to Use the Bcc Field in Outlook 2007
In Microsoft Office Outlook 2007, click New to open a new e-mail message, and then click Show Bcc on the Options tab.

101. Inserting a Predefined Table
To insert a predefined table:
1. On the Ribbon, on the Create tab, click Table Templates.
2. Click a table template (Assets, Contacts, Issues, Tasks, or Events).

102. Attach Multiple E-Mail Attachments Quickly in Microsoft Office Outlook 2007
Here’s a quick way to save multiple files attached to an e-mail message.
1. Open the message, and then click Other Actions on the Ribbon.
2. Click Save Attachments. Hold down the SHIFT key while using the arrow keys to select the attachments that you want to save. Alternately, hold down the CTRL key and use your mouse to select the attachments that you want to save. Click OK.
3. Browse to a folder on your hard disk drive or to a document library on a Microsoft SharePoint site, and then click OK. The attachments will be saved to the new location.

How I can Send Contact Information in Read-Only Format

2009-03-29T20:10:00.000-07:00

97. How to Display More on the Screen by Changing Your View
98. How to Send Contact Information in Read-Only Format
99. How to View E mails by Conversation

97. Display More on the Screen by Changing Your View
You can change the view settings to display more on your screen. In Microsoft Office Outlook, click View, click Navigation Pane, and then click Minimized.

98. Send Contact Information in Read-Only Format
Sharing contact information is easy in Microsoft Office Outlook.
1. Find the contact whose business card details you want to send.
2. Right-click the business card, and then click Send as Business Card. Outlook opens an e-mail message with the card attached and also includes the card in the body of the message.
3. Address the message and click Send.

99. View E mails by Conversation
Usually, you see e-mail messages in the order in which they arrive. But if you need to read the background of a message, switch to Conversation view to see the rest of the thread.
In Microsoft Office Outlook 2007, click View, click Arrange By, and then click Conversation.
In Microsoft Office Outlook 2003, click View, and then click Arrange By Conversation.

How I can Check Address Book Entries

2009-03-29T19:58:00.000-07:00

94. Have Tasks Appear in Your Calendar on the Day You Want to Start Them
95. How to Check Address Book Entries
96. How to Find Related Messages

94. Have Tasks Appear in Your Calendar on the Day You Want to Start Them
By default, tasks appear in your calendar on the date when they are due. You might prefer to have them appear on the date when you should begin to work on them instead. To change when your tasks appear, click View, point to Daily Task List, point to Arrange By, and then click By Start Date.

95. Check Address Book Entries
Microsoft Office Outlook 2007 will try to check that e-mail names are correct by scanning the address book as you type your e-mail message. Other checks happen when you click Send. You can force Outlook to run its e-mail completeness check (and highlight any addresses that it doesn't recognize) simply by pressing ALT+K anytime.

96. Find 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 I can set Up a Shared Notebook in Office SharePoint Server

2009-03-29T19:53:00.000-07:00

91. What are the Quick Ways to Create or Populate Lists on a SharePoint List
92. How to Set Up a Shared Notebook in Office SharePoint Server
93. How to Sort Documents in SharePoint Libraries

91. 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.

92. Set Up a Shared Notebook in Office SharePoint Server
You can easily create a shared Microsoft Office OneNote notebook by following these steps:
1. On the File menu, click Share.
2. Click Create Shared Notebook. A wizard opens to prompt you through the remaining steps. Note that you’ll need the URL of the Microsoft SharePoint document library where you plan to store the notebook.

93. Sort Documents in SharePoint Libraries
You can change the default settings of your My SharePoint document libraries to sort by latest upload. You can then see at a glance what’s changed and what’s new.
1. Open your Microsoft SharePoint document library, and click Modify settings and columns under Actions in the task pane.
2. Under Views, click All Documents.
3. On the Edit View page, find the Sort section.
4. On the First sort by the column menu, click either Modified or Created, depending on whether documents will be uploaded once or changed and then uploaded again.
5. Select the Show items in descending order check box, and then click OK.

How I can Add or Remove Styles from the Quick Style Gallery

2009-03-27T21:07:00.000-07:00

88. How to Add or Remove Styles from the Quick Style Gallery
89. How to Quickly Know that How Many Lines or Words I Have Typed
90. How to Return to the Last Edit in a Microsoft Office Word Document

88. Add or Remove Styles from the Quick Style Gallery
The Styles gallery on the Home tab in Microsoft Office Word 2007 includes several built-in paragraph and character styles by default, such as Normal style, Heading styles 1 and 2, and Title. However, you can customize that gallery for any document or template to include just the paragraph and character styles you need to access most quickly.
To display the Styles pane, click the dialog launch icon in the lower-right corner of the Styles section (or press CTRL+SHIFT+ALT+S). To remove a style from the Quick Style Gallery, right-click the style name where it appears in the gallery, and then click Remove from Quick Style Gallery.
To add a style in the Styles pane to the Quick Style Gallery, right-click the style name, and then click Add to Quick Style Gallery. (Note that, if the style is already in the gallery, the option to remove the style from the gallery also appears here.) You can also add or remove a style from the Quick Style Gallery through the Add to Quick Style Gallery check box in the Create New Style... or Modify Style dialog boxes.

89. Quickly Know How Many Lines or Words You Have Typed
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.

90. Returning to the Last Edit in a Microsoft Office Word Document
If you want to return to where you last made a change in a Word document, press SHIFT+F5, and you will go straight back to the point of the last edit.

How I can use Security Essentials with Windows Security Center

2009-03-27T20:59:00.000-07:00

85. How to Save a Search
86. How to Use Security Essentials with Windows Security Center
87. How to Preview Files

85. Saving a Search
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 rches.

86. Security Essentials with Windows Security Center
Windows Security Center is located in Control Panel in the Security group, and it provides access to Windows Firewall, updating, and other security settings. You can check here to make sure you have some level of security on your systems. Windows Vista will even assist you in finding tools that help protect against viruses and malicious software, for an additional level of security.

87. Preview Files
Windows Vista offers a preview pane for certain files that have viewers available. Some files use default viewers; additional views are available or included with applications.
Here’s how to see a preview: In the Explorer, click Organize, click Layout, and then click Preview Pane. (Note: Rendering a preview uses system resources, so use appropriate consideration.)

How I can List my Contact in the Groove Public Directory

2009-03-22T10:23:00.000-07:00

82. How to List Contact in the Groove Public Directory
83. How to Setting Permissions
84. How to Add and Deleting Tools

82. List Your Contact in the Groove Public Directory
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.

83. Setting Permissions
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.

84. Adding and Deleting Tools
Most workspaces begin as a Standard Workspace, which includes a Files tool and a Discussion tool. You and your team members can add more tools at any time to meet your needs.
To add a tool to your workspace, click the plus sign (+) next to the tool tabs at the bottom of your workspace, and then select the tool that you want from the pop-up list. The tool appears quickly for every member who is online and for others when they come online.
To delete a tool, right-click its tool tab, and then click Delete. This will delete the tool and its data from all members’ copies of the workspace.
To rename a tool, right-click its tool tab, and then click Rename.
To reorder a tool within the workspace, drag its tool tab to the location where you want it.

How I can Inspect Presentation for Comments and Metadata

2009-03-22T10:18:00.000-07:00

79. How to Use Table Styles
80. How to Create a Photo Album
81. How to Inspect Presentation for Comments and Metadata

79. Use Table Styles
You can easily improve the look of your tables in seconds by using table styles in Microsoft Office PowerPoint 2007.
1. Select the table that you want to format.
2. A set of Table Tools contextual tabs appears on the user interface. Click the Design tab to reach the Table Styles gallery.
3. Browse through the available prebuilt styles by pausing on each table. You’ll see a preview of your table’s appearance with that style.
4. Click the table format that you like, and apply the changes to your presentation. You can use the other features and galleries on the Design and Layout tabs to further customize your table.

80. Create a Photo Album
Using the new Photo Album feature in Microsoft Office PowerPoint 2007, you can quickly create a photo album presentation with pictures consistently sized, placed, framed, and even captioned.
To create a photo album, on the Insert tab, click Photo Album. In the Photo Album dialog box, click File/Disk under Insert picture from to locate and select your pictures. You can edit pictures, add captions to pictures, and customize the picture layout and framing format, all from the dialog box. When finished, click Create to generate the presentation.
To enable captions, in the Picture layout box, select a layout other than the default Fit to slide layout. If you have enabled captions for all pictures, the default caption text is the picture file name.
Note that if you don’t select a theme in the Photo Album dialog box, your album uses the Office theme. You can apply a different theme at any time from the Design tab.
You can edit album slides directly as in any PowerPoint presentation. Or on the Insert tab, click the arrow at the bottom of the Photo Album icon, and then click Edit Photo Album.

81. Inspect Your Presentation for Comments and Metadata
If you need to publish your presentation outside your organization, you may want to remove comments, notes hidden in the text, or other personally identifiable information. Often this type of information is added to the document in the process of creating it.
1. Click the Office button, and then on the Prepare menu, click Inspect Document. (If you haven’t saved your document yet, you will be prompted to do so.)
2. Select the items that you want the Document Inspector to look for. Most of these items will be selected by default.
3. Click Inspect to begin the inspection process.
4. You’ll receive a list of inspection results. Click Remove All next to any items you want to have removed from the document.
5. Click Close to close this wizard. You may want to resave your document now that this information is removed.

How I can View All the Text in my Columns

2009-03-18T04:38:00.000-07:00

76. How to use Fill In the Blanks in Spreadsheets the Easy Way
77. How to View All the Text in Your Columns
78. How to Fill a Selected Range with the Same Data

76. Fill In the Blanks in Spreadsheets the Easy Way

1. Select all the rows in your Microsoft Office Excel spreadsheet data set.
2. On the Home tab, in the Editing section, click Find & Select, click Go To, click Special, click Blanks, and then click OK.
3. Click the equal sign (=) on the toolbar, select the cell above, and then hold down the CTRL key while you press ENTER. Blanks in the spreadsheet will be filled automatically.
4. Copy all the data, click Paste Special, and then click Values. This will overwrite the formulas and enable you to sort the data by filling in each empty cell with the same information as the one above. This tip will work on any size of data set.

77. View All the Text in Your Columns
In Microsoft Office Excel, you can resize multiple columns to different widths so that you can see all the text in your spreadsheet.
1. Select the columns where your text appears by clicking the column headings. Select multiple columns if necessary.
2. To resize the columns to fit, double-click in the column heading, exactly on top of the border that divides any of the two columns you selected.
All of your selected columns are resized based on the longest text string in each column. In this way, a large and confusing spreadsheet with lots of text that you can't see is converted into a legible spreadsheet with all text showing.

78. Fill a Selected Range with the Same Data
Need to enter the same data in a range of cells? Here’s how:
1. Select a range of cells.
2. Type in some data.
3. Use the fill function in Microsoft Office Excel—press CTRL+ENTER, and the range selected will be filled with the same data.

How I can Set the Print Area in Microsoft Office Excel

2009-03-18T04:35:00.000-07:00

73. How to Set the Print Area in Microsoft Office Excel
74. How to Create a Linear Series of Values in Excel
75. How to Change Gridline Colors

73. 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.

74. Create a Linear Series of Values in Excel
Here’s how to use Auto Fill to create a series of values:
1. Create the initial series. In a Microsoft Office Excel workbook, type 1 in the A1 cell and 2 in the A2 cell.
2. Select cells A1 and A2.
3. Click the Auto Fill handle (the little black box in the lower-right corner of the selection) and drag to A15 to fill the cells with the numbers 1 through 15. You can create different series of numbers, odd and even numbers, or even dates.

75. Changing Gridline Colors
You can change the look of your worksheet.
1. With a Microsoft Office Excel worksheet open, click the Office button, click Excel Options, and then click Advanced.
2. Under Display options for this worksheet, select the gridline color of your choice.
3. Click OK.

How I can Work with Windows SharePoint Services in access

2009-03-18T04:30:00.000-07:00

70. How to Modifying Data Types
71. How to Insert Predefined Fields
72. How to Work with Windows SharePoint Services

70. Modifying Data Types
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.

71. Inserting Predefined Fields
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.

72. Working with Windows SharePoint Services
Microsoft Office Access 2007 is deeply integrated with Windows SharePoint Services to offer a Web-based user interface, alerts, revision history, RSS feeds, a Recycle Bin, and central IT manageability. To take advantage of the capabilities offered by Windows SharePoint Services, you must move your data to the server and create a link between each Access table and the Windows SharePoint Services lists.
To move data to Windows SharePoint Services:
1. Close all open objects in Access.
2. On the External Data tab, click Move to SharePoint.
3. Type the URL of a site to which you have editing rights, and then click Next. If you want to save a copy of the Access data, click Browse, and then select a document library. Access creates a Windows SharePoint Services list for each Access table.
After your data moves to Windows SharePoint Services, you cannot change the table schema in Access. You must modify the Windows SharePoint Services list. For quick access to the list from Access, right-click the orange table icon, and then on the SharePoint List Options shortcut menu, click Open Default View.

How I can use Custom Slide Layout 2003 to 2007

2009-03-18T04:13:00.000-07:00

67. How to use 2003 to 2007 Custom Slide Layout
68. How to use 2003 to 2007 Insert Chart
69. How to use 2003 to 2007 Workflow

67. 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.

68. 2003 to 2007 Insert Chart
Microsoft Office PowerPoint is a presentation program, not a data analysis tool. Why then does inserting a chart in a Microsoft Office PowerPoint 2003 presentation open a separate datasheet object for customizing chart data? Instead, you can work with chart data in a program that was designed to handle it—Microsoft Office Excel 2007.
1. In Microsoft Office PowerPoint 2007, click the Insert tab, and then click Chart in the Illustrations group.
2. Select the chart type you want, and then click OK. Notice the split-screen PowerPoint 2007/Excel 2007 view, in which you can edit your chart data in a familiar Excel environment.
3. To resize the chart data range, drag the lower-right corner of the range in Excel 2007 and watch the chart dynamically adjust on your PowerPoint 2007 slide.

69. 2003 to 2007 Workflow
Routing a Microsoft Office 2003 Editions document for approval or review often means sending it as an e-mail attachment. Unfortunately, doing so creates multiple copies of the same document and requires the document owner to manually merge all the returned documents together. Alternately, you can place the document on a centralized file share, but approvers and reviewers must have access to the share, and they may have trouble if more than one of them attempts to access the document at the same time.
With the 2007 Microsoft Office system and Microsoft Office SharePoint Server 2007, you can initiate and participate in automated document workflows from within the application. To initiate a workflow:
1. Save the document to a SharePoint document library.
2. Click the Office button, and then click Workflows.
3. Select the workflow you want, and then click Start.
4. Enter the workflow participants, type a personal message, select the number of days or weeks allowed for completion, and then click Start.
The document will be automatically routed to the first approver's Inbox, where he or she can review the document and then click Edit This Task in the Outlook 2007 Reading Pane to approve or reject the workflow task. If the task is approved, the document is routed to the next approver in line. There is one version of the file, and the process runs automatically until it is completed or rejected by an approver; in both cases, you are notified and can take further action if necessary.

How I can find Correct Format for Excel Formulas

2009-02-15T18:22:00.000-08:00

64. How to Find the Correct Format for Excel Formulas
65. How I can Easily Insert Rows or Columns in Excel
66. How to Previewing Charts in Grayscale

64. Find the Correct Format for Excel Formulas
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.

65. Easily Insert Rows or Columns in Excel
With a Microsoft Office Excel document open, you can insert extra rows and columns by holding down the SHIFT key while you grab a cell by its handle and drag it. Excel will insert as many cells as needed

66. Previewing Charts in Grayscale
You can preview your charts in Microsoft Office Excel before you print.
1. Open the file that you want to print, click the Office button, point to Print, and then click Print
Preview.
2. On the Print Preview ribbon, click Page Setup, click Sheet, and then click Black and white. The
preview will be in grayscale so that you can evaluate whether the contrast is good enough to distinguish the lines, bars, and columns.

How I can Create an Electronic Business Card for my Signature

2009-02-15T18:14:00.000-08:00

61. How to Gain Greater Control over Your Out-of-Office Message
62. How to Create an Electronic Business Card for Your Signature
63. How to Setting Up Meetings in Outlook 2007

61. Gain Greater Control over Your Out-of-Office Message
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.

62.Create an Electronic Business Card for Your Signature
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.

63. Setting Up Meetings in Outlook 2007
If you're tired of making phone calls to set up meetings, you can use Microsoft Office Outlook 2007 to schedule a meeting.
1. On your calendar's sidebar, click Send a Calendar Request via E-mail.
2. Select the date. Your meeting request will then be sent directly to the recipient.

How I can Correct a Capitalization Error and Split the Screen

2009-02-15T18:04:00.000-08:00

58. How to Correct a Capitalization Error
59. How to Use a Voice Command
60. How to Split the Screen

58. Correcting a Capitalization Error
Here’s a simple fix for a capitalization mistake in Microsoft Office Word:
Select the text you have mistakenly typed with CAPS LOCK on, and then press SHIFT+F3. The words will revert to either lowercase or uppercase, depending on what you typed.

59. Use a Voice Command
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.

60. Split the Screen
In Microsoft Office Word, on the View tab, in the Window section, click Split. This splits the screen and displays a dividing line in the current window. To switch between the screens, use the F6 key.

How I can Identify Duplicate Values in an Excel Table

2009-02-10T09:23:00.000-08:00

55. How to Identify Duplicate Values in an Excel Table
56. How to See if a Query Is Progressing
57. How to Select Excel Ranges by Using the Name Box

55. Identify Duplicate Values in an Excel Table
In Microsoft Office Excel 2007, you can easily highlight duplicate values with conditional formatting.
1. Select the list in which you want to identify duplicates.
2. Click the Home tab on the Ribbon.
3. In the Styles section, click Conditional Formatting, point to Highlight Cells Rules, and then click Duplicate Values. Pairs of duplicates will then be highlighted, and you can choose which of each pair to delete

56. See How a Query Is Progressing
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.

57. 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.