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

Custom number formats control how numbers are displayed in Excel. The key benefit of custom number formats 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 consistent and 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?
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.

What people are saying

A must for EVERYONE switching from a PC to Mac! // Excel Laminated Shortcut Card
A must for EVERYONE switching from a PC to Mac! I wish I had this back when I made the switch! Save yourself the headache and buy this NOW! Great product from GREAT people! Check out their website for the great tips and classes! - Mary Jo
Wonderful! // Excel Laminated Shortcut Card
Wonderful!... I love it! Very helpful! Highly recommended! - Ricardo
Well worth the $ // Excel Laminated Shortcut Card
This is exactly what you would expect from looking at the picture. It's a 2-sided laminated sheet of paper with a ton of excel shortcuts printed out. Exceljet offers a similar product for free on their website, it's a PDF manual of 200 shortcuts. I started with that & ended up buying this as well, as it is so convenient to hang on the wall next to my computer for reference. The PDF manual is great too, but this is just faster to use. Well worth the $ in my opinion. - Mark
I love the short video format // Core Pivot
I've used pivot tables before, but I'm learning a lot of new skills in this course. For example, I didn't know you could group results by numbers - great for summarizing data by age group. I love the short video format. It's perfect for a self-paced course. - John