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

Find Word Count in Excel Cell

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
Find & Fix Excel Formula Errors

Find & Fix Excel Formula Errors

Sometimes the best way to learn something is from our mistakes. There have been countless times where simple Excel formula
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 Tables 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

Mail Merge Tutorial Using Word and 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