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 with Payslip in Microsoft Excel – 4 Steps

In the sample dataset, cells with monetary values are in Accounting format. Step 1 - Creating a Dataset Enter the Employee names in the first ...

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

Method 1 - Apply CONCATENATE Function to Add Prefix in Excel Concatenate is defined as joining or combining. The CONCATENATE function connects text ...

How to Apply All Combinations of 3 Columns in Excel

Method 1 - Use Power Query Steps: Create 3 separate tables for 3 columns. Select the first column and press Ctrl+T. Create Table ...

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

In the dataset below, we have some positive and negative decimal numbers. Let's convert them to hexadecimal using 2 different methods. ...

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

We have a sample dataset with salary sheets of a company called SOFTEKO. Let's assume the current month is October. Step 1 - Open Salary Sheet ...

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)

How to Add Suffix in Excel: 4 Easy Ways Our sample dataset has three columns labeled Name, Suffix, and Email. Method 1 - Utilize CONCATENATE ...

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 a Vehicle Depreciation Calculator in Excel (3 Methods)

What is Depreciation? Depreciation refers to the gradual reduction in the value of an asset over several years. When a business organization ...

How to Add a Text Suffix with a Custom Format in Excel – 5 Examples

Example 1 - Adding a Text Suffix (e.g. Kg) for Mass The dataset below showcases multiple weight values. There is no unit. To add “Kg” as suffix ...

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

Column B has a list of phone numbers that begin with 91. We'll remove the prefix. Method 1 - Using the REPLACE Function to Remove Prefix ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo