How to Create, Use, Edit and Delete Named Ranges in Excel

Names are one convenient identity. Imagine how we'd be addressed if we didn't have names? Excel tries to make our lives easier by providing us with a similar convenience.Excel's Names feature can be surprisingly powerful for organizing data in Excel. Named Ranges let you name a group of cells and then refer to them as a unit as if they were a … [Read more...]

How to Sort By Date in Excel

When you have a large data set to analyze, it’s often helpful to sort the dates in chronological order. Of course, Excel has some built-in tools to get the job done, but sometimes they can’t do exactly what we want. In this article, we’ll talk about everything you need to know about sorting dates chronologically.When you’re through, you’ll be … [Read more...]

How to Calculate Age in Excel (7 Easy Formulas)

Excel doesn't have a dedicated function for calculating age, but there are several ways we can use someone's date of birth to compute the person's age. We won't just learn how to compute someone's age in years, we'll even boil their age down to months and days.There are several formulas, as well as combinations of formulas, that we can use to … [Read more...]

How to Convert Text or Numbers To Dates in Excel

Let’s say you have an organization that makes hundreds of small transactions each day. You have several branches where the junior accountant punches in the numbers and dates into different software. It’s finally the end of the month, and you want to look at where you stand compared to the previous month.This will require that you draw a gazillion … [Read more...]

How To Add Days, Months & Years to Dates In Excel

Today, I am going to equip you with a few formulas that will enable you to add Days (Months or even Years) to a Date in Excel.These are particularly useful for financial analysts because it helps them play around with and manipulate time periods in their financial models. For example, while projecting cash flows, you may want to project them … [Read more...]

How to Concatenate in Excel – The Ultimate Guide

Often the data in your spreadsheets is not according to your needs, so you may need to replace some strings, split some text, merge cells or concatenate data to format the data as per your needs.In this tutorial, we are going to learn different ways to concatenate cells, columns, and ranges in excel. So, without further ado, let’s dive right … [Read more...]

How to Subtract Dates and Times in Excel

In the last article, we worked with the DATVALUE function to convert dates from text to a serial number. Now let’s take things up a notch and look at some formulas that will enable us to manipulate dates and times in a worksheet.In this tutorial, we will try to understand how to subtract dates in Excel and calculate the difference between dates … [Read more...]

How to Find and Fix Circular References in Excel

A circular reference occurs when you end up having a formula in a cell – which in itself uses the cell reference (in which it’s been entered) for the calculation. If this statement seems a bit confusing, don’t worry by the end of this tutorial it will start to make sense.In simple terms, a circular reference happens when a formula references … [Read more...]