Archive for the ‘Tips and Tricks’ Category

PC Tip of the Week: Microsoft Office Word 2007

Tuesday, March 9th, 2010

Microsoft Word 2007: I Can’t Insert Text Before a Table

Symptoms

You can’t insert text before a table that is located on the first line of the first page in a document.
Resolution

1. Click in the first cell in the first row of the table.
* Note: If text in that cell contains text, position the insertion point before the text.
2. Press ENTER.
3. Type the text that you want.

PC Tip of the Week: Microsoft Office PowerPoint 2007

Tuesday, March 2nd, 2010

Microsoft PowerPoint 2007: Inserting, playing, and modifying movies

Sometimes the best way to ensure that your audience understands your message is to show a video or animation, collectively referred to in PowerPoint as movies. For example, if your company has developed a short advertising video, it makes more sense to include the video in a presentation about marketing plans than to try and describe it with bullet points or even still pictures. You can insert the following types of movies in slides:

* Video clips. You can insert a digital video file in one of two ways: If a slide’s layout includes a content placeholder, you can click the Insert Movie button in the placeholder. You can also click the Movie button in the Media Clips group on the Insert tab. Either way, the Insert Movie dialog box opens so that you can select the file. Before PowerPoint inserts the file, you specify whether the video should play automatically when the slide containing it appears or whether you will start the video manually.
* Animated clips. PowerPoint comes with several animated graphics. You insert these animated objects by clicking the Movie arrow in the Media Clips group on the Insert tab, and then clicking Movie From Clip Organizer to display the Clip Art task pane, where you can select the clip you want. If you are connected to the Internet, clicking the Clip Art On Office Online link in the task pane takes you to the Office Online Clip Art and Media Web site, from which you can download hundreds of clip art images, photos, sounds, and animated clips.

Videos and animated clips both appear on the slide as objects represented by icons that you can size and move to meet your needs. When you select an animated clip object, PowerPoint adds a Format contextual tab to the Ribbon so that you can adjust the way it looks on the slide. When you select a movie object, PowerPoint also adds an Options contextual tab so that you can adjust the object’s size and position, its volume, how it is displayed on the slide, and how it is activated.

In Normal view, you can preview a video by double-clicking its icon or by clicking the Preview button in the Play group on the Options contextual tab. You can preview the action of an animated clip by clicking the arrow that appears when you select it in the Clip Art task pane and then clicking Preview/Properties. In Slide Show view, a video plays either automatically or when you click its icon, depending on your specifications, whereas an animated clip always plays automatically.

PC Tip of the Week: Microsoft Office Outlook 2007

Friday, February 26th, 2010

Microsoft Outlook 2007: Change your Calendar Work Days

By default in Microsoft Office Outlook 2007, the work week is set from Monday through Friday with a work day extending from 8 A.M. to 5 P.M.. The first day of the week in Calendar is Sunday.

You can choose the days of the week that are a part of your work week, the time when your work day starts and ends, and the day of the week that you want to be the start of your week.

Change your Calendar work days

1. On the Tools menu, click Options.
2. Click Calendar Options.
3. Under Calendar work week, select the check boxes for the days that are a part of your work week. Clear the check boxes for the days that are not a part of the work week.

PC Tip of the Week: Microsoft Outlook 2007

Friday, February 19th, 2010

Microsoft Outlook 2007: Add Holidays to Calendar

1. On the Tools menu, click Options, and then click Calendar Options.
2. Under Calendar options, click Add Holidays.
3. Select the check box next to each country/region whose holidays you want to add to your calendar, and then click OK.

Note   Your own country/region is automatically selected.

If you already added a country’s or region’s holidays to your calendar, the check box for that country/region is selected in the Add Holidays to Calendar dialog box. If you try to add the same items again, you receive the following message:

Holidays for country/region are already installed. Do you want to install them again?

If you click Yes, the holidays and events are installed a second time, and you see duplicate holiday and event entries.

Note   The holiday information that is provided with Outlook includes items during calendar years 2006 through 2012. If you are using a non-Gregorian calendar, items that occur during the same time period are included.

PC Tip of the Week: Microsoft Outlook 2007

Friday, February 12th, 2010

Microsoft Outlook 2007: Prevent meeting request replies

In Microsoft Office Outlook, you can send a meeting request and not track the attendees’ responses. Not tracking the responses can be useful when you send a meeting request to a large number of attendees but do not want to know who can and cannot attend.
Turn off meeting request responses

In a new meeting request, do the following:

1. On the Meeting tab, in the Attendees group, click Responses.

Note   For recurring meetings, the Meeting tab appears as the Recurring Meeting tab.
2. Click Request Responses to clear the Request Responses and Allow New Time Proposal check boxes.

Note   If you turn off the Request Responses option, you will not be able to track whether attendees have accepted, tentatively accepted, or declined. For instance, when you open the meeting in your calendar, click the Meeting tab, and then click Tracking in the Show group, the Response column will display None for all of the attendees.

No-Fee Webinar: Microsoft Office 2010 Preview

Wednesday, February 10th, 2010

Office 2010: Preview the Future

Product(s): Microsoft Office 2010
Audience(s): Business Professional.
Date(s): Friday, February 12 2010, 1:00PM (EST) U.S.
Duration: 30 Minutes  

Event Overview:
It seems like just yesterday Microsoft launched Office 2007. However, it’s been three years and it’s time for a new version of the application suite. Office 2010 is built off the Office 2007 design, but don’t let that fool you. This is a new set of applications with new tools. If you’re looking to make the move to 2010, have already purchased the suite, or just curious about the new features, let us be your guide to the future of Microsoft Office.

* Interface Changes
* What’s New in Word
* What’s New in Excel
* What’s New in Outlook

To Register: Click HereFee: $0.00

PC Tip of the Week: Microsoft Outlook 2007

Friday, February 5th, 2010

Microsoft Office Outlook 2007: Change the sound played for reminders

You can use an audio alert to inform you of reminders. The default sound is a short .wav audio file, but you can change the sound to any .wav file of your choice.

1. On the Tools menu, click Options.

Note:   The Tools menu appears on the main Outlook window. The main window is the same window that appears when you start Outlook and includes the File, Edit, View, Go, Tools, Actions, and Help menus. No Tools menu is available in windows where you create or view items such as e-mail messages, contacts, or tasks.
2. On the Other tab, click Advanced Options.

3. Click Reminder Options.

4. In the Reminders Options dialog box, click Browse, and then select a different .wav file.

The audio file can be located anywhere on your hard disk or on any network share to which your computer always has access. If you move the audio file from the current location, or if the file is not accessible, the sound does not play when reminders occur.
5. On the Reminders Options, Advanced Options, and Options dialog boxes, click OK.

PC Tip of the Week: Microsoft Word 2007

Friday, January 29th, 2010

Restrict formatting in Word 2007 Documents

By default, all styles are available and can be changed by other users. You can restrict people from changing the formatting or styles for portions of your document or for the entire document.

1. On the Home tab, in the Styles group, click the Styles Dialog Box Launcher.
2. In the Styles task pane, click Manage Styles, and then click the Restrict tab.
3. In the Sort order list, select the sort order that you want to use to view the styles.
4. Click the individual styles that you want to restrict, or select groups of styles by clicking one of the following options.
* Select Visible: Click this option to select the styles that appear by default in the recommended list. To see the list of recommended styles, click the Recommend tab.
Tip:   To add styles to this list, on the Recommend tab, select the styles that you want to add, and then click Show.
* Select Built-in: Click this option to select all of the styles that are included in Microsoft Office Word but not any custom styles that you created.
* Select All: Click this option to select all of the styles that are included in Word and all of the custom styles that you created.
5. Select the check boxes next to one or more of the following:
* Limit formatting to permitted styles: Select this option to allow reviewers to change formatting using only permitted styles. Reviewers won’t be able to format text directly or use styles that are restricted.
* Allow AutoFormat to override formatting: Select this option to allow reviewers to use restricted styles when automatically formatting text such as hyperlinks or automatic bullets. For example, if you select this check box, Word will automatically format hyperlinks, even if the Hyperlink style is locked.
Note:   This option is available only if Limit formatting to permitted styles is selected.
* Block Theme or Scheme switching: Select this option to prevent reviewers from changing the themes that are used in the document.
* Block Quick Style Set switching: Select this option to prevent reviewers from changing the current style set.
6. Click Restrict.
A lock icon appears next to any styles that are restricted.
7. Click OK.
8. You may be prompted to create an optional password. To assign a password to the document so that only people who know the password can remove the restriction, type a password in the Enter new password (optional) box, and then confirm the password.

PC Tip: Use Outlook with Comcast e-mail

Monday, January 25th, 2010

Use Outlook with Comcast e-mail
(applies to Microsoft Office Outlook 2002 and 2003)

You can use Outlook with your Comcast e-mail account. The following steps will set up Outlook to both receive and send e-mail messages with your Comcast account.

Note:  You can receive your Comcast e-mail messages by using Outlook from most places with an Internet connection. Comcast provides you access to an authenticated SMTP server — allowing you to send e-mail messages using Outlook from your Comcast account when you are using another Internet service, such as at your office or when traveling.

Add your Comcast Email account:

1. On the Tools menu, click E-mail Accounts.
2. Select Add a new e-mail account, and then click Next.
3. Select POP3, and then click Next.
4. Under User Information, do the following:
***In the Your Name box, type your full name the way you want it to appear to other people.
***In the E-mail Address box, type your e-mail user name followed by @comcast.net.
5. Under Server Information, do the following:
***In the Incoming mail server (POP3) box, type mail.comcast.net.
***In the Outgoing mail server (SMTP) box, type smtp.comcast.net.
6. Under Logon Information, do the following:
***In the User Name box, type your user name provided by Comcast.
***In the Password box, type your password.
***Select the Remember password check box.
Note  You have the option to have Outlook remember your password by typing it in the Password box and selecting the Remember password check box. Having Outlook remember your password means that you won’t have to type your password each time you access the account; however, it also means that the account is vulnerable to anyone who has access to your computer. Use strong passwords that combine upper- and lowercase letters, numbers, and symbols. Weak passwords don’t mix these elements. Strong password: Y6dh!et5. Weak password: House27. Use a strong password that you can remember so that you don’t have to write it down.
7. To verify that your account is working, click Test Account Settings. If there is missing or incorrect information, such as your password, you will be prompted to supply or correct it. Make sure your computer is connected to the Internet.
8. Click More Settings.
9. On the General tab, under Mail Account, type Comcast.
Note  If you are attempting to send and receive Comcast e-mail messages from a location where you are not directly connected to Comcast, such as at work or when travelling, see the Notes section for additional steps.
10. Click OK, and then click Next.
11. Click Finish.

Notes
* Do not select the Log on using Secure Password Authentication (SPA) check box.
* Unless specified by Comcast, all server and address entries are typed in lowercase letters.
* To send and receive e-mail messages with your Comcast account when you are not directly connected to the Comcast service, such as at work or when travelling, you must use the following:
***After step 9 above, click the Outgoing Server tab, and then select the My outgoing server (SMTP) requires authentication check box.
***Select Use same settings as my incoming mail server.
***Continue with step 10 above.

PC Tip of the Week: Microsoft Outlook 2007

Friday, January 22nd, 2010

How do I set up the “automatic replies” rule?

1. On the Tools menu, click Rules and Alerts.
2. In the Rules and Alerts dialog box, click New Rule.
3. In the Rules Wizard, click Check messages when they arrive, and then click Next.
4. Under Step 1, select the Uses the form name form check box. (You may need to scroll down to find this option.)
5. Under Step 2, click Form name, and then select Accept Meeting Response and Tentative Meeting Response. After you add the two forms, click Close and then Next in the main Rules Wizard window.Choose Forms dialog box

Be sure to select Application Forms from the drop-down list at the top of the dialog box, or you might miss Accept Meeting Response and Tentative Meeting Response.
6. Select the following exception: Except if the body contains specific words.
7. In Step 2, click Specific words, type a space, and then click Add and then OK. Step 2 in Rules Wizard
8. Click Finish.