Our approach is quick, clean, and to the point. Join more than 9,000 people who get weekly updates from us.
Latest video tips
Once you have one pivot table set up, you might want to see a different view of the same data. In this video, I'll show you how to quickly base one pivot table on another.
In this video we look at how to group sample voting data into 10 year buckets, using a pivot table.
In this video, we look at a way to fill in missing data when the structure is not consistent, using formula created with IF and ISBLANK functions.
An easy way to add missing values to data using a dead-simple relative formula and a few other tricks to select empty cells.
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.
In this article, we take a look at a simple model that calculates the time that could be saved by doing a task or activity with more skill. The goal is to visualize whether it makes sense to invest in getting better at a skill.
A list and description of just over 50 important Excel shortcuts you should know if you spend a lot of time in Excel. This is a summarized version of the more than 200 shortcuts that are available in Excel for both Windows and Mac platforms.
Does it ever bother you that the ribbon sits up there at the top of the workbook, smugly hogging a bunch of space while you toil away in your (smaller) worksheet below?
What people are saying about our courses
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
Brilliant // Course: Core ExcelAbsolutely brilliant course. Easy to follow and implement. Well done. I can recommend this course to anybody who would like to learn Excel. - Linda
The core pivot tables course is excellent! // Course: Core PivotThe core pivot tables course is excellent! I work with data manipulation for a large pharma company and with the help of the Core Pivot Tables videos found a way to cut 45 minutes out of my data manipulations on Monday mornings. I recommend this to everyone I work with that uses Excel to manage large amounts of sortable data. - Tim
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