Exceljet

Quick, clean, and to the point

Latest video tips

Tip: How to compare two lists and highlight differences
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.
win2:27
Tip: How to create zebra stripes with conditional formatting
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...
win3:29
Tip: How to make conditional formatting variable
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...
win2:42
Tip: How to apply conditional formatting with a formula
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.
win2:41
Tip: How to use a slicer for multiple pivot tables
In this video, we look at how to configure a slicer to control more than one pivot table at once. This technique is often used when building dashboards.
win2:29

Latest Blog

How to test conditional formatting with dummy formulas
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.
28 ways to save time with Excel formulas
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 Excel
I 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