Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
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 …
Excel Text to Speech feature (also called Speak Cells in Excel) was introduced in the 2003 version of Excel. While I believe this feature is more useful in MS Word, PowerPoint, or even Outlook, you may find it helpful in Excel in some cases. As the name suggests, it converts text into speech and can …
Watch Video – Excel Camera Tool and How to Use it! For all those who think working with Excel is boring, here is your answer to them – Excel Camera Tool. Now, don’t get all excited. It’s is not about a fancy DSLR and lens. It’s just another feature with a cool name. To begin …
©trumpexcel.com – Free Online Excel Training
