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.
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 …
You wrote a VLOOKUP, hit Enter, and instead of the value you expected you got a #N/A error (or worse, a wrong number). It’s one of the most frustrating things in Excel, and it almost always comes down to a small mismatch between what you’re looking up and what’s actually sitting in your table. The …
If you have a list with some gaps in it and you want to know how many cells actually have something in them, you cannot always trust a quick eyeball count. And this is because some cells that look empty are not truly empty, like a cell with just a space or a formula that …
If you have a formula that suddenly shows #NUM! instead of a result, it means Excel ran into a number it cannot work with. This happens when a calculation produces an invalid numeric value or a result that falls outside the range Excel can handle. The good news is that #NUM! almost always points to …
Say you have twelve monthly sheets that all look the same, and you want one total that pulls the same cell from each sheet. The manual way is to type out =Jan!B5+Feb!B5+Mar!B5 and keep going… for nine more months. There is a much better way. It is called a 3D reference, and it lets you …
If you want to convert minutes into hundredths in Excel, the trick is to turn each value into decimal hours. This is what payroll systems use, where The reason people get stuck is that the right formula depends on how your data is stored. A plain number like 90 needs one approach, and a real …
©trumpexcel.com – Free Online Excel Training
