Exceljet

Quick, clean, and to the point

Latest video tips

Tip: How to get the Nth largest or smallest
In this video, we look at how to use the SMALL and LARGE functions to get the nth value from a data set. You can use these functions to get the top 3 test scores, top 5 fastest times, and...
win4:01
Tip: How to build all-in-one formulas
This video shows you how to build a more complex formula using helper formulas, then bring them all together in a single, all-in-one formula at the end.
win3:45
Tip: How to use the SUMIF function
The SUMIF function sums numbers conditionally: sales of red sweaters, revenue from Texas, hours billed on project X. See how it works in this short video.
win3:43
Tip: How to use the COUNTIF function
The COUNTIF function is incredibly useful when you want to count things like overdue invoices, employees in Engineering, or orders over $100. Learn how to use it in this short video.
win3:02
Tip: How to trace a formula error in Excel
Sometimes, you open a spreadsheet and see errors everywhere! Fortunately, Excel contains a cool tool that can automatically trace errors, and pinpoint the exact source.
win2:29

Latest Blog

Popular Excel shortcuts
We asked users how important Excel shortcuts are to them and also about their favorite shortcuts. This is what we learned...
The evil scroll lock enabled in Excel 2010
Your report is due in an hour. You're working along in Excel, when suddenly you notice that you can no longer move around properly. Is it, perhaps, the evil Scroll Lock?
Learn Excel formulas and differentiate yourself
If you've ever wondered whether learning Excel formulas is worth your time, this list is for you. Formulas are the glue that hold spreadsheets together all over the world, and your skill with them can help you in many ways.
How to use VLOOKUP - things you need to know
Although VLOOKUP is a pretty simple function, there is plenty that can go wrong. Quickly learn more than 20 things you should know about VLOOKUP to make your experience pleasant and profitable.
By default, VLOOKUP will match in approximate mode, which can be disastrous. Learn how to avoid this problem by always setting the match mode yourself.

What people are saying

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
Wonderful teaching style // Core Formula
Great course, wonderful teaching style. What a cool feature with search form with conditional formatting. - Stephen
Thorough, great pace + easy on the ears // Core Excel
Wow, this course is thorough! So much is packed in here, it seems like just about everything I'd need to know about Excel is included. The pacing is great, and the instructor's voice is very easy to listen to. Thorough, great pace + easy on the ears. - Corbett