Quick, clean, and to the point


How do you figure out what formula to use? A teardown of 5 good formulas you can use to highlight dates based on a common month and year value using conditional formatting.

Excel has a built-in conditional formatting rule that will highlight dates that occur "this month". But what if you want to highlight dates in the same month and year for any date?

Excel conditional formatting tips
In this article, we look at some cool ways that you can use Excel's conditional formatting feature to quickly visualize important data.
Pivot tables to delight and amaze!
In this article, we take a short tour of some "unconventional" pivot tables you probably haven't seen before. These are interesting pivot tables that are summarizing something *other* than sales data.
Keep or cut?
This article is for those of you who don't get pivot tables. Maybe you tried pivot tables once, and didn't see what the big deal was, or maybe you got frustrated when a pivot table wouldn't behave. They can be that way.
Things to know about Excel pivot tables
Many Excel experts believe that pivot tables are the single most powerful tool in Excel. Quickly learn more than 20 things you should know about Excel Pivot Tables.
A simple model for measuring the value of improving a skill
In this article, we take a look at a simple model that calculates the time that could be saved by doing a task or activity with more skill. The goal is to visualize whether it makes sense to invest in getting better at a skill.
54 powerful Excel shortcuts
A list and description of just over 50 important Excel shortcuts you should know if you spend a lot of time in Excel. This is a summarized version of the more than 200 shortcuts that are available in Excel for both Windows and Mac platforms.
The Excel Ribbon
Does it ever bother you that the ribbon sits up there at the top of the workbook, smugly hogging a bunch of space while you toil away in your (smaller) worksheet below?
How to group pivot table data by age
In this article, we look at how to use a pivot table to group voting data by age. This is a good example of the "group by number" feature that all pivot tables share.
Google adwords profitability worksheet
In this article, we build a model using the seldom-seen Data Table to visualize at what point an Adwords campaign becomes profitable.
Mac function keys
A summary of how to use Function keys on a Mac with Excel and other applications, including information on system defaults and how to change these defaults.