Posts Tagged ‘Free Tip’

PC Tip of the Week: Microsoft Word 2010

Tuesday, September 7th, 2010

Turn a Picture Into a Watermark

You can turn a picture, clip art, or a photo into a watermark that you can use to brand or decorate a document.

1. On the Page Layout tab, in the Page Background group, click Watermark.
2. Click Custom Watermark.
3. Click Picture watermark, and then click Select Picture.
4. Select the picture that you want, and then click Insert.
5. Select a percentage under Scale to insert the picture at a particular size
6. Select the Washout check box to lighten the picture so that it doesn’t interfere with text.

The picture that you selected is applied as a watermark to the entire document.

PC Tip of the Week: Microsoft Excel 2007

Thursday, August 26th, 2010

Copy Formulas with the Fill Handle

1. Create the formula in the appropriate cell on the spreadsheet.

2. Click on that cell to make it the active cell.

3. Click and hold down the mouse pointer on the fill handle in the bottom right corner of the active cell.

4. Drag the fill handle to copy the formula to as many cells as needed.

PC Tip of the Week: Microsoft Project 2010

Tuesday, August 17th, 2010

Link or Embed Excel Data into Microsoft Project

You can insert data from Microsoft Office Excel into Microsoft Project as a linked object that will be updated dynamically by changes made in the source file. You can also embed the data independent of its original file.

1. In Excel, select the data (such as fields, cells, records, or rows) that you want to link or embed, and then click Copy.
2. In Project, on the View tab, click the view that you want.

To use a view that is not on the View tab, click the arrow on Other Views, then select More Views. From the list on the More Views dialog, select the view that you want, and then click Apply.

3. In Project, select the location where you want to insert the data.
4. Right-click to select Paste Special.
5. On the Paste Special dialog, do one of the following:
* To paste the data, without a link to the source document, click Paste.
* To link the inserted data to the data in the source document, click Paste Link.
6. From the list, select Text Data and then click OK.

PC Tip of the Week: Microsoft Outlook 2007

Thursday, July 29th, 2010

Change the Appearance of Your Calendar: Change the Background Color

1. On the Tools menu, click Options, and then click Calendar Options.
2. Under Calendar options, in the Background color list, click the color that you want.

Notes:
* The color that you choose is applied to the Day and Work Week views. The Week and Month views use system background colors, which are gray and white, by default.
* The color that you choose is applied to weekday hours. A darker shade of the background color is applied to night and weekend hours.

PC Tip of the Week: Microsoft Outlook 2007

Thursday, July 22nd, 2010

Print Blank Calendars
You can use Microsoft Outlook to print a blank calendar. Blank calendars may be useful to take notes on or to consult when you meet to discuss a project with your team.

1. On the File menu, point to New, and then click Folder.
2. In the Create New Folder dialog box, in the Name text box, type a name for the folder.
3. In the Folder contains list, click Calendar Items.
4. In the Select where to place the folder list, click Calendar, and then click OK.
5. In Calendar, in the Navigation Pane under the My Calendars section, select the check box for the calendar you created.
6. On the File menu, click Print.
7. In the Print dialog box, under Print this calendar, click the calendar you created.
8. Select the print style options you want, and then click OK.

PC Tip of the Week: Microsoft Outlook 2007

Thursday, July 15th, 2010

Make an Appointment or Meeting Private
1.  Create or open the appointment or meeting that you want to make private.
2. On the Appointment tab, in the Options group, click Private.

Important: You should not rely on the Private feature to prevent other people from accessing the details of your appointments, contacts, or tasks. To ensure that other people cannot read the items that you mark as private, do not grant them Read permission to your Calendar, Contacts, or Tasks folders. A person with Read permission to access your folders could use programmatic methods or other e-mail applications to view the details of your private items. Use Private only when you share folders with people whom you trust.

PC Tip of the Week: Microsoft Outlook 2007

Thursday, July 8th, 2010

Propose a New Time for a Meeting

1. In the open meeting request, on the Message tab, in the Respond group, click “Propose New Time”.
*Note: If you open the meeting from your calendar, on the Appointment tab, in the Respond group, click Propose New Time.
2. Click either Tentative and Propose New Time or Decline and Propose New Time.
3. Click a time when all invitees are available.
4. Click Propose Time.
5. Click Send.
Microsoft Office Outlook 2007 sends a default message saying that you want to propose a new time but you have tentatively accepted the meeting. You can change this default message to say that you want to propose a new time, and that you are declining the meeting:

1. On the Tools menu, click Options, and then click Calendar Options.
2. In the Use this response when you propose new meeting times list, click the setting that you want.

*Note: You can also change this setting for individual meetings. In the open meeting request, on the Message tab, in the Respond group, click either Tentative and Propose New Time or Decline and Propose New Time. If you open the meeting on your calendar, on the Appointment tab, in the Respond group, click either Tentative and Propose New Time or Decline and Propose New Time.

PC Tip of the Week: Microsoft PowerPoint 2007

Thursday, July 1st, 2010

Change all of the Slide Transitions in your Presentation

1. In the pane that contains the Outline and Slides tabs, click the Slides tab.
2. On the Home tab, click a slide thumbnail.
3. On the Animations tab, in the Transition To This Slide group, click a different slide transition effect.
To see more transition effects on the Quick Styles list, click the More button.
4. To re-set the slide transition speed, in the Transition To This Slide group, click the arrow next to Transition Speed, and then select the speed that you want.
5. In the Transition To This Slide group, click Apply to All.

PC Tip of the Week: Microsoft PowerPoint 2007

Thursday, June 24th, 2010

Record a Narration During a Presentation

If you want to capture your own comments, the comments of your audience, or both during your presentation, you can turn on narration before you begin your presentation.

1. In Normal view, select the slide that you want to start the recording on.
2. On the Slide Show tab, in the Set Up group, click Record Narration Button image.
3. Click Set Microphone Level, follow the directions to set your microphone level, and then click OK.
4. Do one of the following:
* To embed (embedded object: Information (object) contained in a source file and inserted into a destination file. Once embedded, the object becomes part of the destination file. Changes you make to the embedded object are reflected in the destination file.) the narration, click OK.
* To link the narration, select the Link narrations in check box, click Browse, click a folder in the list, and then click Select.
5. If you selected the first slide to begin the recording on, go to step 6.
If you selected a different slide to begin the recording on, the Record Narration dialog box appears. Do one of the following:
* To start the narration on the first slide in the presentation, click First Slide.
* To start the narration on the currently selected slide, click Current Slide.
6. In Slide Show view, add your speaker comments along with any audience comments, and then click the slide to advance to the next slide. Repeat this process for all the slides in your presentation.
Tip: To pause and resume the narration, right-click the slide, and then on the shortcut menu (shortcut menu: A menu that shows a list of commands relevant to a particular item. To display a shortcut menu, right-click an item or press SHIFT+F10.), click either Pause Narration or Resume Narration.
7. Click the black Exit screen.
8. The narration is automatically saved, and a message appears asking if you want to save the timings for the presentation as well. Do one of the following:
* To save the timings, click Save. Your slides appear in Slide Sorter view, with the slide timings shown below each slide.
* To cancel the timings, click Don’t Save.

PC Tip of the Week: Microsoft Excel 2007

Thursday, June 17th, 2010

Insert a Picture in a Chart

1. Click the chart area of the chart.
*This displays the Chart Tools, adding the Design, Layout, and Format tabs.

2. On the Layout tab, in the Insert group, click Picture.

3. Locate the picture that you want to insert, and then double-click it.
*Tip: To add multiple pictures, hold down CTRL while you click the pictures that you want to insert, and then click Insert.

4. To change the size of the picture, drag a sizing handle (sizing handle: One of the small circles or squares that appears at the corners and sides of a selected object. You drag these handles to change the size of the object.) away from or toward the center of the picture while doing one of the following:
* To keep the center of the picture in the same place, hold down CTRL while you drag the sizing handle.
* To maintain the proportions of the picture, hold down SHIFT while you drag the sizing handle.
* To both keep the center of a picture in the same place and maintain its proportions, hold down CTRL+SHIFT while you drag the sizing handle.

Tip: You can also resize a picture to an exact height and width by selecting the picture and then entering the size that you want in the Shape Height and Shape Width boxes (Format tab, Size group).
5. To move the picture, drag it to the location that you want.

Note   Pictures that you insert in your chart are embedded in your chart and therefore increase the file size. To reduce the file size, you can link to a picture instead of inserting it. In the Insert Picture dialog box, click the picture that you want to insert, click the arrow next to Insert, and then click Link to File.