Our approach is quick, clean, and to the point. Join more than 20,000 people who get weekly updates from us.
Latest video tips
In this video, we run through more than 20 tips you can use to save time with Excel formulas today. We believe in making videos that are quick and to the point, so this is a rapid-fire list...
In this video, we look at how to quickly find formulas and trace relationships, using the concept of precedents and dependents. A great way to quickly understand an unfamiliar worksheet.
In this video, we use use MATCH to find the position of an item in a table, and we use INDEX to retrieve the value at that position. We work step-by-step so you can see how both functions...
In this video, we look at how to configure INDEX to fetch a value by row and column. This is half of the INDEX/MATCH equation.
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.
In this article, we take a short tour of some "unconventional" pivot tables you probably haven't seen before. These are interesting pivot tables that are summarizing something *other* than sales data.
This article is for those of you who don't get pivot tables. Maybe you tried pivot tables once, and didn't see what the big deal was, or maybe you got frustrated when a pivot table wouldn't behave. They can be that way.
Many Excel experts believe that pivot tables are the single most powerful tool in Excel. According to Bill Jelen (a.k.a. Mr. Excel) "No other tool in Excel gives you the flexibility and analytical power of a pivot table". Yep.
There are a lot of good Excel sites out there, but a few really stand out as excellent resources. This article introduces you to 16 Excel Pros that run some of these exceptional sites. They really know Excel, and freely share what they know.
What people are saying
A must for EVERYONE switching from a PC to Mac! // Course: 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
Well worth the $ // Course: 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
Superb course // Course: Core PivotIf 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
Everything you need to know about pivot tables // Course: Core PivotExcelJet does a fantastic job of breaking down the potentially complex topic of pivot tables into simple, easy to understand bite-sized pieces! This course serves up everything you need to know (and more) about pivot tables on a platter so you can create simple, straight-forward and customizable reports while significantly minimizing the learning curve. - Lauren