Our approach is quick, clean, and to the point. Join more than 20,000 people who get weekly updates from us.
Latest video tips
A simple example of how you can use pivot tables to analyze all kinds of data, not just sales data. We look at the top 250 movies from IMDB from 2014.
Puzzled by Pivot Table layouts? Wonder what the differences and tradeoffs are in each layout? This video is for you!
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.
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
The first thing that stood out to me was the quality // Course: Core ExcelI've really enjoyed this course so far, the first thing that stood out to me was the quality. Great audio that's enjoyable to listen to, high definition video (to best see those formulas) and most important of all is Dave's a great instructor. I also really like that each lesson is short, I can jump around to specific topics and in 2 - 3 minutes I've learned something new. - James
The best I've seen BY FAR // Course: 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
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
Great Examples // Course: Conditional FormattingI LOVE your lessons on conditional formatting. All sorts of new and better ways. That’s been a real weak point for me, and you have great examples. - Sally