Archive for the ‘FQA for Microsoft Office’ Category

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.

PC Tip of the Week: Microsoft Excel 2007

Wednesday, June 9th, 2010

Save a Chart as a Chart Template

1. Click the chart that you want to save as a template.

Tip: This displays the Chart Tools, adding the Design, Layout, and Format tabs.
2. On the Design tab, in the Type group, click Save As Template.

3. In the Save in box, make sure that the Charts folder is selected.

Note: The Charts folder is typically selected by default. Chart templates that you save in this folder will automatically be added to the Templates folder in the Insert Chart and Change Chart Type dialog box so that you can select it when you create or update a chart.

4. In the File name box, type an appropriate name for the chart template.

PC Tip of the Week: Microsoft Word 2007

Thursday, June 3rd, 2010

Microsoft Word 2007: Change the author name for documents
Every time you create a new document, Microsoft Office Word sets the Author property based on the User name setting that appears in the Word Options dialog box. The User name setting also provides the name and initials that are displayed in comments and tracked changes.
Change the author name in an existing document
1. Click the Microsoft Office Button Button point to Prepare, and then click Properties.
2. In the Document Information Panel, type the author name in the Author box.
Note: Changing the Author property in the Document Information Panel of an existing document has no effect on the User name setting in the Word Options dialog box.

Get your free reference guides for Microsoft Office!

Wednesday, September 16th, 2009

KnowledgeWave offers this free quick reference guide for Microsoft Excel and other Office Applications. They are packed with instructions and shortcuts. Reference cards are a perfect alternative to bulky reference manuals, this is ideal for anyone who wants to make more efficient use of Microsoft Excel and the other applications.

Download your free guide by clicking here!

 

 

 

 

 

Download your free guide by clicking here!