Excel

Below is a list of the Microsoft Excel tutorials that we’ve written. Many include step-by-step instructions. In some cases, there may be sample spreadsheets or video screencasts.

I’ve also been updating these articles to reflect the latest Excel version. Presently, I’m using Microsoft Office 365. However, you may see some tutorials that reflect older versions. All the screen snaps have been done on a Windows computer and reflect those commands.

If you don’t have Microsoft Excel, there are three options:

  1. Get an Office 365 (Subscription service)
  2. Buy Microsoft Office 2019 (One time purchase)
  3. Use the free version in your browser.

The free version does require you to have a Microsoft account. As you might expect of a free product, there are limitations. For example, you can open a workbook with macros, but you won’t be able to edit them.

You can read more about the different options on the Microsoft site.

Microsoft also has an Excel Glossary that you can use.

excel with filter criteria displayed

Use VBA Function to Show Excel Filter Criteria

Have you ever received an Excel file and wondered how it was filtered without checking each column’s data filter? Or,
Read More
Autofiler set and drop-down entries in menu.

Excel AutoFilter Makes Spreadsheets Useful

Learn how to use Excel autofilters to make large spreadsheets more manageable. This feature lets you filter columns by specific entry values. Includes sample spreadsheet.
Read More
Excel sheet with added column indicating word count

Excel Word Count Formula

Recently, I attended an industry summit that had an expert’s panel where people provided their best tips. One Excel tip involved filtering cells with a certain number of words. A nice tip, but it left some attendees wondering where is Excel’s word count function. The program doesn’t have this feature, but you can get the answer by creating an Excel formula to count words. (Includes sample Excel worksheet and formula)
Read More
Example of dropped zero in zip code

Keep Leading Zeros in Excel

Excel is a very powerful program, but sometimes it doesn’t act the way we wish. A case in point is importing a CSV file with zip codes. If you’re not careful how you open your file and apply different formats, you could be in for some surprises. The same problem can happen with part or order numbers.
Read More
Function Arguments dialog with cell C2 in Text field.

How to Count Characters in Excel

Excel has a built-in function called LEN that counts the number of characters in a cell. This can be very useful for counting characters and finding problem records.
Read More
Convert Word Table to Excel

Convert Word Table to Excel

In our earlier article we explained there were several ways to convert Microsoft Word data such as address listings to Microsoft Excel. This next method starts by converting your text to a table. You'll probably find this method easier.
Read More
Convert Word Docs to Excel

Convert Word Docs to Excel

One item I've learned from using computers is that there is usually more than one way to solve a problem. This week two people approached me with a similar problem. They were trying to get a simple, but long address list from Microsoft Word into Microsoft Excel. One tried to use macros and the other resorted to cut and paste. In each case, I thought a simpler solution involved Word's Search and Replace feature. Here's Part 1 of a two part tutorial.
Read More
excel dependent list

Limit Excel Mistakes with Dependent Drop Down Lists

This Excel tutorial shows you how to build a worksheet using dependent lists. In other words, the selection you make from one list defines the options on the next list. For example, if you select California from one list, the next list filters your selection to just California agents. Includes sample Excel worksheet.
Read More
Excel table example

Excel Table Offers Hidden Benefits

Yogi Berra once said, "You can observe a lot by just watching". In this case, I was watching someone work with Excel doing various things to make the spreadsheet more usable. I suggested to my co-worker that he could reduce steps by creating an Excel Table. And no, I'm not talking about pivot tables but something much simpler and equally powerful.
Read More
mail merge wizard menu item

Word Mail Merge Using Excel

This tutorial shows how to use an input file from Microsoft Excel as the data source to do a mail merge in Microsoft Word.
Read More