Our approach is quick, clean, and to the point. Join more than 100,000 people who get weekly updates from us.
In this video, we'll look at how to use conditional formatting to shade alternating groups of rows. For example, you can use this approach to shade groups of 3 rows, groups of 4 rows,...
In this video, we'll look at a simple shortcut recipe for removing thousands of blank rows in a large set of data. Shortcut recipes are just a series of shortcuts you perform in a...
In this video we show how to highlight approximate match lookups with conditional formatting and the LOOKUP function. Highlighting approximate matches is tricky, because you must replicate...
Shortcuts are a great way to save time and energy in Excel, but there are more than 200, so the list can seem overwhelming. In this rapid fire video, we demonstrate more than 30 popular...
In this video, we'll look at how to build a two-way lookup with INDEX and MATCH, using approximate matching. This is a classic solution for non-exact lookups like income tax, shipping...
The EOMONTH function is one of those little gems in Excel that can save you a lot of trouble. It's a simple function that does just one thing: given a date, it returns the last day of a month. You can use EOMONTH to build all kinds of useful Excel formulas.
The CONCATE and TEXTJOIN functions make it possible to join values together in a range of cells. Since a range is just an array, this opens the door to some interesting new formulas that loop through values.
Named ranges make formulas easier to read, faster to develop, and more portable. They're also useful for data validation, hyperlinks, and dynamic ranges. This article shows you how you can use named ranges to build better spreadsheets.
In this article, we show you how to replace a complicated IF statement with a clever and compact formula based on MIN or MAX. This is a great tip any time you need to choose the smaller or greater of two values inside a formula.
Formulas let you access the full power of Excel to apply conditional formatting with exactly the logic you need. This article shows how to highlight rows, column differences, missing values, and how to build Gantt charts and search boxes with CF formulas.
What people are saying
A must for EVERYONE switching from a PC to Mac! // Excel Laminated Shortcut Card A must for EVERYONE switching from a PC to Mac! I wish I had this back when I made the switch! Save yourself the headache and buy this NOW! Great product from GREAT people! Check out their website for the great tips and classes! - Mary Jo
Great tool // Excel Laminated Shortcut Card These are great reference. I found short cuts I did not even know were out there. - Michael
Great Simple Product // Excel Laminated Shortcut Card A great simple product that is always at hand - Charles