Excel Formulas

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

How to Get Remainder in Excel (3 Simple Methods)

Microsoft Excel is a handy software. We use Excel functions and features for our educational, business, and other daily life purposes. Furthermore, ...

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)

In this article, I will show how to calculate delta percentages in Excel. In many situations, we not only need the absolute change of a value but ...

How to Calculate Delta Delta CT in Excel (With Easy Steps)

In this article, I will show how to calculate delta delta CT (Cycle Threshold) in Excel by using 4 easy steps. When you work on an Excel worksheet, ...

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 Left in Excel (5 Suitable Ways)

When you have a big dataset with text as cell values, then you may need to shorten the text in Excel. Basically, you can truncate a text either from ...

How to Calculate Delta E Color in Excel (4 Suitable Methods)

If you want to find out the color difference between two samples, then you should calculate Delta E Color in Excel. So, if you are looking for how to ...

How to Truncate Date in Excel (4 Simple Methods)

Microsoft Excel is a handy software. We use Excel functions and features for our educational, business, and other daily life purposes. Furthermore, ...

How to Sum All Possible Combinations in Excel

Excel is a handy tool to carry out different calculations. It's often used for summation. This article is about how you can sum all possible ...

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

Excel concatenation is a useful and frequently used feature. If you want to join or delimit text, this article might be useful to you. In this ...

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 Option Greek Delta in Excel (with Easy Steps)

The Option Greek Delta calculates the rate of change in option prices in relation to the value of the underlying assets. The Greeks are more ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo