Go Ask Debbie: December 2009

Wednesday, December 30, 2009

Organize Your Digital Photos

There are many ways to organize digital photos, but it can be overwhelming. Here are a few ways to make it a bit easier.

1. Windows makes it easy - you can select a group of photos, right-click and choose to rename them. Choose a name, such as "Christmas 2009 Photos" and Windows will rename all of them with that name and a sequential number. Not my best choice - if you're like us, you take a few different sets of pictures before you download them from your camera. But, it is a free and simple option.

2. Windows Live, by Microsoft, has a FREE downloadable program called Windows Live Photo Gallery. It allows you to tag photos and find them quickly.

3. Siren - also does bulk renaming, while allowing you to search by lots of different information that is collected from the file. It's Freeware, downloadable software.

4. Adobe Photoshop Elements 8 - one of my favorites. It's a much cheaper version of Adobe Photoshop, but it still has many features of the full version. The newest version is very user friendly and adds an organizational element that makes it very easy to create a photo album that is searchable by a lot of different information collected from the file.

Try any of these (Adobe has a Free Trial) and see which one works best for you.

Friday, December 18, 2009

Mouse-less Right-Click

People are always asking me how I am so fast on the computer. My answer is that I try to keep my hands on the keyboard and avoid the mouse as much as I can. Really? Yes, really!

There are many shortcuts I have provided in my Tips and Newsletters and I will continue to do so. One easy one that many people do not know is that you can use your Keyboard to do a Mouse Right-Click. You've been told for years to Right-click whenever possible to receive shortcut menus. Well, you do not need your mouse to perform a Right-click.

Find the button below on your keyboard. It is usually located next to the CTRL button.

Simply press the ALT key and this button and the right-click (or shortcut) menu will appear.

Use your arrow keys to navigate the menu and press ENTER to select an item.

HINT: Shift + F10 also works to perform the mouse right-click.

Friday, December 11, 2009

Create Excel Forms

There are a few ways to create forms within Excel. Here, I will show you (in my opinion) the easiest.

An easy example to use is a Timesheet or Expense form.

First, type in the information as you would like it captured. You may type in the line descriptions or categories for the Expenses and place colored cells for the areas in which you want users to type in their actual expense amount. Once the form is created, you will "unlock" the cells (the colored cells in my example) that you wish the user to input data.

To do this, click on Format Cells and click on the "Protection" tab. On this tab you will notice that the cells are "locked" by default. Simply uncheck the box and click OK.

Next, click on Tools Protection and choose "Protect Sheet" (or "Protect Workbook" if you are working with more than one Sheet). This will open a separate window asking you what you would like to protect. In the "Allow all users of this worksheet to" area, make sure the only item checked is "Select unlocked cells".

NOTE: When you are Protecting a Sheet or Workbook, Excel will ask you for a password. Make sure you choose a password if you do not want users to edit the form. Excel does NOT require you to use a password.

Finally, click File Save As and choose "Excel Template" from the "Save as Type" drop down. This will save your file in the default folder. If you are working on a network, be sure and get with your administrator for the exact location to save this file.

Now that you have saved your form, users will simply click File New and choose "on my computer" for the location of the template. Once the users double-click to open the template, they will only be able to type information in the unlocked cells.

Tuesday, December 1, 2009