Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
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, …
An Excel drop down list is a useful feature when you’re creating data entry forms or Excel Dashboards. It shows a list of items as a drop down in a cell, and the user can make a selection from the drop down. This could be useful when you have a list of names, products, or regions …
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 …
©trumpexcel.com – Free Online Excel Training
