Exceljet

Quick, clean, and to the point

Latest video tips

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
Tip: What's a slicer and how to add one to a pivot table
In this video, we look how slicers filter data in a pivot table and how to easily add a slicer to a pivot table.
win3:16

Latest Blog

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.
Keep or cut?
This article is for those of you who don't get pivot tables. Maybe you tried pivot tables once, and didn't see what the big deal was, or maybe you got frustrated when a pivot table wouldn't behave. They can be that way.
Things to know about pivot tables
Many Excel experts believe that pivot tables are the single most powerful tool in Excel. According to Bill Jelen (a.k.a. Mr. Excel) "No other tool in Excel gives you the flexibility and analytical power of a pivot table". Yep.
16 Excel Pros you can learn from
There are a lot of good Excel sites out there, but a few really stand out as excellent resources. This article introduces you to 16 Excel Pros that run some of these exceptional sites. They really know Excel, and freely share what they know.

What people are saying

Very Helpful // Excel Laminated Shortcut Card
This was a very helpful short-cut card. It is one of the few excel products that actually includes a full range of Mac short-cuts as well as the related Windows shortcuts. I use this card regularly when I'm using Excel. - Michael
The core pivot tables course is excellent! // Core Pivot
The core pivot tables course is excellent! I work with data manipulation for a large pharma company and with the help of the Core Pivot Tables videos found a way to cut 45 minutes out of my data manipulations on Monday mornings. I recommend this to everyone I work with that uses Excel to manage large amounts of sortable data. - Tim
Highly recommend // Excel Laminated Shortcut Card
Has many applications not taught in 2 college Excel classes. Highly recommend to anyone wanting to ramp up their Excel skills. High quality/durable laminate. Inexpensive. Easy to use. - Larry E. from Evanston, IL.
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