Back to Back Issues Page
Understanding the Basics of Computers, Issue #019
January 31, 2011

Ezine issue 19

Understanding the Basics of Computers

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

February 2010 Issue 19

Welcome to the February issue of Understanding the Basics of Computers. February is going to be a great month for Computer Tutorials. We have new pages coming out every week and the video tutorials are taking off as well. . 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. If you do not see a video tutorial online that you are interested in please email me as it may not be posted yet. 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:

  • Print Envelopes & Labels in Word 2007
  • How to create digital photo album presentation in PowerPoint
  • How to protect MS Excel file using a password

Print Envelopes & Labels in Word 2007

Printing envelopes & labels in Word can be a time saver and make your business look more professional. All of the features you need to print envelopes and labels are in the Mailings ribbon tab.

Click on the Mailings tab. The first section Create has the Envelopes and Labels buttons. Click on the Envelopes button first. This will bring up the Envelopes and Labels window. The envelope tab will already be selected. In this window if you are doing only one envelope type the address of the recipient your return address, then click on the envelope icon to change the size of the envelope you will be printing on. The icon next to the envelope shows you the direction to load the envelope into the printer. Click the Print button when you are finished.

If you are printing more than one envelope I would recommend using the mail merge features to print your envelopes. Click on the envelopes button again this time select the size of the envelope and click add to document. This will place the correct size print area for you envelope into your word document. From there you can type in any location and add the mail merge features. If you would like more information on mail merge visit

To create a label click on the Labels button in the create section of the Mailings ribbon tab. This will again open the Envelopes and Labels window but it will be open to the Labels tab. In this tab you can either create one label or a whole page of labels. To create one label type the information you want in the address section then select the radio button that says single label. If you have already printed labels on your sheet you can select the row and column that the next available label should print on. Click on the label to select the size of label you will be printing then click print.

If you are printing multiple labels keep the Full page of the same label selected. Select the size of the label and click add to document. If you don't want all the same label leave the label blank and you can fill in the labels when the document is created. When the document is created with the labels you can print the same way you print a regular document using the print key.

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

How to create digital photo album presentation in PowerPoint

A digital photo album can be a fun way to share your photos with friends and family. You can get creative with your slide transitions and put multiple photos on a slide.

Open PowerPoint 2007 and click on Layout in the Slides section of the Home tab. Select picture with caption. This will change the layout of your slide. Click in the box that says click to add picture. This will bring up your browser window. Browse to the picture(s) you would like and click OK. This will insert your picture into PowerPoint. Add you caption then click on the down arrow of New Slide. Select the Picture option again and repeat the above steps. When you have inserted all of the pictures click the Animations ribbon tab. In the Animations section select an animation you would like to use to transfer to the next picture slide. When you have selected an animation for each slide Click on the Slide Show ribbon tab and click on From Beginning in the start slide show section. This will give you a preview of your presentation. When you are happy with what you created. Click the Office Icon and select Save at and click on PowerPoint Show. This will save your presentation as a slide show. Every time you open it it will play in the slide show form.

How to protect MS Excel file using a password

In Excel 2007 you can protect your spreadsheet, your entire workbook or specific cells. To get started click on the Review ribbon tab. In the changes section you will see a series of buttons. The first one is Protect Sheet. Click on this button and the Protect Sheet window comes up. Type a password in the text box. Any using opening this worksheet will need to enter the password before doing any of the tasks that you have not selected. To give permission for access to certain features check the boxes in the Allow users of this work sheet to: section. Click Ok when you are finished

To protect the entire work book click the Protect Work book button this will bring up the Protect Structure and Windows window. The structure option will prevent a user from:

  • Viewing worksheets that you have hidden.
  • Moving, deleting, hiding, or changing the names of worksheets.
  • Inserting new worksheets or chart sheets.
  • Moving or copying worksheets to another workbook.
  • In PivotTable reports, displaying the source data for a cell in the data area, or displaying page field pages on separate worksheets.
  • For scenarios, creating a scenario summary report.
  • In the Analysis ToolPak, using the analysis tools that place results on a new worksheet.
Selecting Window will prevent the user from:
  • Changing the size and position of the windows for the workbook when the workbook is opened.
  • Moving, resizing, or closing the windows.
  • Type your password and click OK to protect your workbook.

----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 Font, PowerPoint 2007 Slides, and PowerPoint 2007 Paragraph

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