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 look at how to make conditional formatting variable, so that you can change how formatting is applied without editing a rule. This elegant technique helps you build killer...
In this video, we'll look at how to use a simple formula to apply conditional formatting. Formulas allow you to make more powerful conditional formatting rules.
In this video, we look at how to configure a slicer to control more than one pivot table at once. This technique is often used when building dashboards.
In this video, we look how slicers filter data in a pivot table and how to easily add a slicer to a pivot table.
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
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
The best I've seen BY FAR // Core ExcelThis Excel course is the best I've seen BY FAR! Dave explains the concepts in theory, then shows you how to do it, then gives you practice problems to do the same steps on your own. I would recommend this course to anyone who wants to expand their foundational Excel knowledge or learn Excel from scratch. - Ron
Sits Next to my Laptop // Excel Laminated Shortcut Card This sits right next to my laptop so I always have it available when I am using Excel. It has many useful shortcuts which have saved me a tremendous amount of time in my daily work. I highly recommend it, as well as the other products from Exceljet. - Anthony
Highly recommend // Excel Laminated Shortcut Card Has many applications not taught in 2 college Excel classes. Highly recommend to anyone wanting to ramp up their Excel skills. High quality/durable laminate. Inexpensive. Easy to use. - Larry E. from Evanston, IL.