Exceljet

Quick, clean, and to the point

Latest videos

Tip: Excel formula errors and fixes
In this video, we show examples of the 8 Excel formula errors you're likely to run into, and simple steps you can take to fix them. We look at #NAME?, #DIV/0!, #NUM!, #NULL!, #NA, #...
Run time: 4:22
Tip: How to build a simple dynamic chart
In this video, we look at how to build a chart that automatically includes new data, and dynamically highlights the top and bottom values. This is an easy way to create an interactive chart...
Run time: 3:56
Tip: How to use the CHOOSE function
In this video, we'll look at how you can use the CHOOSE function for simple lookups. The CHOOSE function doesn't need an external table, and can sometimes replace more complicated...
Run time: 3:41
Tip: How to generate random values
In this video, we'll look at a few ways to generate random values with the RANDBETWEEN function. You can use this approach to generate random numbers, random prices, random dates, and...
Run time: 3:39
Tip: How to copy a pivot table without the data
When you copy and paste a pivot table, a hidden data cache still remains. This video shows a simple way to copy a pivot table without the source data, while preserving all formatting.
Run time: 2:45

Latest Blog

The challenge - calculate the difference from the current and last entry, even when previous entries are skipped. This is one of those problems that seems simple at first glance, but is tricky when you look closely.

How to make dependent dropdown lists
Once you start to add dropdown menus to your spreadsheets, you'll inevitably run into a challenge: how can you make one dropdown dynamically respond to another? More generally, how can you make the values in a dropdown list depend on another value in the worksheet?
Excel data validation guide
Data validation can help control what a user can enter into a cell. You could use data validation to make sure a value is a number, a date, or to present a dropdown menu with predefined choices to a user. This guide provides an overview of the data validation feature.
Generate weekend dates only with a simple formula
Sure, you can use a complicated WEEKDAY formula to generate a list of weekends. But with WORKDAY.INTL, you can do the same thing with a WAY simpler formula. The trick is to use a special 7-digit "mask" to filter out all dates except weekends.

You have a fixed monthly payment, a start date, and a given number of months. You have five years shown on the worksheet. What formula can you use to sum total payments by year?

What people are saying

Wonderful! // Excel Laminated Shortcut Card
Wonderful!... I love it! Very helpful! Highly recommended! - Ricardo
Thorough, great pace + easy on the ears // Core Excel
Wow, this course is thorough! So much is packed in here, it seems like just about everything I'd need to know about Excel is included. The pacing is great, and the instructor's voice is very easy to listen to. Thorough, great pace + easy on the ears. - Corbett
The first thing that stood out to me was the quality // Core Excel
I've really enjoyed this course so far, the first thing that stood out to me was the quality. Great audio that's enjoyable to listen to, high definition video (to best see those formulas) and most important of all is Dave's a great instructor. I also really like that each lesson is short, I can jump around to specific topics and in 2 - 3 minutes I've learned something new. - James
The best I've seen BY FAR // 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