

Category Archives for "Excel Tips"

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

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

3 Excel Personal Macro Workbook | Save & Use Macros in All Workbooks

When you create a macro in a workbook in Excel, it can only be used in that workbook. But what if you have a list of useful Excel macros that you want to use in all the workbooks? In such a case, it’s a good idea to save these in your Personal Macro Workbook. Doing this […]

1 2 3 … 29 Next »