Looking for some awesome Excel tips and tutorials? You’re at the right place.
Here you’ll find a collection of amazing excel tips that will make you an Excel Ninja and save a lot of time.
All the Excel tips are covered in detail with supporting images and a video (in most of the cases).
If you’re a beginner in Excel, you can start from out Learn Excel section.
You also find tips and tutorials on various Excel topics such as charting, dashboards, and VBA. In addition to the tutorials, you will also find some useful Excel templates that you can download for free.
You will also find Excel formula tips to get common tasks done using the formulas. You can also visit the Excel Functions section to learn about most commonly used Excel functions such as VLOOKUP, INDEX, OFFSET, COUNTIF, IFÂ and so on..
Also check out our Online Excel Training courses on Excel (Basic to Advanced), Dashboard, and VBA.
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 …
If you’ve tried giving a range to a function such as EOMONTH or the WORKDAY function, expecting it to spill the results, you’ve probably run into the #VALUE! error instead. And this is because some older Excel functions were never taught how to handle a range of cells as an input. But nothing to worry …
If you want to insert a checkbox in Excel, whether it’s for a to-do list, a tracker, or an interactive chart, this has now become really easy. Earlier, Excel only had checkboxes that floated over the worksheet as separate objects, and you had to enable the Developer tab just to get to them. Excel now …
©trumpexcel.com – Free Online Excel Training
