Our approach is quick, clean, and to the point. Join more than 30,000 people who get weekly updates from us.
Latest video tips
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.
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.
In this video, we look at how to use conditional formatting, with a formula, to shade every other row in a table. This is sometimes called "zebra striping", and it's a cool...
In this video, we look at how to make conditional formatting variable, so that you can change how formatting is applied without editing a rule. This elegant technique helps you build killer...
In this video, we'll look at how to use a simple formula to apply conditional formatting. Formulas allow you to make more powerful conditional formatting rules.
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?
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.
How do you figure out what formula to use? A teardown of 5 good formulas you can use to highlight dates based on a common month and year value using conditional formatting.
What people are saying
The first thing that stood out to me was the quality // Core Excel FoundationsI'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
Everything you need to know about pivot tables // Excel Pivot TablesExcelJet does a fantastic job of breaking down the potentially complex topic of pivot tables into simple, easy to understand bite-sized pieces! This course serves up everything you need to know (and more) about pivot tables on a platter so you can create simple, straight-forward and customizable reports while significantly minimizing the learning curve. - Lauren
Superb course // Excel Pivot TablesIf 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