Exceljet

Quick, clean, and to the point

Latest videos

Tip: Use a throwaway chart to sanity check data
In most cases, you'll want to take time to build clean, uncluttered charts that are easy to read. However, a quick, messy chart is a great way to "sanity check" unfamiliar...
Run time: 2:51
Tip: How to use data labels in a chart
Excel charts have a flexible system to display values called "data labels". Data labels are a classic example a "simple" Excel feature with a huge range of options just...
Run time: 2:42
Tip: Dynamic min and max with data labels
The data labels in Excel charts are flexible and powerful. While you can easily use them to display values from source data, you can also display values from other cells. The video below...
Run time: 3:14
Tip: How to build a column chart
The video below shows how to make a basic column chart in Excel, and how you can use custom number formats with data labels to quickly streamline a chart. If you're not sure which...
Run time: 3:21
Tip: How to chart generations with floating bars
In this video, we show how to plot American generations in a floating horizontal bar chart. This seems like a simple problem, but it requires a formula, clever formatting, and a special...
Run time: 3:37

Latest Blog

In this formula challenge, we have four tests (Test A, Test B, Test C, and Test D), all with the same 19 questions, but listed in a different order. What formula can be used to match questions and construct an answer key for all tests? A perfect use for Excel's powerful lookup formulas.

INDEX and MATCH
This article explains in simple terms how to use INDEX and MATCH together to perform lookups. It takes a step-by-step approach, first explaining INDEX, then MATCH, then showing you how to combine the two functions together to create a dynamic two-way lookup.
Custom number formats
Custom number formats control how numbers are look in Excel. The key benefit is that they change how a number looks without changing any data. They are a great way to save time in Excel because they perform a huge amount of formatting automatically. As a bonus, they make worksheets look more professional.

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?

What people are saying

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
I'm excited to highly recommend Exceljet // Core Pivot
I'm excited to highly recommend Exceljet as my go-to site for learning to master Excel based on my outstanding personal experience with their products over the last three months. I've significantly improved my Excel game with the help of their courses and informative emails. The pivot table course is especially useful. Though there are an overwhelming number of options to learn Excel on the web, you can save a lot of time by diving in at Exceljet. You'll be dominating Excel in no time. - Charley
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
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