Latest video tips

Tip: How to clone a pivot table
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.
win3:11
Tip: How to group a pivot table by age range
In this video we look at how to group sample voting data into 10 year buckets, using a pivot table.
win2:47
Tip: How to quickly fill in missing data - part 2
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.
mac2:56
Tip: How to quickly fill in missing data
An easy way to add missing values to data using a dead-simple relative formula and a few other tricks to select empty cells.
win3:24
Tip: How to select cells with your keyboard
Excel Pros use keyboard shortcuts to power though big worksheets with blazing speed. In this video, we look at some key shortcuts for selecting cells.
win2:09

Latest Blog

Things to know about pivot tables
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.
16 Excel Pros you can learn from
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.
A simple model for measuring the value of improving a skill
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.
The Excel Ribbon
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 Excel
This 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 Excel
Absolutely 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 Pivot
The 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 Excel
This 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

 

Exceljet is used by smart people at these companies

Your Satisfaction Guaranteed