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 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 …
So you keep hearing these three names: Power Query, Power Pivot, and Power BI. And because they all start with Power, it sounds like three versions of the same thing. They are not. Two of them are features that already sit inside your copy of Excel, and one is a separate app altogether. In this …
If you use Power Query and Pivot Tables (or Power BI), you have probably hit this question: should I do this calculation in Power Query or in DAX? And this is confusing because both tools can add columns and do calculations, so it often feels like either one would work. But nothing to worry about. …
If you want to look up a value using two or more conditions at once, a regular lookup won’t get you there. It can only match on a single column, so the moment two rows share the same name (or the same month), it just grabs the first one it finds. The fix is to …
The IF function is one of the most useful functions in Excel. You give it a condition to check, and it gives you one result when that condition is met and a different result when it isn’t. Simple idea, and you end up using it everywhere. But a single IF can only check one condition …
©trumpexcel.com – Free Online Excel Training
