Conquer Excel
Our approach is quick, clean, and to the point. Join more than 100,000 people who get weekly updates from us.
Latest videos
In this video, we show how to plot American generations in a floating horizontal bar chart. This seems like a simple problem, but it requires a formula, clever formatting, and a special...
In this video, we look at a step by step approach to randomly assign people to groups with teams using formulas. Along the way, we use three functions (RAND, RANK, and CEILING), helper...
In this video, we show examples of the 8 Excel formula errors you're likely to run into, and simple steps you can take to fix them. We look at #NAME?, #DIV/0!, #NUM!, #NULL!, #NA, #...
In this video, we look at how to build a chart that automatically includes new data, and dynamically highlights the top and bottom values. This is an easy way to create an interactive chart...
In this video, we'll look at how you can use the CHOOSE function for simple lookups. The CHOOSE function doesn't need an external table, and can sometimes replace more complicated...
Latest Blog
The challenge - calculate the difference from the current and last entry, even when previous entries are skipped. This is one of those problems that seems simple at first glance, but is tricky when you look closely.
Once you start to add dropdown menus to your spreadsheets, you'll inevitably run into a challenge: how can you make one dropdown dynamically respond to another? More generally, how can you make the values in a dropdown list depend on another value in the worksheet?
Data validation can help control what a user can enter into a cell. You could use data validation to make sure a value is a number, a date, or to present a dropdown menu with predefined choices to a user. This guide provides an overview of the data validation feature.
Sure, you can use a complicated WEEKDAY formula to generate a list of weekends. But with WORKDAY.INTL, you can do the same thing with a WAY simpler formula. The trick is to use a special 7-digit "mask" to filter out all dates except weekends.
You have a fixed monthly payment, a start date, and a given number of months. You have five years shown on the worksheet. What formula can you use to sum total payments by year?
What people are saying
Super handy reference // Excel Laminated Shortcut Card Super handy reference. Takes my Excel skills way beyond my standard repertoire CTRL C and CTRL V. - Anthony
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
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.
Great Examples // Excel Conditional FormattingI LOVE your lessons on conditional formatting. All sorts of new and better ways. That’s been a real weak point for me, and you have great examples. - Sally
