Excel is a great tool for data analysis, with a powerful suite of built-in functions to help. You’re probably already familiar with some...

In my last post, I talked about why you might use the VLOOKUP feature. If you missed it, you can find it here. Today, I’m going to...

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...

Just about all companies rely on electronic data these days, but not all companies can quickly and easily access their data. Here are a...

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...

Excel has some amazing report tools including charts and pivot tables. These tools are quick and easy to use, and produce some...

The other day I had a client ask me to create a reminder in an Excel document that would pop up several times a day. It had to run at...

Recording macros in Excel is an easy way to automate repetitive tasks. Maybe you receive a new file every month with your sales figures...

Excel or Access? Microsoft has lots of great tools, and in most cases, it’s pretty clear which you need to use. If you need to write a...

If you've ever thought about creating macros in Excel, you've probably heard the term "VBA". In this post, I'm going to give you a little...