Excel Formulas

How to Scale Data from 1 to 10 in Excel (3 Quick Methods)

Sometimes when we work with data in Excel, we need the scaled value with respect to the range of data. It’s quite simple to scale data in Excel and ...

How to Create a Rating Scale in Excel (4 Easy Ways)

We will use the following dataset to demonstrate how to make a rating scale. It has a number of products and a rating score for each of them. ...

Scaling Formula in Excel (6 Practical Examples)

There are different ways to scale data in Excel. We can present data within a range or based on a scaling factor. In this article, we will show ...

How to Do Data Scaling in Excel (3 Easy Methods)

If you are looking for special tricks to know how to scale data in Excel, you've come to the right place. There are numerous ways to do scaling data ...

How to Generate All Possible Combinations of a Set of Numbers in Excel

Creating combinations among a list of data is a common phenomenon in our daily lives. Previously this task was accomplished by mathematicians as it ...

How to Calculate 2 Sigma in Excel (2 Easy Ways)

If you are looking for a way to calculate 2 sigma then you have come to the right place. The main objective of this article is to explain how to ...

How to Get All Combinations of 2 Columns in Excel (4 Easy Ways)

In this article, we will discuss how to get all combinations of 2 columns in Excel. Users often need to combine the values of two columns to get an ...

How to Create a Leaderboard in Excel (with Easy Steps)

The procedures to create a leaderboard in Excel in this tutorial can also be used to create any type of dataset to rank a list of data. Step 1 - ...

How to Generate or List All Possible Permutations in Excel

When the order of the arrangements is concerned, a permutation is a mathematical technique that establishes the total number of possible arrangements ...

How to Make a Calculator in Excel (with Easy Steps)

The calculator is a part and parcel of our daily life. We can use the calculator directly inside Excel without switching to other applications or ...

How to Set Due Date Reminder Formula in Excel (2 Easy Methods)

This tutorial will demonstrate how to set the due date reminder formula in Excel. In Microsoft Excel, we can use different methods to set the due ...

How to Calculate Coefficient of Skewness in Excel

Coefficient of skewness is a very important tool to understand a dataset’s main notion. In which direction is the dataset actually lean in which may ...

How to Create All Combinations of 4 Columns in Excel (2 Ways)

In this article, I will show you how to create combinations of 4 columns in Excel. Combination in Excel is one of the most frequently used processes ...

How to Convert Complex Numbers to Polar Form in Excel

Introduction to the Polar Form of Complex Numbers Complex numbers are commonly written in x+iy format, where i stands for √(-1), x is the real ...

How to Create Permutation Table in Excel (4 Easy Methods)

This tutorial will demonstrate how to determine Excel permutation table. We use the Permutation in Excel where in the data the order of the data ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo