Excel Formulas Archives - Page 3 of 193

How to Create Excel Checkbook Register with Reconciliation

Apr 13, 2023

In this article, we will demonstrate how to create an Excel checkbook register with Reconciliation. Bankers typically employ reconciliation in their ...

How to Create Excel Checkbook Register with Reconciliation

How to Use ISNUMBER & MATCH Function in Excel (2 Ways)

Feb 16, 2023

Looking for ways to use ISNUMBER & MATCH function in Excel? Then, this is the right place for you. You can use both of these functions together ...

How to Use ISNUMBER & MATCH Function in Excel (2 Ways)

How to Count Unique Values in Excel with Multiple Criteria

Jan 25, 2023

In this article, we will show you some methods to count unique values in Excel worksheet based on different criteria. The Excel worksheet can be used ...

How to Count Unique Values in Excel with Multiple Criteria

How to Ignore Blank Cells in Named Range in Excel

Mar 14, 2023

You may have seen many Excel Sheets with blank cells. Some of these blank cells may even exist under a Named Range. Excel in general doesn’t do ...

How to Ignore Blank Cells in Named Range in Excel

How to Use Named Range in Excel VLOOKUP Function

Apr 17, 2023

The VLOOKUP function is one the most commonly used functions in Microsoft Excel. We use the VLOOKUP function to find values in a table to extract ...

How to Use Named Range in Excel VLOOKUP Function

How to Create Fibonacci Sequence in Excel ( 2 Easy Methods)

Jan 25, 2023

Today we will discuss how to create a Fibonacci Sequence in Excel. Numerous mathematical applications exist for the Fibonacci sequence. The Fibonacci ...

How to Create Fibonacci Sequence in Excel ( 2 Easy Methods)

How to Remove Characters from Left and Right in Excel

Mar 13, 2023

Today we will discuss how to remove characters from left and right in a string of characters in Excel. Sometimes, there may be extra characters in a ...

How to Remove Characters from Left and Right in Excel

How to Use LARGE and SMALL Function in Excel (3 Examples)

Jan 25, 2023

If you want to find the 3rd most expensive smartphone from a list of smartphones, or you’re searching to solve a problem like this, you’re on the ...

How to Use LARGE and SMALL Function in Excel (3 Examples)

How to Limit Decimal Places in Excel (5 Easy Ways)

Jan 26, 2023

It is very necessary to limit decimal places in Excel to progress with further calculations. Sometimes it is irritating to have so many digits after ...

How to Limit Decimal Places in Excel (5 Easy Ways)

How to Use Excel Large Function in Multiple Ranges

Jan 23, 2023

You can implement an Excel statistical function while using a dataset. At times, you need to know the largest value in multiple ranges. Then, we need ...

How to Use Excel Large Function in Multiple Ranges

How to Perform Bank Reconciliation Using VLOOKUP in Excel

Jan 26, 2023

Accountants always have to do reconciliations in their daily job. It helps to observe and maintain equality in both-sided transaction ledgers. One of ...

How to Perform Bank Reconciliation Using VLOOKUP in Excel

How to Find Largest Number in Excel (2 Suitable Examples)

Apr 18, 2023

Microsoft Excel facilitates us to estimate various types of data as well as perform monetary, arithmetic, and statistical computations. In many ...

How to Find Largest Number in Excel (2 Suitable Examples)

How to Use Conditional Formatting If Statement Is Another Cell

Jan 22, 2023

Conditional Formatting is an excellent feature to format your worksheet based on specific criteria. For instance, you can use Conditional Formatting ...

How to Use Conditional Formatting If Statement Is Another Cell

How to Use ISBLANK Function in Excel for Multiple Cells

Mar 13, 2023

ISBLANK is the function that we use to check whether a cell in Excel is empty or has value. We may use this for a cell or in a range of cells. In ...

How to Use ISBLANK Function in Excel for Multiple Cells

How to Find Standard Deviation of Probability Distribution in Excel

Feb 2, 2023

Probability distribution indicates a probability of a variable depending on a certain value. While working on probability distribution, we must find ...