Someone asked me how to make a data validation drop down that only shows the visible rows from a filtered list. I created a sample file that shows how you…

When you first start to use Excel, you probably work with files that somebody else set up. Eventually, you're ready to build a workbook of your own, and this video…

In a perfect world, nobody would ever make a mistake in Excel. Every formula would be flawless, and every bit of data would be valid. Unfortunately, that's not the case.…

If you have a big Excel file, with lots of pivot tables and their source data, I've written a macro that might help you. The macros creates a detailed list…

If you have buttons or shapes on an Excel  worksheet, you can get their caption text from a worksheet cell, so the text changes, based on a formula. See how…

The other day while I was in lift (elevator), it made an alarm like sound and won’t close the doors. Turns out there are one too many people in the…

We all change minds. Heck, I just did it with the leading line. I thought something else, but went with what you just read. So why must Excel charts be…

The Excel Status Bar shows you messages about what's going on, while you work. Some of those messages are optional, and you can turn them on or off. Here's how…

So you have built that spreadsheet report your boss wanted. And you are all geared up to use it in your presentation. But in the last minute, your boss asks…

Do you ever need to compare two Excel Tables? Here's a simple formula that quickly shows if there are any differences, between tables that have the same number of columns…