Our approach is quick, clean, and to the point. Join more than 20,000 people who get weekly updates from us.
Latest video tips
How to generate an expiration date in the future, how to calculate "days remaining", and how to highlight rows that are expired or expiring soon with conditional formatting.
The RANK function gives you a way to rank values with a simple function that will dynamically calculate rank. If any value changes, you'll get a new rank automatically.
A short introduction to the CODE and CHAR functions, two geeky (but surprisingly useful) functions that help you manipulate text in Excel.
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...
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
I would highly recommend // Course: Core PivotI 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
This course rocks! // Course: Core ExcelThis course is absolutely perfect! I was promoted to an administrative position recently that has necessitated handling of an immense amount of data. I've been looking for a course that will take my Excel skills to the next level and THIS IS IT! If you need to polish your Excel skills, there isn't a better way to do it. - Collin
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
Huge Help- // Course: 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