Our approach is quick, clean, and to the point. Join more than 30,000 people who get weekly updates from us.
Latest video tips
In this video, we look at how to use the SMALL and LARGE functions to get the nth value from a data set. You can use these functions to get the top 3 test scores, top 5 fastest times, and...
This video shows you how to build a more complex formula using helper formulas, then bring them all together in a single, all-in-one formula at the end.
The SUMIF function sums numbers conditionally: sales of red sweaters, revenue from Texas, hours billed on project X. See how it works in this short video.
The COUNTIF function is incredibly useful when you want to count things like overdue invoices, employees in Engineering, or orders over $100. Learn how to use it in this short video.
We asked users how important Excel shortcuts are to them and also about their favorite shortcuts. This is what we learned...
Your report is due in an hour. You're working along in Excel, when suddenly you notice that you can no longer move around properly. Is it, perhaps, the evil Scroll Lock?
If you've ever wondered whether learning Excel formulas is worth your time, this list is for you. Formulas are the glue that hold spreadsheets together all over the world, and your skill with them can help you in many ways.
Although VLOOKUP is a pretty simple function, there is plenty that can go wrong. Quickly learn more than 20 things you should know about VLOOKUP to make your experience pleasant and profitable.
By default, VLOOKUP will match in approximate mode, which can be disastrous. Learn how to avoid this problem by always setting the match mode yourself.
What people are saying
Superb course // Core PivotIf you are looking for a superb course, you have come to the right place. Dave's passion for Excel comes across immediately in his easy-to-use videos. His streamlined and bite-sized approach makes all the difference in getting exactly the information you need in just a few minutes of time. - Janet
Very Helpful // Excel Laminated Shortcut Card This was a very helpful short-cut card. It is one of the few excel products that actually includes a full range of Mac short-cuts as well as the related Windows shortcuts. I use this card regularly when I'm using Excel. - Michael
The core pivot tables course is excellent! // 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