 |
Computer Training School |
|
2 Airport Road, Gilford, NH |
|
Computer Training School |
|
2 Airport Road, Gilford, NH |
|
Home Page
Workshop
Schedule Reschedule
/ Cancellation Policy
|
Table of Contents MS Excel Articles
Importing Photographs to an Excel Chart Did you know that you can import a picture from a digital camera or a scanned photograph into an Excel pie or donut chart. This is a creative way to display pictures that represent areas of your business. For example, a school district would show images of the different schools, a manufacturing plant may want to show parts they produce or a bank may want to show different branch locations.
Word Shortcut Keys Word - Traps Creating Symbols º ± ¢ . ê : à ü M · © Do you need an accent over a letter, for example: Pokémon. To include a symbol in a document: - Click Insert on the menu bar
Using Word Page Borders To add a Page Border: Shrink to Fit... - Click File on the menu bar. If the Shrink to Fit feature is not appropriate, you can also change the page margins (File, Page Setup) or highlight text and reduce the font size. Problems opening attachments? The problem may not be you. If your computer does not have the same program that was used to create the file, your PC will not know how to read the file format. Unfortunately, your options are to buy the software or ask the sender to save the file into a different format and resend the file. Have you created sub-folders under the Inbox to store your messages in and now they’re gone? Click the + in front of the Inbox folder to expand the branch of sub-folders.
If you use the Calendar feature to track appointments, Outlook automatically checks the box to set a reminder. To turn this setting off for all future appointments:
Have you noticed when you print a website that you are wasting a lot of ink on information you do not need printed? Try this: Turn off the option to print background color and images in your browser window:
If you want to print selected parts of a site, try copying and pasting the information you want into your word processor:
The whole point of Email is to communicate a message quickly, easily and clearly. While you should conform to the parameters and form of "good English," do not let such usage take the place of common sense. Use meaningful subject lines in order to get your recipient's attention. Write short, easy-to-read sentences. Remember. the average newspaper is written for someone with a seventh-grade education. Avoid pronouns, be specific. Save your multi-polysyllabic diatribe for your college term papers. Write short paragraphs. Leave plenty of "white space" in order to make reading easier. If you have any control over your mailer program, avoid outrageous coloring and hard-to-read screen display fonts. Most of all, the most important advice is to read your Email message, re-read it and re-read it again to make absolutely sure it is error free and says exactly what you want it to say. Working with Pictures in Email and the Internet If you have an Internet account, you will eventually want to know how to work with photographs or graphic objects. This article will address a few of the common questions.
There are 3 basic ways a picture becomes a file in your computer: 1 -Use a digital camera to snap the photo and download the file into your computer. 2 - Scan a standard photograph with a scanner. 3 - Request that your film be developed and stored on diskette. Depending on where you have your file developed you may have to wait longer and there will be an additional charge. How do I Email a picture? Using Outlook Express or Netscape Mail, create a new Email message. Specify the Email address, subject and type your message as usual. In the body of the message window, start a new paragraph by pressing the Enter key. Click Insert on the menu bar and choose Picture (choose Image in Netscape Mail). Click the Browse button and switch to the folder that your picture was saved in. Double-click the photo file name and click OK. The picture should appear in the body of the message. If the photo needs to be resized, single click in the middle of the photo. Selection handles will display on each corner. Position the mouse pointer on a corner. Your mouse will change to a double-headed « arrow. Click and drag outwards to enlarge the photo or drag towards the center of the picture to make it smaller. Complete the Email message and click Send. Can I resize a picture that I “receive” in Email? Most Email programs do not allow you to select/resize a photo in the body of an incoming message. However, you can copy the image and paste it into another program that does allow resizing or editing. For example, you can paste it into Microsoft Word, Publisher, PowerPoint, or any photo editing program. To copy the photo, open the Email message to display the photo. “Right” click in the middle of the photo. A short cut menu will display. Click Copy with the left mouse button. Minimize or close your Email window and open the application you will use to edit the photo – for example, Microsoft Word or Abobe Photo Deluxe. Position the insertion point where you want the photo, click Edit on the menu bar and choose Paste. When the photo is selected, resize handles display on each corner. Position the mouse on a corner where your mouse changes to a double-headed arrow and click and drag to resize the photo. The application you use determines the limitations of working with the photo. For example, MS Word will allow you to paste multiple pictures on the same page but editing the photo to adjust brightness, contract or red eye will not be available. On the other hand if you use a photo editing program like Adobe or Ulead, you can adjust the colors in the photo but can only print one picture on a page. Can I copy a picture from an Internet web site? In most cases, yes. It has become common for family and friends to post wedding, baby and family photos on a personal web site. A standard photo can usually be copied. However, if the photo is an animated object or a background object you may find the copy feature is not available. To copy a photo, display the web site and “right” click in the middle of the photograph. Click Copy with the left mouse button. Switch to Microsoft Word or any program that can handle pictures and choose Paste. NOTE: When you copy photos from a web site, you should honor all Copyrights. If necessary, contact the company or individual that owns the site and request permission first. When was the last time you updated your virus software? Has your computer slowed down drastically? Do you tend to get unexplained errors that you haven’t seen before? These can be signs of a virus. Hyslop & Associates offers a clean-out service to keep your computer running smoothly. If you have an Internet connection, your computer should be setup to automatically download the latest virus definitions on a daily basis. If you’re not sure how — give us a call. What type of CD drive does your computer have? CD-ROM — Read Only MemoryWhat’s the Difference? For many years PC manufacturers have included the CD-ROM drive as a standard feature. ROM stands for Read Only Memory which means you can not save or delete a file on a CD — it is readable only. Many computers on today’s market include a CD-RW or CD-R drive. A CD typically holds up to 650 MB of data, whereas a floppy diskette holds 1.44 MB. Many people are using the CD-R or RW to make copies of user data and to store photographs. The CD-R is less expensive but information can only be recorded to the disk once. Recordable CDs are WORM (Write Once, Read Multiple) media that work just like standard CDs. The advantage of CD-R over other types of optical media is that you can use the disks with a standard CD player. The disadvantage is that you can't reuse a disk. A related technology called CD-RW (CD-ReWriteable) can be written to over and
over again. The CD-RW
allows you to erase disks and reuse them, but the CD-RW media doesn't work in
all players. CD-Rewriteable drives are able to write data to both CD-R and CD-RW
disks. Protect
Your PC from Lightning Could your computer take a lightning strike? Think twice before you answer Yes! Your computer may be plugged into a surge suppresser, but what about your phone line? If you use a dial-up connection to access the Web, make sure the phone line to your fax/modem is routed through a surge protector. If the phone line from your PC is connected directly to the wall, a lightning strike could ZAP your modem and cause major damage.
Many websites include a drop-down menu where you choose from a list of states or locations that are in alphabetical order. In our Internet class, I have been teaching students to click on an item in the list and then type the first letter of the location you are looking for. In the diagram above, this would take you to Nebraska. Linda pointed out to the class, that if you keep pressing N it moves down the list. For example, pressing NNN would find New Hampshire and NNNNNN would find New York. Using a PC you can prepare and file your income taxes on the Internet. If you are expecting a refund it usually takes about 2 weeks if you choose to have the money deposited directly into your bank account. There are 3 basic methods you can use to file your income taxes on-line: Purchase commercially available software. Many local stores that sell computer software stock programs for preparing your taxes on your home computer. The most common are Kiplinger TaxCut and Quicken TurboTax. Prices range from $10-50 depending on the version you purchase. These programs use a step-by-step interview that creates the forms for you. The final step in preparing your return will ask if you want to file a traditional paper return or e-File on-line. Download software from an Internet site and prepare your return offline. Most of the companies that sell tax software also provide an option to download the software directly from their web site rather than purchase the program at a local store. The price is usually the same and the filing procedure will be the same as described above. Prepare and file your return on-line. There are a few web sites on the Internet that allow you to create your return through their site without downloading any special software. For example, www.hrblock.com or www.CompleteTax.com. For more on-line filing information, visit The Internal Revenue's official web site at www.irs.gov.
Copyright 2010 Hyslop & Associates 2 Airport Road Gilford, NH 03249 (603) 528-6660 Email: admin@hyslops.com
|
|
|
To
import a saved photo into an Excel donut or pie chart:
What
do I use to create a picture?
Many of the tips and tricks
that I know I have learned from my students. Credit goes to Linda Karr from
Bristol for this month’s tip.
