Excel Formulas

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

Permutation tables are very useful when the order and position of our data are important. In computer science, they play an essential role in sorting ...

How to Get Remainder in Excel (3 Simple Methods)

In this article, we will demonstrate 3 easy methods to obtain the remainder in Excel using the following dataset that contains numbers for division. ...

How to Insert Lowercase Delta Symbol in Excel (5 Easy Methods)

Delta is a Greek symbol widely used in scientific formulas and for other purposes. There are two types of delta symbols. One is uppercase(Δ) and the ...

How to Calculate Permutations Without Repetition in Excel

Permutation is such a great mathematical concept that has a significant impact on every aspect of education. We can see its usage in math, quantum ...

How to Calculate Delta Percentage in Excel (4 Easy Methods)

What Is Delta Percentage? The delta percentage is the percentage change in any quantity. For example, if a person's weight in June is W1= 70 Kg and ...

How to Calculate Delta Delta CT in Excel: 4 Methods

Method 1 - Getting Average CT Add two columns in E and H called the Average CT of both. The first one is for the Housekeeping Gene and the ...

How to Truncate Decimal in Excel (6 Easy Ways)

We often use decimal values in Excel. For practical purposes, we need to modify these decimal values. And Excel can do this modification very ...

How to Truncate Text from the Left in Excel -5 Methods

  The dataset showcases Employee Name and Working Period. Method 1 - Using the Excel LEFT Function to Abbreviate Text from the ...

How to Calculate Delta E Color in Excel – 4 Methods

What Is Delta E? Here, E represents “Empfindung”. Actually, Empfindung is a German word that means sensation. On the other hand, Delta is a Greek ...

How to Truncate Dates in Excel (4 Methods)

Method 1 - Using INT Function Background The INT function treats date/timestamp data as integers and decimals (date as integer & time as ...

How to Sum All Possible Combinations in Excel – 4 Steps

Step 1 - Initiating the Solver Add-in Make sure your Solver Add-in feature is active. Go to File > Options. Select Add-Ins and click ...

How to Concatenate with Delimiter in Excel (5 Easy Ways)

Method 1 - Use the “&” Operator to Concatenate with Delimiters Let's use a dataset that has first and last names in two columns. We will join ...

How to Calculate Factorial of Large Number in Excel

We frequently need to carry out some challenging mathematical computations while using Excel. The majority of these intricate mathematical ...

How to Get Remainder in Decimal in Excel (3 Suitable Ways)

Excel can be very helpful in determining remainders. One might need these remainders in Integer or in decimal format. In this article, we will show ...

How to Calculate Greek Delta in Excel – 4 Steps

What Are Option Greeks? Option Greeks are monetary indicators of how sensitive the price of an option is to the factors that determine it, such as ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo