VLOOKUP is one of the coolest features of Microsoft Excel, and also one of the least understood. Lots of people are interested in it and have great cases for using it. But I get many people who tell me that they don't use it because they don't really understand how it...

Just about all companies rely on electronic data these days, but not all companies can quickly and easily access their data. Here are a few of the common mistakes that I see frequently.

• Some companies keep their data in text documents, overwriting the existing data...

If you’ve ever written VBA code in Excel, Access, or any of the other products in the Microsoft Office suite, you may already be familiar with Option Explicit. If you’re not, it'll be worth a few minutes of your time to learn about it. It’s a useful tool that will save...