# Category Archives for "Excel Tips"

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

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

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

## 1 How to Insert a Picture in Excel Comment

Watch Video – Insert Picture in Excel Comment In some cases, you may want to insert a picture in Excel comment boxes. 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 […]