XLOOKUP is one of the most useful tools in Excel, but doesn’t allow you to use multiple variables/criteria.
Here I show three ways to make this work:
– Use a SUMIFS
– Use a helper column
– Nest an XLOOKUP inside another XLOOKUP
How to do an XLOOKUP with multiple variables Read More »
Learn how to make a goal tracker in Excel in minutes!
Great for:
– Weight loss
– Exercise targets
– Self-improvement
– Learning a skill
– Reading X books per year
– Sending out a certain number of sales pitches per week
Make a Goal Tracker in Excel in 11 Minutes Read More »
Figuring out how to make a Dungeons and Dragons encounter hard enough to be a challenge to the players, but not so hard that it kills the entire party, is quite difficult. The method for doing so involves a lot of trial and error and repetitive math. Here I walk you through creating an Excel
Build a Dungeons and Dragons encounter tool in Excel – an XLOOKUP tutorial Read More »
Cleaning messy data in Excel is both an art and a science. Often the same cells contain multiple types of information that need to be separated, you have garbage information to remove, or columns contain a mix of different things. Here I go through three examples of messy spreadsheets, showing some of the methods I
Cleaning Messy Data in Excel Read More »
Did you know that Excel can do research? It can automatically find information for you. And it can also display information on maps. All in a matter of seconds. Excel can do research using Data Types Let’s say you want to do research about a country. Simply enter the country’s name in a cell. Then
Excel can do research for you! Find facts and build heatmaps in seconds Read More »
You may want to standardize names in Excel if you’re combining multiple sources where the names come in different formats. Sometimes the first and last name are in different columns. Sometimes you have the full name – or the first and last name separated by a space. And sometimes you have the last name, comma,
How to Standardize Names in Excel Read More »
Sometimes you need to compare large data sets. You may have two workbooks with thousands of rows, and want to know what’s changed between them. There are a lot of ways to do this in Excel, but some are harder and more time-consuming than others. I received a question about the best/fastest way to do
Three quick ways to compare data sets in Excel Read More »
SUMIFS is one of the most powerful tools in Excel. In this video, I show how you can easily use SUMIFS to rapidly create a fully functional, well-polished tool to track and categorize your expenses, in under 15 minutes. To learn more about creating tools like this, using Excel to get more done in less
Using SUMIFS to Build an Expense Tracker in 14 Minutes Read More »
