Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
If you want to stop other people from opening your Excel file, you can add a password to it in less than a minute. For example, if you email a salary sheet to your manager, a password makes sure nobody else can open it, even if the email gets forwarded. But Excel has a few …
To fix the #SPILL! error in Excel, you need to find out what’s stopping your formula from filling the cells it needs, and then remove that obstacle. Most of the time, it’s something small sitting in the way. In this article, I’ll show you the common reasons you get this error and how to fix …
If you want to make all the cells in your worksheet the same size, you may have noticed that Excel doesn’t have a single button that does it. Your rows and columns end up looking uneven no matter what you try. But nothing to worry about. Once you select everything first and set one width …
If you want to change the case of text in Excel, you may go looking for a one-click button like the one in Word. Excel does not have one. That is nothing to worry about. Excel gives you a few easy ways to switch text to all caps, lowercase, or proper case, and I’ll cover …
To use XLOOKUP with multiple criteria, you combine your conditions into something one lookup value can find. XLOOKUP only takes a single lookup value, so this small workaround is what lets it match on two, three, or more columns. In this article, I’ll show you three ways to do it, starting with the one I …
If you’re deciding between an Excel Table and a normal range, start with how you’ll use the data. For a list that keeps growing, a Table can save you from updating formulas and report sources each time you add records. For a report layout or a few input cells, a normal range gives you more …
If you want to add up numbers based on a condition, Excel gives you two functions that look almost identical, SUMIF and SUMIFS. And it’s not always obvious which one you should pick. The short version is that SUMIF handles one condition and SUMIFS handles one or more. But there are a few less obvious …
If you want to check whether two or more conditions are true at the same time, a plain IF function won’t get you there. For example, you may want to pass a student only if they scored at least 50 and also have 75% attendance. That’s because IF only tests one condition at a time. …
If you know the password and just want Excel to stop asking for it, you may have noticed there’s no single “remove password” button. That’s because Excel has four different kinds of passwords, and each one lives in a different place. But once you know which one you’re dealing with, removing it takes less than …
©trumpexcel.com – Free Online Excel Training
