Sunday, May 30, 2010

How do I use AutoFilter in Excel?

Have you ever searched an entire Excel spreadsheet for data that matched certain criteria?

Use the AutoFilter in Excel and you will be able to find data much quicker.

To do so, simply follow these easy steps:

Excel 2007:
With your list open, click on the "Data" Tab on the Ribbon.  On the Data Tab, simply click the "Filter" button.

Notice your data Headers all have Drop Down Arrows next to them.

Now, simply click on the Drop Down Arrow of the Header (or Column) that contains the data in which you wish to search.

You may search for a specific item from the Drop Down list OR you may click on "Number Filters" from the Drop Down and another sub-menu will appear giving you options to search on items Greater than a particular number, etc.

Excel 2003:
Click on the Data Menu and choose "AutoFilter" and then follow the steps above.

It's that simple!

Saturday, May 29, 2010

How to Change the Default Font in Outlook

Many people do not like the Outlook Default Font of Arial.  This font is a default because it is easiest to read and is a standard font that will work correctly within most e-mail software programs.

However, if you wish to change the Default Font, you may do so very simply.

To do so, follow these simple steps:

Click on Tools | Options.

Click on the Mail Format Tab.

On the Mail Format Tab, click on "Fonts".

Once in the Fonts Window, you have some options.  You may choose to change ALL Fonts or just one or two.  Click on Choose Font to change any of the font options:  New Messages, Reply and Forwarded Messages, and Messages in Plain Text.

Once you've made your changes, continue to click OK until you are back in your Outlook Window.

It's that simple!

Thursday, May 20, 2010

PowerPoint Master Slides

PowerPoint has the option for "Headers and Footers" much like Word and Excel.  However, it is very limited.

To create Headers and Footers that are not limited, use Master Slides.

To do so, follow these steps:

PowerPoint 2003 (and older):

Click View | Master and choose which Masters you wish to apply your changes.

Once in the Master, you may add whatever you wish to appear on every slide.  For example, you may wish to add a Logo in the background and you may wish to add a Header and/or Footer.  Just remember that everything you place on the Master Slide will appear on every slide.

Once you've made your changes or additions, remember to click on View and go back to "Normal".  This will ensure you are no longer working in the Master Slides.

PowerPoint 2007:

Click on the "View" Ribbon and choose the Master Slide you wish to apply your changes.

As with 2003, make any changes and additions you wish and they will appear on every slide.  However, there is a small difference in 2007:  you can make changes to each layout style within the Master Slides.

Now, your PowerPoint presentations can and will look very professional.  It's that simple!

Friday, May 7, 2010

Change Windows Folder Image

With all of the folders people create these days, it can sometimes seem very difficult to find a particular folder when searching.  This is especially true when searching through the "My Pictures" folder.

However, there is an easy solution.  You can change the Folder Image.

The default image for a folder is the picture of a folder.  However, the Folder Image is just that, an image.

If you would like to change a particular folder image, follow these simple steps:

1)  Right-click on the Folder and choose "Properties"

2)  In the Properties window, click on the "Customize" Tab

3)  Click on "Choose Picture" and find a picture in your computer that you'd like to use for this particular folder.

4)  Click "OK" and notice the changed Folder image.

Continue to do this for any folders you wish to change.  It's that simple!

Saturday, May 1, 2010

Go Ask Debbie - May 2010 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!

How to Delete Blank Rows in Excel