Tutorials

This site has many tutorials, and I don’t think it would be efficient to list them all because you’d have to click through many pages. Instead, I opted to show the Top 10 (Reader Favorites) across all categories. The Top 10 list will change over time, and new categories may appear.

I think this is a better user experience, but I’d be interested in your thoughts.

You can also skip this list and jump to a specific category and its listing. Or, you can always use the Search function on the main menu.

Google Tutorials
Microsoft Excel Tutorials
Microsoft Word Tutorials
Microsoft Outlook Tutorials
Terms to Learn

Top 10 Tutorials

Create a Letterhead in Microsoft Word

Printed letterhead stock is nice, but can be costly. If you don't print a lot of letters, you might want to make your own letterhead in Microsoft Word. It just takes a few minutes to create a template file with your address, logo, and other items you want. This is a great solution for solopreneurs and small businesses.
Read More

How to Transpose Excel Columns to Rows

Everyone looks at data differently. Some people create Excel spreadsheets where the main fields go across horizontally in a row. Others put the data vertically. Sometimes these preferences lead to a scenario where you want to transpose Excel data. Transpose is an Excel function that allows you to convert Excel columns to rows without retyping the data. (Includes sample worksheet)
Read More

How to Separate Names in Excel

Recently, a friend asked about fixing an Excel spreadsheet where the subscriber name was in 1 column. He wanted the name separated so he could send a personalized mailing. This is not the first time this question has arisen. The key to solving this problem is to parse or split the data using the Text to Columns feature. Includes workaround when you have middle names or initials too.
Read More

Spell Check Not Working in Word

Ever have one of those days where you're trying to get out an important document, but you find the spellchecker in Word isn't working? Sometimes you can't check a specific document and other times you can't spell-check any documents. Either way, you might try some of these quick solutions.
Read More

How to Clean Your Gmail Auto Complete List

Back in the old days, people rarely changed email addresses. Today people change jobs and have multiple email addresses. Some email programs don’t want to let go of the old addresses. This can cause problems with auto-complete. This happened to a friend with Gmail. She mistakenly sent an email to a colleague’s old work email address. I’ll skip the embarrassing parts and show you how to delete an email address from Gmail.
Read More

How to Do VLOOKUP in Excel

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 and video.)
Read More

Goal Seek dialog with change cell reference.

Excel Goal Seek Offers Quick Answers

Do you ever play the "what-if" game when you see Excel data? For example, how many more widgets would we need to sell to get our 20% bonus? In my case, I was trying to figure out many more voters we needed to win a ballot measure. Excel has a simple feature for these scenarios.
Read More

Easy Formulas to Extract Text from Excel Cell

Excel is a great tool, but sometimes the spreadsheet files we get aren't ideal. A classic example is you're given a file that has one column that you'd really like to split into multiple ones. That was the scenario I faced when I got a large file with the street addresses in one field. Using the LEFT and RIGHT text formulas, I was able to have Excel extract text substrings into two new fields.
Read More

Simple Ways to Mass Delete Gmail

One bad habit I have is letting my Gmail inbox get too big. I don’t always delete emails as fast as I should. These accrued items tend to be non-urgent items I get on a recurring basis that I haven’t flagged as a priority. Eventually, I reach that tipping point and want to delete these Google emails in mass. There are many ways to delete Gmail items, but here’s one tutorial that requires minimal effort and you can do at your own pace.
Read More