Exceljet

Quick, clean, and to the point

Latest videos

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
Tip: How to drive the ribbon with your keyboard
Why is the Excel ribbon cool? Because it gives you a way to use nearly every feature in Excel without touching the mouse. Watch this video to learn how.
Run time: 3:02

Latest Blog

Conditional formatting with formulas
Harness the full power of Excel's formulas and functions to apply conditional formatting with exactly the logic you need.
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.
How to set the default template used for new workbooks in Excel
Excel has the ability to use a custom template for all new workbooks. If you find yourself making the same changes to new workbooks (changing row height, font size, zoom, etc.) a default custom template can save you time and trouble.
Formulas for finding text in Excel
Does cell A1 contain "apple"? This is a surprisingly tricky problem in Excel. In this article, we look at several options, based on the functions FIND, SEARCH, ISNUMBER, and COUNTIF.

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
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
Great tool // Excel Laminated Shortcut Card
These are great reference. I found short cuts I did not even know were out there. - Michael
Everything you need to know about pivot tables // Core Pivot
ExcelJet does a fantastic job of breaking down the potentially complex topic of pivot tables into simple, easy to understand bite-sized pieces! This course serves up everything you need to know (and more) about pivot tables on a platter so you can create simple, straight-forward and customizable reports while significantly minimizing the learning curve. - Lauren