Are you ready? Spreadsheet Day 2021 is almost here – Sunday, October 17, 2021. What plans do you have for this year’s celebrations? Since Spreadsheet Day falls on the weekend…

In Excel, you can create a Stacked Column chart, or a Clustered Column chart, using the built-in chart options. There isn’t a Clustered Stacked Column chart type, but here are…

Did you already notice that today (September 5, 2121), is Excel day 44444? To see that number, type today’s date in a worksheet cell. Then, change that cell’s number format…

Whether you’re scheduling players for a golf tournament, or assigning employees for daily shifts, Excel can make the job easier. There’s a Golf Tee Off Times example on my site,…

In some data entry lists, you only want each item selected once. For example, pick players for a baseball lineup, or assign employees for their weekly on-call assignment. To prevent…

Ken Puls and Miguel Escobar just released their new Power Query book – Master Your Data with Excel and Power BI. I bought a digital copy, downloaded the sample files,…

It is Olympic season. Everyone I know is tracking the games and checking their country’s performance. One thing that we notice when looking at medal tally is, A single Gold…

Knowing how to use Excel date values can help you save a ton of time in your day to day spreadsheet chores. Let us prepare for your date with the…

To find the highest and lowest amounts in Excel, use the MAX and MIN function. If you need to use criteria in your calculations, add the IF function to your…

Someone sent me a workbook in which a simple VLOOKUP formula was returning #N/A errors, instead of the correct results. The product numbers looked the same, but Excel didn't match…