Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
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 …
A colleague asked me if there was a way to create a dynamic in-cell 100% stacked bar chart in Excel for three product sales. As usually is the case, there were thousands of rows of data. There is no way she could have used Excel in-built charts as that would have taken her ages to …
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 a created a drop-down list with country names. As soon as I select any country from the drop-down, the …
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 …
A few days ago, I was working with a data set that included a list of companies in Excel along with their logos. I wanted to place the logo of each company in the cell adjacent to its name and lock it in such a way that when I resize the cell, the logo should …
©trumpexcel.com – Free Online Excel Training
