Excel Formulas

How to Use FACTDOUBLE Function in Excel (4 Examples)

While dealing with Microsoft Excel, sometimes we need to calculate the double factorial of an integer. The FACTDOUBLE function is a built-in function ...

How to Make a Payroll System in Microsoft Excel with Payslip

In this tutorial, I am going to show you the step-by-step procedures on how to make a payroll system in Microsoft Excel with a payslip. You can use ...

How to Add Prefix to Entire Column in Excel (4 Simple Methods)

Microsoft Excel is undoubtedly one of the most essential and valuable computer programs today. Using Excel's tools and features, we can do any number ...

How to Apply All Combinations of 3 Columns in Excel

Sometimes we need to find combinations of various things. Only a few different things can have a large number of combinations. As a result, finding ...

How to Multiply Pi in Excel (with 3 Practical Cases)

What is the value of Pi? I know it's a difficult question. Excel has an inbuilt PI function which is accurate up to 15 decimal points and can be used ...

How to Convert Decimal Number to Hexadecimal (Hex) in Excel

The article will focus on some key aspects of how to convert decimal numbers to hexadecimal format (hex) in Excel. There are many technical ...

How to Do Payroll Reconciliation in Excel (with Easy Steps)

Are you running a small or medium business? Then, you must be concerned about payroll reconciliation. Payroll reconciliation is crucial since it can ...

How to Show All Combinations of 5 Columns in Excel

Combination is a common task in our day-to-day professional life in different aspects. In Microsoft Excel, we can easily show all the combinations ...

How to Add Suffix in Excel (4 Easy Ways)

Microsoft Excel is undoubtedly one of the most essential and potent computer programs currently available. We can do unlimited calculations on any ...

How to Write Pi in Excel (5 Suitable Ways)

In this article, we will learn how to write Pi in Excel. There are many applications of Pi and it is the most common constant. For this reason, in ...

How to Add Suffix Without Formula in Excel (2 Easy Methods)

There are many ways to add suffix in Excel. Out of those many ways, we will show you 2 easy ways to add suffixes in Excel without a formula. Isn't it ...

How to Calculate Factorial Using Excel VBA (4 Effective Methods)

This tutorial will demonstrate how to create a User Defined Function to calculate the factorial of a number using Excel VBA. Determining factorial is ...

How to Create Vehicle Depreciation Calculator in Excel

The reduction in the value of an asset over multiple numbers of years is called Depreciation. A business organization purchases assets for its own ...

How to Add Text Suffix with Custom Format in Excel (5 Examples)

When working with Excel, we come across numerous types of data. Now, for large calculations, it would be easier to understand if we could get the ...

How to Remove Prefix 91 in Excel (4 Easy Ways)

There are instances when we need to remove the country code while working with a collection of phone numbers in Excel. We may exclude those country ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo