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 use COUNTIF to compare lists and count values that belong to both lists. We also "flip" the formula to count values in one list that are missing on the other.
Nesting is a powerful tool, but once you combine more than a couple IFs, the logic can start to look like spaghetti quickly :) The trick is to keep things organized. In this video, Dave...
One of the biggest mistakes you can make is to hard code assumptions into your formulas. Instead, if a value might change, put it in a cell and refer to it with a reference, as explained in...
In this video, we look at 5 key differences between Excel shortcuts on Mac and shortcuts in Windows Excel. If you use Excel on a Mac, be sure to check this out.
Why is the Excel ribbon cool? Because it gives you a way to use nearly every feature in Excel without touching the mouse. Watch this video to learn how.
Harness the full power of Excel's formulas and functions to apply conditional formatting with exactly the logic you need.
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.
MOD is nerdy, but cool. If you've ever struggled to create a more complex formula in Excel, you'll like this one. It shows you how to build a more complex formula step-by-step, without going crazy.
Excel has the ability to use a custom template for all new workbooks. If you find yourself making the same changes to new workbooks (changing row height, font size, zoom, etc.) a default custom template can save you time and trouble.
Does cell A1 contain "apple"? This is a surprisingly tricky problem in Excel. In this article, we look at several options, based on the functions FIND, SEARCH, ISNUMBER, and COUNTIF.
What people are saying
I love the short video format // Core PivotI'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
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
Great tool // Excel Laminated Shortcut Card These are great reference. I found short cuts I did not even know were out there. - Michael
Everything you need to know about pivot tables // Core PivotExcelJet 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