Exceljet

Quick, clean, and to the point

Latest videos

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
Tip: Calculate due dates with the WORKDAY function
This video show how to calculate due dates with the WORKDAY and WORKDAY.INTL functions. You can use WORKDAY to calculate intelligent ship dates, delivery dates, and completion dates that...
Run time: 3:40
Tip: How to plot survey data in a bar chart
In this video, we demo how to plot results from a survey question in an Excel bar chart. Along the way, we use the COUNTIF function to build a summary table, and show a simple technique for...
Run time: 3:42

Latest Blog

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.
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.

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
Superb course // Core Pivot
If you are looking for a superb course, you have come to the right place. Dave's passion for Excel comes across immediately in his easy-to-use videos. His streamlined and bite-sized approach makes all the difference in getting exactly the information you need in just a few minutes of time. - Janet
The core pivot tables course is excellent! // Core Pivot
The core pivot tables course is excellent! I work with data manipulation for a large pharma company and with the help of the Core Pivot Tables videos found a way to cut 45 minutes out of my data manipulations on Monday mornings. I recommend this to everyone I work with that uses Excel to manage large amounts of sortable data. - Tim
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