Excel Formulas

How to Calculate Sales Mix with Formula in Excel

Today we will discuss how to calculate sales mix with a formula in Excel. Sales mix represents the share or relative percentage of different products ...

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

Introduction to ISNUMBER Function Function Objective The ISNUMBER function checks whether the value of a cell is a number or not. ...

How to Count Unique Values in Excel with Multiple Criteria

This article will show you some methods to count unique values in an Excel worksheet based on different criteria. The Excel worksheet can count ...

How to Ignore Blank Cells in a Named Range in Excel – 5 Methods

This will be the final output: The dataset showcases “Buying Price” and “Selling Price”. There are blank cells in "Selling Price”. To find ...

How to Use ‘Named Range’ in Excel VLOOKUP Function (2 Ways)

  Method 1 - Using Excel VLOOKUP Function with Named Range Steps: Select the range for which you want to give a name. In this dataset, ...

How to Create a Fibonacci Sequence in Excel – 2 Methods

This is an overview: Introduction to the Fibonacci Sequence The Fibonacci sequence is a set of integers starting with 0 and 1. The next ...

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

Why Is Limiting Decimal Necessary? To ensure clean and efficient calculations, we often round our decimal values. For instance, instead of using ...

How to Perform Bank Reconciliation Using the VLOOKUP Function in Excel – 3 Steps

This is an overview. There are transaction rows with discrepancies. Step 1 - Create a Dataset The first dataset is a Bank Statement: ...

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 the ISBLANK Function for Multiple Cells in Excel – 4 Methods

This is an overview. This is the sample dataset. Method 1 - Applying the ISBLANK Function to Check Multiple Blank Cells Steps: ...

How to Find Standard Deviation of Probability Distribution in Excel

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

How to Calculate Standard Deviation with IF Conditions in Excel

Method 1 - Calculate Standard Deviation with Single IF Condition Steps: Select the desired cell where we want to get the result as shown in ...

How to Calculate Absolute Deviation in Excel (2 Useful Examples)

Absolute Deviation is a useful tool that indicates the variability of a dataset. It gives a sense of idea about a dataset whether it is clustered or ...

How to Calculate Upper and Lower Limits in Excel (2 Methods)

In this article, we will learn how to calculate upper and lower limits in Excel using 2 different methods. We will use  the sales data of ten ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo