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…

Instead of showing a budget's forecast, actual and variance data all at once, click a button to view the values one at a time. That makes the report easier to…

Congratulations to the USA Women's Hockey team, who won the Olympic gold medal. They beat our Canadian team, in a hard-fought game that went into overtime, and ended with a…

If you're planning a wedding, or another type of event, you might need a seating plan. Get this free Excel seating plan with charts, and modify it to show your…

If you need to know what color is in a worksheet cell, or a shape, you can check it manually, or use VBA code to find the color number. There…

Spring has finally arrived, so here is a "Goodbye  Winter" Excel Roundup, with articles that I've read recently, and upcoming Excel events and free online courses that I've heard about.…

As you know, Excel can do almost anything! Recently, I changed the server that my site and blog are on, and Excel helped with the IP Addresses. And since it's…

Have you seen the articles that blame Excel for all kinds of business errors? In some cases, problems occur because rows were hidden, and that distorted the data analysis. To…