Exceljet

Quick, clean, and to the point

Latest videos

Tip: How to create a running total in a Table
Calculating a running total in an Excel table is a little tricky, because it's not obvious how to build the formula with structured references. You can easily get the current row with...
Run time: 3:32
Tip: How to use VLOOKUP with an Excel Table
This video shows how to setup VLOOKUP with a table, and how to use the MATCH function inside VLOOKUP to generate a dynamic column index. This makes it easy to refer to columns by name...
Run time: 3:40
Tip: How to use SUMIFS with a table
In the video, we build one set of SUMIFS formulas with a table, and one set without. This makes it really easy to see the nice benefits you get when you combine tables and formulas.
Run time: 3:40
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

Latest Blog

In this challenge, the goal is to end up with a text string like "MWF" for Monday, Wednesday, Friday. The problem is that the weekdays are input like as yes/no abbreviations like "NYNYNYN" for "MWF". What formula will translate the "N" and "Y" to weekday abbreviations?
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.

What people are saying

Wonderful! // Excel Laminated Shortcut Card
Wonderful!... I love it! Very helpful! Highly recommended! - Ricardo
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
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 would highly recommend // Core Pivot
I have been an Excel user for over 15 years, and colleagues would call me an expert. That being said, I learned things from this course that I will be using daily. I would highly recommend for anyone at any level. - Scott