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 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...
In this video, we'll look at a few ways to generate random values with the RANDBETWEEN function. You can use this approach to generate random numbers, random prices, random dates, and...
When you copy and paste a pivot table, a hidden data cache still remains. This video shows a simple way to copy a pivot table without the source data, while preserving all formatting.
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
Huge Help- // Excel Laminated Shortcut Card ExcelJet's shortcut cards are a huge help- I've bought some for employees who didn't have much experience with Excel and they all found them incredibly helpful. The cards are well organized, give info for both PCs and Macs, and are very durable. For the price, they're an incredibly helpful reference. - Jonathan
Excel Shortcuts WIN battle with Mouse // Excel Laminated Shortcut Card If you want to learn shortcuts to limit your use of the mouse, then this Shortcut Card is essential!! ExcelJet has produced a VERY useful list of shortcuts easily referred to in one laminated sheet (front & back). I purchased 5 of them directly from their website and have given them to my co-workers. Their training is awesome too! - Allen
I passed! // Core ExcelI passed the Microsoft 2010 Excel Specialist Certificate Exam this afternoon. Thank you so much for your lectures for the course Excel Core! They help me a lot when preparing my exam! [Note: Excel Core course is not primarily designed for Excel Certificate Exam review purpose.] - Chenhao
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
