Excel Formulas

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

Method 1 - Using Excel Power Query Editor to Combine 2 Columns Steps: Select cell B5 in the Gender column. Go to the Insert tab. Select ...

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

A permutation is a mathematical technique that establishes the total number of possible arrangements in a collection. We can generate and list all ...

How to Get Complex Number Magnitude in Excel (2 Easy Methods)

In this article, I will show how to get the magnitude of a complex number in Excel by using 2 easy methods. You may need mathematical calculations ...

How to Calculate Payroll Overtime with Formula in Excel

If you want to calculate payroll for overtime then this article will be beneficial for you. The focus of this article is to explain how to calculate ...

[Solved]: HEX2DEC Not Working in Excel

Microsoft Excel comes with the handy use of multiple functions to make your work quicker. The HEX2DEC function is an essential function if you are ...

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

Step 1 - Create the Outline We arranged the input and the output cells as shown below. Read More: How to Create a Calculator Using Macros ...

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

We have Buyer in column B, Amount in column C, Due Date in column D, and Output in column E. We'll use this dataset to set a due date reminder. ...

How to Do Factorial in Excel (6 Easy Methods)

The product of all positive integers less than or equal to n in mathematics is known as the factorial, indicated by the symbol (n!). In other words, ...

[Solved!] Name Error of PI Function in Excel

In this article, we will discuss the Name Error of the PI Function in Excel. The Name Error is a common error in Excel. There are many reasons for ...

How to Calculate Coefficient of Skewness in Excel: 3 Methods

Method 1 - Calculate Pearson’s Skewness in Excel by Using Descriptive Statistics 1.1 Use AVERAGE, MODE.SNGL, STDEV.P Functions Steps: Select ...

How to Add Complex Numbers in Excel (With Easy Steps)

In some branches of engineering and science, we often face operations with complex numbers. Fortunately, Excel has included different operations for ...

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

We have some digits in 4 columns. We are going to merge these columns with multiple combinations. Method 1 - Create All Combinations of 4 ...

[Fixed!] Excel MOD Function Not Working (3 Issues with Solutions)

Sometimes you may need to use the MOD function in Excel. Eventually, the MOD function may not be working in Excel. In that case, if you are looking ...

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 ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo