Featured Articles

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.

excel-randbetween-1

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.

Using Run to reregister a DLL

Microsoft Outlook Hyperlinks Fail to Work

Sometimes you don’t realize how much you appreciate a feature until it breaks. One example is Outlook hyperlinks in an email. It’s so convenient to click the link in the email and have the correct web page open. What I dislike is when a hyperlink in Outlook doesn’t work and I get some error or no action. Below, I’ve listed 4 solutions to this link problem.

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.

browser cookies dialog

Browser Cookie Basics

There’s little question that a big drain on productivity is worry. Many of us tend to worry about things that are out of our control. One item that I think too many people worry about is browser cookies. Browser cookies are neither good nor bad. If you were to remove all cookies, you’d probably find your internet experiences to be less enjoyable.

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