Quick, clean, and to the point

Latest video tips

Tip: How to build all-in-one formulas
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.
Tip: How to use the SUMIF function
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.
Tip: How to use the COUNTIF function
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.
Tip: How to trace a formula error in Excel
Sometimes, you open a spreadsheet and see errors everywhere! Fortunately, Excel contains a cool tool that can automatically trace errors, and pinpoint the exact source.
Tip: How to compare two lists and highlight differences
In this video, we look at how to compare two lists using conditional formatting. This is a great way to visually highlight different or missing items in a list.

Latest Blog

Learn Excel formulas and differentiate yourself
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.
How to use VLOOKUP - things you need to know
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.

In this formula puzzle, we look at truck location GPS data, and ask: what formula will calculate the hours that each truck was stopped during the day?

How to test conditional formatting with dummy formulas
If you've ever tried to apply conditional formatting with a formula, you know the hardest part is making sure the formula actually works. Here's an easy way to test the formula, before you use it in a rule.

What people are saying

The first thing that stood out to me was the quality // Core Excel Foundations
I'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
A must for EVERYONE switching from a PC to Mac! // Excel Laminated Shortcut Card
A must for EVERYONE switching from a PC to Mac! I wish I had this back when I made the switch! Save yourself the headache and buy this NOW! Great product from GREAT people! Check out their website for the great tips and classes! - Mary Jo
I would highly recommend // Excel Pivot Tables
I 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
Great Examples // Excel Conditional Formatting
I 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