Our approach is quick, clean, and to the point. Join more than 50,000 people who get weekly updates from us.
In this video, we introduce the concepts of boolean values and boolean logic. Boolean logic can be a great way to simplify and speed up complex formulas, since it requires no branching.
VLOOKUP is a great way to merge data in two tables based on a common ID. This video shows you how in 3 minutes. You can even use this technique to reorder the columns you retrieve.
Although Pivot Tables are fantastic tools for summarizing data, sometimes you just want a simple, lightweight solution based on formulas. The good news is you can build your own summaries...
Combining functions is a core skill you *must* have in order to move beyond the basics in Excel. In this video, we show how to split, manipulate, and reassemble values using multiple...
Conditional formatting with formulas can be tricky because you can't see what happens to the formula when the rule is applied. Dummy formulas let you visualize how formulas will behave...
The CONCATE and TEXTJOIN functions make it possible to join values together in a range of cells. Since a range is just an array, this opens the door to some interesting new formulas that loop through values.
Named ranges make formulas easier to read, faster to develop, and more portable. They're also useful for data validation, hyperlinks, and dynamic ranges. This article shows you how you can use named ranges to build better spreadsheets.
In this article, we show you how to replace a complicated IF statement with a clever and compact formula based on MIN or MAX. This is a great tip any time you need to choose the smaller or greater of two values inside a formula.
Formulas let you access the full power of Excel to apply conditional formatting with exactly the logic you need. This article shows how to highlight rows, column differences, missing values, and how to build Gantt charts and search boxes with CF formulas.
Are nested IFs evil? Are they necessary? Are there alternatives? The answer is Yes! This in-depth article explores nested IF formulas in detail, with lots of tips, and several alternatives.
What people are saying
I would highly recommend // Core PivotI 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
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
Great intro course // Core ExcelGreat intro course for EXCEL. Easy to follow and no wasted time. Each lecture is clearly identified, short, and shows you how to take the actions described. A great tutorial for learning the nuances of the new programs. - Richard
I absolutely love the format and content! // Core PivotI just wanted to let you know that I'm about half way through the videos of the Pivot Table course and I absolutely love the format and content! It's very well organized and each topic is well covered but succinct. I've been recommending your website to coworkers and will absolutely take another of your courses if the need arises. No need to look elsewhere! Thanks so much :-) - Barbara