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 love the short video format // Core Pivot
I've used pivot tables before, but I'm learning a lot of new skills in this course. For example, I didn't know you could group results by numbers - great for summarizing data by age group. I love the short video format. It's perfect for a self-paced course. - John
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
Excel Shortcuts WIN battle with Mouse // Excel Laminated Shortcut Card
If you want to learn shortcuts to limit your use of the mouse, then this Shortcut Card is essential!! ExcelJet has produced a VERY useful list of shortcuts easily referred to in one laminated sheet (front & back). I purchased 5 of them directly from their website and have given them to my co-workers. Their training is awesome too! - Allen