Exceljet

Quick, clean, and to the point

Latest videos

Tip: How to query a table with formulas
Because tables support structured references, you can learn a lot about a table with basic formulas. In this video, we run through about a dozen examples. It's a nice demo of how...
Run time: 3:49
Tip: Introduction to Structured References and Tables
In this video gives a brief introduction to structured references. Structured references is just a fancy name for formulas that use table names instead of normal cell references. This...
Run time: 3:35
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

Latest Blog

Every day, thousands of questions about Excel are posted on the internet. Many of these questions go unanswered because they are unclear. This article contains some tips on how to write a question that people will quickly understand and answer if they can.
One problem that comes up a lot in Excel is counting or summing based on multiple OR conditions. For example, perhaps you need to analyze data and count orders in Seattle or Denver, for items that are Red, Blue, or Green? This can be surprisingly tricky, so naturally it makes a good challenge!

We have a simple list of 4-digit alphanumeric codes like A001, A002, A003, etc. What formula can we use to mark codes are "out of sequence" with previous entries? This problem includes two separate challenges.

In this formula challenge, we have data showing cups of coffee sold at a small kiosk for a week. What formula will look up and sum total cups sold after 12:00 PM on Tuesday and Thursday? Relevant cells are shaded in green.

28 ways to save time with Excel formulas
Working with formulas takes time, and too often a problem that seems simple ends up taking far too long. In this article, I share tips that will save you time when working with formulas in Excel.

What people are saying

Wonderful! // Excel Laminated Shortcut Card
Wonderful!... I love it! Very helpful! Highly recommended! - Ricardo
Huge Help- // Excel Laminated Shortcut Card
ExcelJet's shortcut cards are a huge help- I've bought some for employees who didn't have much experience with Excel and they all found them incredibly helpful. The cards are well organized, give info for both PCs and Macs, and are very durable. For the price, they're an incredibly helpful reference. - Jonathan
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 Examples // Excel Conditional Formatting
I LOVE your lessons on conditional formatting. All sorts of new and better ways. That’s been a real weak point for me, and you have great examples. - Sally