Exceljet

Quick, clean, and to the point

Latest videos

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
Tip: How to group a pivot table with custom buckets
Pivot tables are awesome tools for grouping data, and they do a lot of grouping automatically. But pivot tables also let you group data into your own custom buckets, which is great for...
Run time: 2:45

Latest Blog

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?

Friendly, dynamic messages with concatenation
In this article, we explain how to use concatenation to display friendly and useful messages in your spreadsheets. The messages are dynamic and respond instantly to changes, so the effect is polished and professional.
Use the EOMONTH function to get the last day of a month
The EOMONTH function is one of those little gems in Excel that can save you a lot of trouble. It's a simple function that does just one thing: given a date, it returns the last day of a month. You can use EOMONTH to build all kinds of useful Excel formulas.

What people are saying

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 passed! // Core Excel
I passed the Microsoft 2010 Excel Specialist Certificate Exam this afternoon. Thank you so much for your lectures for the course Excel Core! They help me a lot when preparing my exam! [Note: Excel Core course is not primarily designed for Excel Certificate Exam review purpose.] - Chenhao
Great tool // Excel Laminated Shortcut Card
These are great reference. I found short cuts I did not even know were out there. - Michael
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