Featured Articles

my key ring with Tile

Find Lost Items With Tile

Have you ever experienced the frustration of losing your keys and spending precious time looking for them? Instead of getting stressed, try one of these new Tile devices. They are small enough to fit on your key ring and communicate location information to your smart phone.

pzizz phone app

Relaxation Training with Pzizz

When I was young, I got into trouble for not taking naps. It was one reason I was dismissed from kindergarten. Years later, I look forward to my naps. This isn’t your average nap, but a short energizing power nap. Rather than having some teacher standing guard, I rely on software for my cell phone. You might think of it as high tech relaxation training.

flux settings

Reduce Computer Eye Strain & Sleeplessness with Flux

Are you finding yourself in front of the PC too many hours at night or when it’s dark? Maybe you’re doing work or just catching up with friends. The problem is the bright light from the display may be impacting your sleep and causing eye strain.

Accessing Contacts from Gmail

Clean Your Gmail Autocomplete List

Back in the old internet days, people rarely changed email addresses. Today is a different story with people changing jobs and having multiple email addresses. Sometimes email programs don’t want to let go of the old addresses and keep displaying them for us, which can present problems. This happened to a friend of mine who mistakenly sent an email to a colleague’s old work email address. I’ll skip the embarrassing parts and show you an easy way to remove these stale or unwanted addresses from the Google’s auto-complete list.


Select Random Names with Excel

Earlier this month, I got a request from a manager in town asking if I could randomly select 150 people from a membership list. No darts allowed. I think the purpose was to do a survey, but maybe it was to select contest winners. It turns out that Microsoft Excel has a random number generator which was the key to my solution.

Word header styles

Create a Letterhead Template with Word

Printed letterhead is nice, but can be costly. If you don’t print a lot of letters, you might be interested in creating your own letterhead. It just takes a few minutes using Microsoft Word to create a template file with your address and logo.

Create new group in Contacts

Create Distribution Lists in Gmail

Sometimes Gmail’s simplicity makes people think it is missing features. A case in point is distribution lists or group lists. Many people think that it’s not possible to send an email to a group of contacts or email addresses. The truth is that you can create personal Gmail distribution lists in a couple of easy steps by using Gmail groups.

VLOOKUP mapping

Learning VLOOKUP in Excel

As September approaches, I can count on a series of spreadsheet questions. One of the popular Excel tutorial requests is how do you look up a value on one Excel worksheet and use it on another Excel worksheet. For example, you need to translate a product number into a product name. One of my favorite Excel functions is the VLOOKUP function and it can help with this task. (Includes example spreadsheet.)