In the good old days of Excel, you could change a workbook setting, and see a preview picture of the file contents, before you opened it. That feature was available…

Its Easter time. At Chandoo.org, I have tradition of publishing Easter Egg hunts since 2009. This is the first time our Easter egg hunt is on Power BI. Changing times,…

We all know that VLOOKUP can find first match and return the results. But what if you want to VLOOKUP multiple matches? Use this simple trick instead. Multiple matches in…

If you've purchased a copy of my UserForms for Data Entry kit, there's a new bonus for you -- the UserForm Builder (UFB)  add-in. Watch the video below, to see…

With a formatted Excel table, you can turn the Total Row on or off easily, and it shows at the bottom of the table. Someone asked me how to add…

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

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…