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…

Aside from staring at them closely, how can you compare two cells in Excel? Here are a few functions and formulas that check the contents of two cells, to see…

How can you copy a pivot table custom style to a different workbook? There isn't a built-in way to do that, but there is a workaround solution. There are instructions…

Happy Summer! Or, if you're south of the equator, Happy Winter! To help you get the new season off to a good start, here's a roundup of Excel articles and…