Using Excel to Lookup Partial Text Match [2 Ways]

In this article, I will show you how to use Excel to lookup for partial text match. For this, we can use VLOOKUP or INDEX MATCH functions combo. In the following image, you are seeing some company ...

How to Separate Words in Excel Using Formula (Ultimate Guide)

Separating words are important in Excel to extract information from your worksheet. There are many methods of doing that. Here, in this article, we will see “How to Separate Words in Excel Using ...

Match Two Columns in Excel and Return a Third (3 Ways)

Sometimes while working with multiple columns you often need to match your two columns to return the third value. In this article, we will see how to match two columns in Excel and return a third. In ...

VLOOKUP Formula to Compare Two Columns in Different Sheets!

If you have two big columns and you want to compare them, you can use Excel’s VLOOKUP function. In this article, I will show how you can use VLOOKUP formula to compare two columns in different ...

Excel Formula Symbols Cheat Sheet (13 Cool Tips)

In this article, you are going to see some Excel formula symbols cheat sheet. This article will be helpful for learning about the process of inserting a formula in Excel. First of all, we are going ...

How to Calculate Variance in Excel

In this article, we shall show you how to calculate variance in Excel. Variance is one of the most useful concepts in statistics. It gives the measurement on how the numbers of data are distributed ...

How to Use Compound Interest Formula in Excel

Compound interest is the interest that's calculated both on the initial principal of a deposit or loan and on all previously accumulated interest.In this article, we are going to learn the compound ...

How to Generate Random Numbers in Excel (Ultimate Guide)

Random numbers are those numbers which are generated by a process in which the outcome is not predictable and in a defined interval/set, the values are uniformly distributed. Random numbers are used ...

3D Referencing & External Reference in Excel

Creating 3D referencing in Excel within a formula involves referring to the same cell or the same range of cells, on different worksheets. Each of the sheets, one is using, to create the 3D reference ...

How to use the TODAY() and NOW() Functions in Excel

The TODAY() Function is used to determine the current date, as in the date one is actually opening the workbook. This function updates automatically, so let’s say you open the workbook on 1 April ...

How to Use the FORMULATEXT Function in Excel

The FORMULATEXT Function is a new Excel function, which was introduced in Excel 2013 and later versions of Excel. Using the FORMULATEXT Function will allow you to select any cell containing a formula ...

The Different Ways of Counting in Excel

There is a total of five functions used for counting, predominantly in Excel. These are namely the COUNT Function, the COUNTA Function, the COUNTIF Function, the COUNTIFS Function and the COUNTBLANK ...

Calculate Depreciation in Excel (Straight Line, Double Declining…)

An asset is defined as a resource with an inherent economic value that is owned by an individual, corporation or country which will yield future economic benefit. Accountants list assets on balance ...