

Category Archives for "Excel Tips"

4 Understanding Absolute, Relative, and Mixed Cell References in Excel

Mixed Cell References in Excel - Formula

A worksheet in Excel is made up of cells. These cells can be referenced by specifying the row value and the column value. For example, A1 would refer to the first row (specified as 1) and first column (specified as A). Similarly, B3 would be third row and second column. The power of Excel lies […]

0 How to Enable and Use Track Changes in Excel

When What and Where in accept reject changes in excel

Watch Video – How to Track Changes in Excel If you work with an Excel file that needs to be updated or reviewed by other people, the option to track changes can come in handy. You can also use it when you’re updating a file and need to keep a track of all the changes […]

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

1 2 3 … 30 Next »