Our approach is quick, clean, and to the point. Join more than 30,000 people who get weekly updates from us.
Latest video tips
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.
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.
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.
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.
What people are saying
This course rocks! // Core Excel FoundationsThis 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
Wonderful! // Excel Laminated Shortcut Card Wonderful!... I love it! Very helpful! Highly recommended! - Ricardo
I love the short video format // Excel Pivot TablesI've used pivot tables before, but I'm learning a lot of new skills in this course. For example, I didn't know you could group results by numbers - great for summarizing data by age group. I love the short video format. It's perfect for a self-paced course. - John
Highly recommend // Excel Laminated Shortcut Card Has many applications not taught in 2 college Excel classes. Highly recommend to anyone wanting to ramp up their Excel skills. High quality/durable laminate. Inexpensive. Easy to use. - Larry E. from Evanston, IL.