

Category Archives for "Excel Tips"

5 Lookup the Second, the Third, or the Nth Value in Excel

Formula to lookup the second third and nth value

Watch Video – Lookup the Second, the Third or the Nth Matching Value When it comes to looking up data in Excel, there are two amazing functions that I often use – VLOOKUP and INDEX (mostly in conjunction with the MATCH function). However, these formulas are designed to find only the first instance of the lookup […]

10 Use IFERROR with VLOOKUP to Get Rid of #N/A Errors

Error with VLOOKUP when lookup value not found

When using the VLOOKUP formula in Excel, sometimes you may end up with the ugly #N/A error. This happens when your formula can not find the lookup value. In this tutorial, I will show you different ways to use IFERROR with VLOOKUP to handle these #N/A errors cropping up in your worksheet. Using the combination […]

0 FREE Monthly & Yearly Excel Calendar Template (2017 and Beyond)

Calendar Contemporary Digital Device Concepts

I am a big fan of using Excel templates to plan and manage work. I regularly use to-do lists and calendars to plan my days in advance. In this post, I am sharing some useful Excel calendar templates that you can use in Excel or even take a print and stick where you work. While […]

0 How to Calculate Compound Interest in Excel + FREE Calculator

Calculating Compound Interest in Excel Calculator

“Compound interest is the eighth wonder of the world. He who understands it, earns it … he who doesn’t … pays it”. – Albert Einstein What is Compound Interest? Let me take a simple example to explain it. Suppose you invest USD 1000 in a bank account that promises to give you 10% return at the end of […]

12 Highlight the Active Row and Column in a Data Range in Excel

A Demo to Show how to highlight active row and column on selection change

One of the Excel queries I often get is – “How to highlight the Active Row and Column in a data range?” And I got one last week too. So I decided to create a tutorial on it. It will save me some time and help the readers too. Now, let me first show you what […]

0 Drop Down Lists To Show Numbers Between Two Specified Numbers

Drop Down List Between Numbers helper column

I recently got an email from one of my readers with an interesting query on using drop-down lists in Excel. He asked me if it was possible to have a drop-down list that shows numbers based on the two specified numbers. Something as shown below: Note that the drop-down start from the number in column […]

0 What is Standard Deviation and How to Calculate it in Excel?

Standard deviation is a commonly used statistic when analyzing data sets. A standard deviation value would tell you how much the dataset deviates from the mean of the data set. For example, suppose you have a group of 50 people, and you are recording their weight (in kgs). In this dataset, the average weight is 60 kg, […]

« Previous 1 2 3 4 … 31 Next »