Our approach is quick, clean, and to the point. Join more than 20,000 people who get weekly updates from us.
Latest video tips
In this video, we look at how to compare two lists using conditional formatting. This is a great way to visually highlight different or missing items in a list.
In this video, we look at how to use conditional formatting, with a formula, to shade every other row in a table. This is sometimes called "zebra striping", and it's a cool...
In this video, we look at how to make conditional formatting variable, so that you can change how formatting is applied without editing a rule. This elegant technique helps you build killer...
In this video, we'll look at how to use a simple formula to apply conditional formatting. Formulas allow you to make more powerful conditional formatting rules.
If you've ever tried to apply conditional formatting with a formula, you know the hardest part is making sure the formula actually works. Here's an easy way to test the formula, before you use it in a rule.
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?
In this article, we look at some cool ways that you can use conditional formatting to quickly visualize and understand key data.
Working with formulas takes time, and too often a problem that seems simple ends up taking far too long. In this article, I share tips that will save you time when working with formulas in Excel.
What people are saying
I passed! // Core ExcelI passed the Microsoft 2010 Excel Specialist Certificate Exam this afternoon. Thank you so much for your lectures for the course Excel Core! They help me a lot when preparing my exam! [Note: Excel Core course is not primarily designed for Excel Certificate Exam review purpose.] - Chenhao
Huge Help- // Excel Laminated Shortcut Card ExcelJet's shortcut cards are a huge help- I've bought some for employees who didn't have much experience with Excel and they all found them incredibly helpful. The cards are well organized, give info for both PCs and Macs, and are very durable. For the price, they're an incredibly helpful reference. - Jonathan
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
Sits Next to my Laptop // Excel Laminated Shortcut Card This sits right next to my laptop so I always have it available when I am using Excel. It has many useful shortcuts which have saved me a tremendous amount of time in my daily work. I highly recommend it, as well as the other products from Exceljet. - Anthony