Excel Formulas

How to Concatenate If Cell Values Match in Excel (7 Easy Ways)

To demonstrate our methods we'll use the following dataset, containing columns for State and Sales Person. We'll concatenate the values in the Sales ...

How to Use Food Cost Percentage Formula in Excel: 3 Methods

Method 1 - Calculating Total Food Cost Percentage Formula for Cost per Meal   Steps: Select cell C8. Write the following formula into the ...

How to Sum Absolute Value in Excel: 6 Easy Ways

We will consider a simple dataset that contains both negative and positive numbers. Method 1 - Use the ABS Function Inside the SUM ...

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

Here is our sample data set with salary components and their respective values. Step 1. Calculating Gross Salary Select cell C13. ...

How to Extract Month and Day from a Date in Excel – 6 Methods

This dataset showcases Students and their Date of Birth.   Method 1 - Using the Format Cells Option Steps: Select the entire ...

How to Do Price Volume Variance Analysis in Excel

  Step 1 - Calculating Total Quantities Sold Select the C11 cell and use the following formula: =SUM(C5:C10) Hit Enter. ...

How to Convert Currency to a Number in Excel (6 Easy Ways)

We'll use a single column with some values in the Currency format. Method 1 - Using the Number Format to Convert Currency to Numbers ...

Formula to Copy and Paste Values in Excel Automatically

In this article, we will demonstrate 2 ways to create a formula to copy and paste values in Excel automatically. We'll use the following dataset of 4 ...

How to Create Salary Breakup Calculator in Excel: 12 Methods

Method 1 - Calculating Basic Salary Select the B15 cell and write down the following formula, =VLOOKUP(B7,Structure!$B$5:$D$8,3,0)/D7*E7 ...

How to Convert a Date to a Quarter and Year in Excel (3 Methods)

Dataset Overview We'll use a dataset called the Product arrival Date of ABC Shop to demonstrate these methods. This dataset consists of two columns ...

How to Concatenate Cells with If Condition in Excel (5 Examples)

  Method 1 - Concatenate with Ampersand and IF Condition We can see some blank cells in the “middle name” column. In the fourth column, we ...

How to Convert Alphabet to Number in Excel – 4 Easy Methods

This is the sample dataset. Method 1 - Converting Single Alphabet letters to Numbers in Excel 1.1 Using the COLUMN Function STEPS: ...

How to Calculate Contribution Percentage with Formula in Excel

    Method 1 - Calculate the Contribution Percentage Based on Age Bands with the SUM Function In the dataset below, we will ...

Combine CONCATENATE & TRANSPOSE Functions in Excel

Introduction to the CONCATENATE Function Syntax: =CONCATENATE(text1,,...) Argument: text1– the first text, number, or array you ...

How to Convert 13 Digit Timestamp to Date Time in Excel (3 Methods)

Dataset Overview A Unix timestamp indicates the amount of time that has passed since January 1, 1970 (epoch time). When the timestamp has 11 digits, ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo