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)
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
Easy Formulas to Extract Text from Excel Cell
Excel is a great tool, but sometimes the spreadsheet files we get to work with aren’t ideal. One example is a file with a data column, maybe a street address, that you’d really like to pull parts. In this tutorial, I’ll show how to extract text from a cell in Excel using some useful text functions. (Includes practice workbook.)
How to Use 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.)
How to 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.
Word Spell Check Not Working
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.
Easy Ways to Bulk Delete Gmail
Are you like me and have a habit of letting your Gmail Inbox get big? Many of my emails are not a priority, such as promotional emails. In this tutorial, I’ll show you how to bulk delete emails on Gmail using email addresses, text patterns, dates, statuses, and search operators.
How to Delete an Email Address from Gmail
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.
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.
Taking Control with Hosts Files
One of the lesser known, but important files included with Windows is the hosts file. It’s a simple text file without a file extension that was designed to map or override IP addresses before accessing a domain name server. Recently, it’s taken a more protective role in ad blocking and stopping spyware.
How to Compress a Word Document
Conveniences come at a cost and Microsoft Word documents are no different. Some of the features we use can lead to large file sizes. This can be an issue if you’re low on disk space or you need to send these files as email attachments. Many ISPs and companies have a size limit for email attachments. Here are five quick tips to compress Microsoft Word files.