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 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.
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.

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
Wonderful! // Excel Laminated Shortcut Card
Wonderful!... I love it! Very helpful! Highly recommended! - Ricardo
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
I would highly recommend // Core Pivot
I have been an Excel user for over 15 years, and colleagues would call me an expert. That being said, I learned things from this course that I will be using daily. I would highly recommend for anyone at any level. - Scott