Excel Formulas

How to Calculate Deviation in Excel (3 Easy Examples)

In this article, I will show you how to calculate standard deviation in Excel. In many situations, we need to calculate standard deviation whether ...

How to Verify Odd and Even Using IF Function in Excel

Verifying whether a number is odd or even can be a useful task in a variety of situations, such as data analysis or creating formulas for ...

How to Sort Odd and Even Numbers in Excel (4 Easy Examples)

Example 1 - Using ISODD Function to Sort Odd and Even Numbers in Excel We have added a Helper Column in the dataset where we will use the ISODD ...

How to Find the Intersection of Two Columns in Excel (7 Methods)

Below is a monthly sales dataset of Products A, B, and C. Using simple tricks, we will find the intersection between these sales columns. ...

How to Do Union of Two Columns in Excel (5 Easy Ways)

We have the Addresses of Employees of a Company as our dataset. We have information on the Street and the City for each employee. We will do a union ...

How to Find Sum of Squared Deviations in Excel (2 Easy Ways)

As financial analysts, we use Excel functions to calculate the sum of squared deviations in evaluating the variation in daily stock values. Moreover, ...

How to Separate Odd and Even Numbers in Excel – 6 Methods

To separate odd and even numbers: Method 1 - Combining the  FILTER and the MOD Functions to Separate Odd and Even Numbers Steps: In ...

How to Find Standard Error of Estimate in Excel (3 Easy Ways)

In this tutorial, I am going to show you 3 easy methods of how to find the standard error of estimate in Excel. You can quickly use these methods to ...

How to Check If a Number Is Odd in Excel (3 Easy Ways)

Looking for ways to check if a number is odd in Excel? Then, this is the right place for you. You can easily do that by using some functions. Here, ...

How to Fill Odd Numbers in Excel (5 Suitable Examples)

In this article, you will learn how to fill in odd numbers in Excel. How to Fill Odd Numbers in Excel: 5 Suitable Examples 1. Use Fill Handle ...

List of Dynamic Array Formulas in Excel (7 Practical Examples)

In this tutorial, I am going to share with you 7 practical list of dynamic array formulas in Excel. You can easily apply these functions to perform a ...

Can Excel DGET Return Multiple Records [See 4 Solutions]

The DGET function in Excel is a database function and is designed to return only one record. In case you have multiple matches and need to return ...

How to Use DSUM Function with Multiple Criteria in Excel

An individual might need to sum up only the values that satisfy certain criteria from a large dataset. The DSUM function can be very useful if we ...

How to Use Multiple IFERROR Statements in Excel (2 Smart Ways)

Microsoft Excel is a powerful tool for organizing and analyzing data, but sometimes our data isn't always clean and error-free. That's where the ...

How to Create Deviation Report Format in Excel (with Easy Steps)

Microsoft Excel is one of the most powerful programs. Its features and functions allow us to use any information fully. In this piece, we'll go ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo