Let’s say you manage a fund or charity. You get money from various places and you use that money for various reasons. How do you tell the story of source…

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