Exceljet

Quick, clean, and to the point

Latest videos

Tip: Paste Special Shortcuts
Despite the boring name, Paste Special is actually a gateway into a hidden world of powerful features. This video shows how to access Paste Special features using keyboard shortcuts.
Run time: 4:05
Tip: How to find missing values with COUNTIF
In this video, we use COUNTIF to compare lists and count values that belong to both lists. We also "flip" the formula to count values in one list that are missing on the other.
Run time: 2:35
Tip: How to make a nested IF formula
Nesting is a powerful tool, but once you combine more than a couple IFs, the logic can start to look like spaghetti quickly :) The trick is to keep things organized. In this video, Dave...
Run time: 3:15
Tip: Don't hard code assumptions into your formulas
One of the biggest mistakes you can make is to hard code assumptions into your formulas. Instead, if a value might change, put it in a cell and refer to it with a reference, as explained in...
Run time: 3:09
Tip: Excel shortcuts on the Mac - key differences
In this video, we look at 5 key differences between Excel shortcuts on Mac and shortcuts in Windows Excel. If you use Excel on a Mac, be sure to check this out.
Run time: 3:22

Latest Blog

How to create named ranges in Excel
Named ranges make formulas easier to read, faster to develop, and more portable. They're also useful for data validation, hyperlinks, and dynamic ranges. This article shows you how you can use named ranges to build better spreadsheets.
In this article, we show you how to replace a complicated IF statement with a clever and compact formula based on MIN or MAX. This is a great tip any time you need to choose the smaller or greater of two values inside a formula.
Conditional formatting with formulas
Formulas let you access the full power of Excel to apply conditional formatting with exactly the logic you need. This article shows how to highlight rows, column differences, missing values, and how to build Gantt charts and search boxes with CF formulas.
All about nested IFs
Are nested IFs evil? Are they necessary? Are there alternatives? The answer is Yes! This in-depth article explores nested IF formulas in detail, with lots of tips, and several alternatives.
Like a clock, the MOD function repeats
MOD is nerdy, but cool. If you've ever struggled to create a more complex formula in Excel, you'll like this one. It shows you how to build a more complex formula step-by-step, without going crazy.

What people are saying

Great Simple Product // Excel Laminated Shortcut Card
A great simple product that is always at hand - Charles
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
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
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