Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
Input Message in Excel can be used to show a message when a cell is selected. It is particularly useful if you want to show some instructions to the user when he/she selects a cell. Examples could be to display form filling instructions or data entry instructions. Can’t this also be done using comments in …
In this tutorial, you’ll learn how to find the position of the last occurrence of a character in a string in Excel. A few days ago, a colleague came up with this problem. He had a list of URLs as shown below, and he needed to extract all the characters after the last forward slash (“/”). …
Here is a neat trick for people who use maps in Excel. In this blog, I will explain how to highlight map in excel based on a drop down selection. I have taken an editable map of the US. The idea is to highlight a state in the US when its name is selected from a …
A few days ago, I was working on creating an Excel dashboard. I had to create a number of drop-downs with the options ranging from 1 to 5. To make it more user-friendly, I also wanted to give an option of ‘Not Selected’, when a user does not want to make a selection in the drop …
A lot of times we need to make a copy of a worksheet in Excel. Maybe you want to create a back-up worksheet, or you want to create a new worksheet but don’t want to redo the formatting. The long (and inefficient) way is: This will create a copy of the worksheet. While this is …
Excel Advanced Filter is one of the most underrated and under-utilized features that I have come across. If you work with Excel, I am sure you have used (or at least heard about the regular excel filter). It quickly filters a data set based on selection, specified text, number or other such criteria. In this …
Intersect Operator in Excel can be used to find the intersecting value(s) of two lists/ranges. This an unusual operator as it is represented by a space character (yes that’s right). If you use a space character in between two ranges, then it becomes the Intersect operator in Excel. Intersect Operator in Excel You can use Intersect …
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, …
©trumpexcel.com – Free Online Excel Training
