Our approach is quick, clean, and to the point. Join more than 20,000 people who get weekly updates from us.
Latest video tips
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.
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.
Excel has a built-in conditional formatting rule that will highlight dates that occur "this month". But what if you want to highlight dates in the same month and year for any date?
In this article, we look at some cool ways that you can use conditional formatting to quickly visualize and understand key data.
Working with formulas takes time, and too often a problem that seems simple ends up taking far too long. In this article, I share tips that will save you time when working with formulas in Excel.
In this article, we take a short tour of some "unconventional" pivot tables you probably haven't seen before. These are interesting pivot tables that are summarizing something *other* than sales data.
What people are saying
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
Wonderful! // Excel Laminated Shortcut Card Wonderful!... I love it! Very helpful! Highly recommended! - Ricardo
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