Back to Back Issues Page
Understanding the Basics of Computers, Issue #018
January 11, 2011

Ezine issue 18

Understanding the Basics of Computers

Your source for computer tips and tricks for the beginner computer user

January 2010 Issue 18

HAPPY NEW YEAR!! Welcome to the January issue of Understanding the Basics of Computers. Is everyone ready for a great 2011. I trust everyone had a fun filled new year. I hope the articles I have chosen in this issue help you with your computer problems or teach you something you didn't know before.

For all of my readers in the Denver metro area, please consider my one-on-one training. The cost is $40.00 for a 1 hour session. All lessons are project based and if you don't feel like you learned everything you anticipated I will work with you free until you understand. Please contact me if you are local to the Denver metro area and interested in a personalized training session. If you are not in the Denver area please and interested in one-on-one training please contact me and I will try to help you find someone in your area read more at .

The Training Videos that I promised are now available for purchase. Visit . The Video tutorials are reasonably priced and you are able to purchase them on individual topics or as a package for a discounted price. Put code NL18 in the comments section when purchasing and I will send you the beginner Windows 7 video tutorial free with the purchase of any package.

If you have any suggestions for the website please email me at and let me know what you think or what you would like me to add.

In this issue:

  • Create a chart in Excel 2007
  • Wrapping text and creating line breaks in Excel 2007
  • Print good quality digital photos at home.

Create a chart in Excel 2007

To insert a chart into Excel 2007 click on the Insert tab. All of the chart options are in the chart section. You have the option of choosing one of the six default charts or click the down arrow of the other charts button and click all type of charts. This will open the insert chart window. In this window you have more choices. Click on the type of chart you would like to create. This will place a chart in your Excel spreadsheet.

The chart tools will now be available in the ribbon tab. Click on the select data button. The select data source window will open. In this window click and highlight the data that you would like your chart to include. The window will remain open until you have selected your data and clicked OK.

Any time changes are made to the data the chart will automatically update. You can change the axis labels using the horizontal axis edit button.

Anytime you would like to make changes to the chart click on it and the tool bar will reappear with the design layout and format options.

For more detailed information visit

----Visit this link Download CoffeeCup HTML Editor - Click Here to download CoffeeCup HTML Editor. This is a great program to design your own website. ----

Wrapping text and creating line breaks in Excel 2007

Formatting cells in Excel 2007 to show wrapping text and line breaks is different than using Word. By default Excel will run a line into the cell to the right if the text will not fit into the designated size of the cell.

To get text to move to the next line without using another cell is called a line break. The keyboard method is to hold down the alt key and press enter. This can only be done when you have the cell active. To get the cell active either press F2 or double click on the cell.

To wrap text automatically in conjunction with the size of the cell all you need to do is click on the cell or cells you would like to have text wrapping and in the Home tab of the alignment section click on the Wrap Text button. This will wrap the text of each cell selected.

Print good quality digital photos at home.

  • Don't skimp on the dots per inch. When you are buying a printer for printing photos take a look at the DPI The higher your printer's dots per inch (dpi) specifications, the better the prints it will produce. Avoid images which suffer from frayed and jagged edges by using a printer with 600 x 600 dpi or better printing capabilities when producing hard copies of color digital photos.
  • After installing your printer, check your owner's manual for instructions on how to change print quality settings. Remember that it's always important to choose the right print options and preferences before printing.
  • Different types of paper, such as high gloss or card stock, require varying amounts of ink and touch-ups. When setting printing preferences, be sure to tell your printer which type you're using to help ensure first-rate results and to avoid wasting expensive stock.
  • It's a good idea to run printer alignment, color calibration, and print cartridge cleaning functions every 90 days. These practices help prevent blurring, streaking, and off-center photo prints. See your printer's owner's manual for instructions on how to perform this maintenance.
  • Standard printer paper isn't suitable for creating pleasing photo prints. Unless you're printing documents, choose a glossy or matte finish photo paper instead. Black and white prints generally look best on matte finish papers, and color tends to look best on glossy paper.
  • Choose the right size for you photos. Photos come in many shapes and forms, from wallet-sized (2.5-by-3.5-inch) to album/scrapbook-ready (4-by-6-inch or 5-by-7-inch) prints. Match the paper to fit. Alternately, choose a standard letter-sized (8.5-by-11-inch) paper and use Windows Photo Gallery or Windows Live Photo Gallery to squeeze several smaller images onto one sheet.
  • Before placing photos in an album or framing them, give the ink approximately 12 hours to dry.

----Visit this link to learn more about the wonderful SBI opportunity that has given me the freedom to work from home at any hour of the day or night. It is so simple with the easy to follow video tutorials. Everyone has a wealth of information that they should share. All you need to do is write down what is in your head and create a website. Visit the above link and see how SBI has changed so many people's lives. ----

Tutorials added this month will be PowerPoint 2007, Building a website.

I hope this issue of Understanding the Basics of Computers was helpful. If you have any suggestions for next months issue or comments on this issue please let me know.

Keep learning about your computer,
Jennifer Anderson

P.S. Look for the donate button on a few of the webpages. If you would like to help keep this site going any amount helps.

Back to Back Issues Page