Excel Formulas

How to Create Excel Checkbook Register with Reconciliation

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

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

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 Count Unique Values in Excel with Multiple Criteria

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 Ignore Blank Cells in Named Range in Excel

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 Use Named Range in Excel VLOOKUP Function

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 Create Fibonacci Sequence in Excel ( 2 Easy Methods)

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

How to Remove Characters from Left and Right in Excel

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 Use LARGE and SMALL Function in Excel (3 Examples)

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 Limit Decimal Places in Excel (5 Easy Ways)

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 Use Excel Large Function in Multiple Ranges

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 Perform Bank Reconciliation Using VLOOKUP in Excel

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 Find Largest Number in Excel (2 Suitable Examples)

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

How to Use Conditional Formatting If Statement Is Another Cell

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

How to Use ISBLANK Function in Excel for Multiple Cells

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 Find Standard Deviation of Probability Distribution in Excel

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

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo