# Category Archives for "Excel Tips"

## 19 How to Create a Dependent Drop Down List in Excel

Watch Video – Creating a Dependent Drop Down List in Excel 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 […]

## 2 Avoid Nested IF Function in Excel…VLOOKUP to Rescue

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 […]

## 21 How to Create a Scroll Bar in Excel – Step by Step Tutorial

Watch Video – Creating a Scroll Bar in Excel 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 […]

## 7 Conditional Formatting to Create 100% Stacked Bar Chart in Excel

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 […]

## 28 Get Multiple Lookup Values in a Single Cell (With & Without Repetition)

Can we get multiple lookup values for an item in a single cell (separated by comma or space)? I have been asked this question multiple times by many of my colleagues. And after a lot of head-banging, I realized that it is extremely difficult (if not impossible) to do this using excel functions. So I did […]

## Avoid Duplication in Serial Numbers in Excel

A friend called me and asked if there is a way to have serial numbers in such a way that they are no duplication in serial numbers in Excel. Something as shown below: He wanted that the serial number for India should be 1 wherever it occurs. Similarly, US is the 2nd country and should always […]

## 81 Creating a Drop Down Filter to Extract Data Based on Selection

Watch Video – Extract Data Using a Drop Down List in Excel 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 […]