More Computer Tutorials

Here are a few more computer tutorials I think are really helpful:

Computer Tutorials for Outlook 2003

Create a Signature file

1. Open Outlook 2003.
2. Go to Tools, Options.
3. Click on the Mail Format tab.
4. At the bottom, select the email account for which you want to make the signature.
5. Click the Signatures.. button.
6. Click the New button
7. Enter a name for your signature
8. Choose Start with a Blank Signature file and press Next
9. Type in what you want your signature to say. You can change the font or paragraph settings using the buttons provided.
10. Click Finish.

Set a Reminder to Reply to a Message

1. Open your Outlook Inbox.
2. Right click on the message for which you want to set the reminder.
3. Click on Follow Up, and then click Add Reminder.
4. In the Due By list, click the date when you want to complete the reply.
5. In the second list, click a time.
6. In the Flag color list, click the flag color you want, and then click OK.

Automatically add Holidays to your Outlook 2003 Calendar

1. Open your Outlook Calendar.
2. Click on the Tools menu.
3. Click Options, then under Calendar, click the Calendar Options button.
4. Click the Add Holidays button.
5. Choose the appropriate country and click OK.

Keep Track of Emails From VIPs

This computer tutorial will help you track email from your clients.

1. From your Inbox, scroll down the list of folders on the left and find an entry called Search Folders.
2. Right click on Search Folders and choose New Search Folder.
3. From the dialog box that appears, Under Mail from People and Lists, choose Mail From and To Specific People.
4. Click on the Choose.. button (bottom of window) and click on the name of the person whose email you want to track. Click Ok.
5. It will now show that Name in the field.
6. Click OK. The new Search Folder will appear. (This may take a minute or so if there are many emails to and from this person.)

Computer Tutorials for Excel 2003

1. While you hold down the Control key, use your mouse to select the rows that you want to adjust by clicking on the row number. All the rows you want to change should all be selected and "gray" in color when you are done.
2. Let go of the Control key.
3. Click on the Format menu, point to Row, and then click Height.
4. Set the height to around 6 for a narrow row; 12 would be a larger (taller) row height.

Select a Contiguous Range of Excel Cells without Scrolling

You have a huge Excel spreadsheet and you need to select 50 columns of data 300 rows long so you can set the cell format on them at once. Here’s an easy way to select them all without scrolling.

1. Open an Excel spreadsheet
2. Click in the first cell of the range you want to pick, say A1
3. Now on your keyboard, press Control + G to bring up the Go to window.
4. Type in BC300 in the Reference field
5. Hold down your Shift key and press OK on the Go to box.

More computer tutorials below...

Computer Tutorials for Word 2003

How to Change the Default File Location for Word

1. Open Word
2. Go to the Tools menu
3. Click on Options
4. Click on File Locations tab
5. Under File Types, click on Documents to highlight it.
6. Click the Modify button
7. Navigate to the location where you want Word to look for documents.
8. Click Ok.

Automatic Zooming

If you like to zoom in on your Word documents, you probably hate the pull-down zoom control on the toolbar as much as I do. I can never find it when I need it. Here’s an easy way to zoom in and out if you have a mouse with a wheel:

Hold down the Ctrl key as you turn the mouse wheel. Scroll up to zoom in, scroll down to zoom out. Cool, huh? With each click of the wheel, the zoom factor is changed by 10%.

Computer Tutorials for Internet Explorer

Clean up Temporary Internet Files Automatically

1. Open Internet Explorer.
2. Click on Tools | Internet Options.. (If you have IE7, the Tools menu has been moved to a Tools button on the right hand side of the IE window.)
3. On the Internet Options dialog box, click on the Advanced tab.
4. Scroll down the list to the Security section.
5. Put a check in the box next to where it says "Empty Temporary Internet Files folder when browser is closed."
6. Click Ok.

Get Better Search Results in Google

Here are a few simple tricks to use when searching the Internet for information using various search engines. Let’s use Google.com as our example search engine.

When you search for something on Google, your results might not be what you expected, with some of the pages more and some less relevant to the original search inquiry.

For example, you may end up with results from various newspaper articles that merely mention the search term you used, without being related in topic to the search inquiry.

• A good technique to minimize those unrelated results is to place: intitle: or allintitle: before your search terms.

  This will insure that your search terms are in the page title of each page found, increasing the chances that the page will be on topic. (Note that there should be no space between the colon and your search term.)

• A similar effect can be accomplished with the options inurl: and allinurl: but here Google will restrict the results to show only those where the web address (URLs) contain the word or phrase for which you searched.

• If you are searching for a definition of a term, Google offers help here too. You can type define: followed by the word or words you want defined (again no spaces between the colon and the word to be defined). Note that if you enter more words after "define:" Google will see those words as a phrase.

• When you have a URL of a website that interests you (e.g. www.example-url.com) you can find all the websites that link to that site, all the websites related to that site and check what info Google has on that particular site. Use link: followed by the URL of your choice (e.g. link:www.example-url.com) when you want to find all websites that link to that site.

• The prefixes related: and info: are used in the same way.

• Suppose you want to search only a certain website, not the whole Internet. You can use site: followed by the URL of the website you wish to search. But note that the search term here comes BEFORE the site:URL combination. (i.e, download linux site:www.linux.org).

• The only time the quotation marks are used in searching is when you are searching for a phrase which is not combined with any of the above mentioned prefixes.

  For example, "searching the internet" with quotation marks will search for the exact phrase and "searching the internet". If you write the same phrase without the quotation marks, Google will return results where the words "searching", "the" and "internet" appear, but not strictly in that order.

  Logically by using quotation marks when searching you will get fewer results but more relevant ones.

Powerpoint Shortcuts

Done with these Computer Tutorials, take me back to Windows Tutorials