Back to Back Issues Page
Understanding the Basics of Computers, Issue #021
April 27, 2011

Ezine issue 21

Understanding the Basics of Computers

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

April 2011 Issue 21

Welcome to the April issue of Understanding the Basics of Computers. 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 and are 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 NL21 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:

  • Slide Transition PowerPoint 2007
  • Converting Text into Table Word 2007
  • Splitting a Single Cell into Multiple Cells

Slide Transition PowerPoint 2007

Transitions in PowerPoint are the motions from one slide to the next. You can get very creative with this feature. The transition feature is in the Animation tab in the transition to the slide section.

The first buttons in the transition to the slide section are all transition motions. You can also use the down arrow keys to see more motions. By placing your mouse over the button you will see a preview of what the transition will look like in the slide show presentation. You can also insert a sound to go with your transition. This button is located next to the motion transitions. Click the down arrow next to sound to see a list of sounds and click on them to hear a preview.

You are able to apply you selections to just the current slide or use the apply to all option to apply it to your entire presentation.

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

Converting Text into Table Word 2007

There are times in word that you would like to use tables to sort and organize your document or display a table for data. If you have all of your data already typed in your Word 2007 document you don't want to retype it.

To convert text to a table highlight your text and click on the Insert tab. In the Tables section of the Insert tab click the down arrow on the Table button. Below the row/column section you will see an option that says convert text to table. Click this selection. This will open the convert text to table window. In this window you select the number of columns, how to fit the text, and how to separate the text into columns. When you are finished with your selections click OK and the table will be created.

----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. ----

Splitting a Single Cell into Multiple Cells

In Excel 2007 you can change the format and division of cells after you have text inserted. You can unmerge cells if they are merged using the merge and center button in the alignment section of the home tab. Click in the down arrow and select unmerge cells.

You cannot split a cell or range of cells that was not previously merged. You can, however, divide the contents of unmerged cells and display them across other cells.

Select the cell, the range of cells, or the entire column that contains the text values that you want to divide across other cells. A range can be any number of rows tall, but no more than one column wide.

Unless there are one or more blank columns to the right of the selected column, the data to the right of the selected column will be overwritten.

On the Data menu, click Text to Columns.

Follow the instructions in the Convert Text to Columns Wizard to specify how you want to divide the text into columns.

If you have a specific question about one of the selections do please email me at or call me at 303-931-2206 and I will help you.

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