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 »
Have you ever wanted to copy or import data from print, paper, images, or video into Excel? That used to be impossible without manually retyping it. But now you can automatically import the data in seconds with Excel’s new Import from Picture feature. Copy or import data from print, paper, images, or video into Excel
How to copy or import data from print, paper, images, or video into Excel Read More »
Microsoft recently added three new text functions to Excel: TEXTBEFORE, TEXTAFTER, AND TEXTSPLIT. These are incredibly powerful and will save you loads of time! Learn how to use these new text functions, some tips on making them even more useful, and how to add these to your version of Excel if you don’t already have
Three new Excel text functions to save you loads of time! 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 »
In this video, I explain why using the Merge & Center button in Excel can cause you all sorts of problems. I also show you the Center Across Selection feature, which accomplishes the same thing as Merge, but without any of the drawbacks. When you merge cells, it stops you from selecting individual columns in
Don’t merge cells! Center across selection instead Read More »
Mixed relative and absolute references are where you really start to become an Excel Rockstar. In my last video, I explained what relative and absolute references were. In part two, I show how you can mix them together to create large, powerful spreadsheets in seconds. As I explained in the previous video, a relative reference is when
Mixed Relative and Absolute References Make Powerful Excel Spreadsheets Easy! Read More »
Relative and absolute references are one of the key concepts to master as you move up to an intermediate Excel user. A relative reference is when a formula points to a cell a certain distance away. For example, it may say, “Multiply the cell immediately to the left of me by 2.” If you were
How Relative and Absolute References Work in Excel Read More »
Do you want to get better at Excel? Here I share some of my methods for improving at Excel over the course of your career/life. As a bonus, you get to see what I look like. Ways to get better at Excel Highlights: Getting better at Excel isn’t about knowing the most functions. It’s about
How to Get Better at Excel Read More »
Are your blank cells acting weird? Perhaps Excel is treating them like they’re not blank. Or it’s giving you bizarre errors. In this video, I explain what’s going on and how to fix it. How to fix blank cells acting weird If your blank cells are acting weird, it’s because Excel is seeing them as
Blank cells acting weird? Here’s how to fix it! 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 »
