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.
VLOOKUP is one of the most used functions in Excel. It looks for a value in a range and returns a corresponding value in a specified column number. Now I came across a problem where I had to lookup entire row and return the values in all the columns from that row (instead of returning a …
Last week, I came across an Excel problem in a forum. I immediately sprung into action and created a long formula that started with OFFSET(). Within a few hours, it was shot down by other Excel experts as it contained volatile formulas. I immediately recognized the cardinal sin I had committed. So with this confession, …
Sometimes, you may want the options in one drop-down list to change based on what you pick in another. This is called a dependent drop-down list. For example, when you pick Furniture as the category, the second drop-down should only show items such as Chairs and Tables. Excel doesn’t have this as a built-in feature, …
A lot of times people ask me to help them in rectifying an error in their nested IF function. And sometimes their formula is bigger than this blog post (seriously! not kidding). However, in some of the cases, this long formula can be cut short by using the VLOOKUP function. Avoiding Nested IF Function Consider …
A Scroll Bar in Excel is what you need when you have a huge dataset and you don’t want it to hijack your entire screen’s real estate. It’s a great tool to use in an Excel Dashboard where you have to show a lot of data in a limited space. In this step-by-step tutorial, I …
Can we look-up and return multiple values in one cell in Excel (separated by comma or space)? I have been asked this question multiple times by many of my colleagues and readers. Excel has some amazing lookup formulas, such as VLOOKUP, INDEX/MATCH (and now XLOOKUP), but none of these offer a way to return multiple …
If you have a list where the same value repeats, you may want every occurrence of that value to carry the same serial number, no matter where it shows up in the list. A regular 1, 2, 3 fill won’t do this, because it gives every row a different number. But it’s simple to fix …
In this tutorial, I will show you how to create a drop-down filter in Excel so that you can extract data based on the selection from the drop-down. As shown in the pic below, I have created a drop-down list with country names. As soon as I select any country from the drop-down, the data …
In some cases, you may want to insert an image in the comments boxes in Excel. For example, if you have a list of products, then inserting product images in the comment box could make your Excel sheet easy to use. As soon as the user would hover the mouse over a cell that has a …
©trumpexcel.com – Free Online Excel Training
