Exceljet

Quick, clean, and to the point

Latest videos

Tip: How to use boolean logic in Excel formulas
In this video, we introduce the concepts of boolean values and boolean logic. Boolean logic can be a great way to simplify and speed up complex formulas, since it requires no branching.
Run time: 3:30
Tip: How to use VLOOKUP to merge tables
VLOOKUP is a great way to merge data in two tables based on a common ID. This video shows you how in 3 minutes. You can even use this technique to reorder the columns you retrieve.
Run time: 3:10
Tip: How to build a simple summary table
Although Pivot Tables are fantastic tools for summarizing data, sometimes you just want a simple, lightweight solution based on formulas. The good news is you can build your own summaries...
Run time: 3:01
Tip: How to combine functions in a formula
Combining functions is a core skill you *must* have in order to move beyond the basics in Excel. In this video, we show how to split, manipulate, and reassemble values using multiple...
Run time: 2:53
Tip: Perfect conditional formatting with dummy formulas
Conditional formatting with formulas can be tricky because you can't see what happens to the formula when the rule is applied. Dummy formulas let you visualize how formulas will behave...
Run time: 3:28

Latest Blog

Fiddles with new CONCAT & TEXTJOIN functions
The CONCATE and TEXTJOIN functions make it possible to join values together in a range of cells. Since a range is just an array, this opens the door to some interesting new formulas that loop through values.
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.

What people are saying

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
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
Great intro course // Core Excel
Great intro course for EXCEL. Easy to follow and no wasted time. Each lecture is clearly identified, short, and shows you how to take the actions described. A great tutorial for learning the nuances of the new programs. - Richard
I absolutely love the format and content! // Core Pivot
I just wanted to let you know that I'm about half way through the videos of the Pivot Table course and I absolutely love the format and content! It's very well organized and each topic is well covered but succinct. I've been recommending your website to coworkers and will absolutely take another of your courses if the need arises. No need to look elsewhere! Thanks so much :-) - Barbara