Friday, January 29, 2010

Learn Word - Personalized Bullets

We've all seen it, the bullets setup in a Word document that look like someone just chose a template or clicked on the button for bullets on the toolbar. But, if you've seen bullets that have a company's logo or another word or picture, you probably think they had special programming skills... Well, it's actually very simple.

To personalize bullets in Word, follow these simple steps:

1) Highlight the text you wish to add bullets.
2) Go to Format | Bullets and Numbering
3) Click on a Bullet and click on the "Customize" button in the lower right corner of the window.



4) On the Bullet Tab, you may choose from a Character preset within Word OR click on the "Picture" button and locate a picture that you wish to use.



5) Click OK to return to your document and you will see your personalized bullets.

NOTE:  If you wish to add a word, on Step 4) Click on the Number Tab and then the Customize button.  Next, type in the Word you wish to have for your bullets.  Click OK to return.

It really is that simple to personalize bullets in Word!

Thursday, January 21, 2010

Netbook Comparisons

Netbooks are the new Laptops.  They are a less expensive option and provide online access to the Internet, including Webmail and many other tools you may use while on the Internet.  With all of the new online software, there may not be much of a need in the future to have software installed on your computer - thus, making these Netbooks a very good choice for those "on the go."

Below are a few Netbooks.  Important features you may want to compare are Battery Life, Screen Size, Memory, and WiFi compatibility.  Read through them to find which one best fits your needs.








Friday, January 15, 2010

Disappearing Zeros in Excel

I hear this question a lot - In Excel, when I type in a number that has Zeros at the beginning (like a Zip Code), the Zeros disappear - how can I get them back?

First, you need to realize that Excel sets a format for every cell.  The default format depends on the information you type, as Excel tries to read your mind.  Computers are not always good mind readers.

For example:  When you type text in a cell, Excel sets the format of that cell to "text".  When you type a number, it sets the format of that cell to a number.  So, when you type in a Zip Code of "00123", Excel tells you that there are no Zeros needed and places the number "123" in the cell.
 
A quick fix for this is to Right-Click the cell and choose "Format Cells."  In the Format Dialog Box, choose "Custom" and in the "Type" field, type the number of digits for your numbering.  So, in the Example above, you would type "00000" as Zip Codes contain five digits.
 
Once you click "OK", your Disappearing Zeros will Reappear!
 
If you have a group of cells that do not contain a specific number of digits, then you will need to use a macro.  Look for future advanced training on Macros for that fix.

Thursday, January 7, 2010

Online Weight Loss Tracking

Today's resolutions for weight loss can be made a lot easier with online weight loss tracking sites.  These sites provide an easy way to enter information such as food you've eaten and they often have caloric information for typical foods, including popular restaurants.

Check out some of these sites and hopefully one of them will fit your needs to meet your goals for 2010!

Spark People

Fit Day

My Health & Fitness

Med Help

Monday, January 4, 2010

Go Ask Debbie - January Newsletter

Here's the link to the latest Go Ask Debbie Newsletter. With Go Ask Debbie, you'll find training and tips on many popular computer software programs, such as Microsoft Word, Excel, Outlook, PowerPoint, Intuit QuickBooks, and more!

http://campaigns.ratepoint.com/campaigns/cfd595848f61a7b6f4e04842074b8c36

How to Delete Blank Rows in Excel