Exceljet

Quick, clean, and to the point

Latest video tips

Tip: How to calculate expiration dates
How to generate an expiration date in the future, how to calculate "days remaining", and how to highlight rows that are expired or expiring soon with conditional formatting.
win3:54
Tip: How to rank values with the RANK function
The RANK function gives you a way to rank values with a simple function that will dynamically calculate rank. If any value changes, you'll get a new rank automatically.
win2:59
Tip: How to use the CODE and CHAR functions
A short introduction to the CODE and CHAR functions, two geeky (but surprisingly useful) functions that help you manipulate text in Excel.
win3:04
Tip: 23 formula tips to save you time today
In this video, we run through more than 20 tips you can use to save time with Excel formulas today. We believe in making videos that are quick and to the point, so this is a rapid-fire list...
win11:16
Tip: How to trace formula relationships
In this video, we look at how to quickly find formulas and trace relationships, using the concept of precedents and dependents. A great way to quickly understand an unfamiliar worksheet.
win3:13

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

Well worth the $ // Course: Excel Laminated Shortcut Card
This is exactly what you would expect from looking at the picture. It's a 2-sided laminated sheet of paper with a ton of excel shortcuts printed out. Exceljet offers a similar product for free on their website, it's a PDF manual of 200 shortcuts. I started with that & ended up buying this as well, as it is so convenient to hang on the wall next to my computer for reference. The PDF manual is great too, but this is just faster to use. Well worth the $ in my opinion. - Mark
The best I've seen BY FAR // Course: Core Excel
This Excel course is the best I've seen BY FAR! Dave explains the concepts in theory, then shows you how to do it, then gives you practice problems to do the same steps on your own. I would recommend this course to anyone who wants to expand their foundational Excel knowledge or learn Excel from scratch. - Ron
Great Examples // Course: Conditional Formatting
I LOVE your lessons on conditional formatting. All sorts of new and better ways. That’s been a real weak point for me, and you have great examples. - Sally
The core pivot tables course is excellent! // Course: 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

 

Exceljet is used by smart people at these companies

Your Satisfaction Guaranteed