Excel Formulas

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

If you want to represent the values that match certain criteria in a cell then this article will be helpful for you. The main objective of this ...

How to Use Food Cost Percentage Formula in Excel

In our daily lives, we often need to calculate food cost percentages in Excel. Especially when there are a lot of sales going on in the restaurants, ...

How to Sum Absolute Value in Excel (6 Suitable Ways)

The absolute value is used to present the difference between two entities. After calculation, the resultant difference may be positive or negative. ...

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

The word salary is derived from the Latin letter "salarium," which was granted to Roman troops in the past in addition to their rightful pay. The ...

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 Use the Format Cells ...

How to Do Price Volume Variance Analysis in Excel

The analysis of the price and volume changes is a critical component in business. It allows businessmen to analyze the current year's sales based on ...

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

In Microsoft Excel, it is easy to convert the currency to a number. For different types of purposes, you may need to convert your stored currencies ...

Formula to Copy and Paste Values in Excel Automatically

We find numerous values, formulas, and calculations when working with Excel. Sometimes, we need to copy and paste only the values. This will be more ...

How to Create Salary Breakup Calculator in Excel

Salary Breakup is a very powerful way to show the how the CTC (cost-to-company) on an employee is distributed in different fields. It breaks down the ...

How to Convert Date to Quarter and Year in Excel

While working on an Excel worksheet, you need to handle different kinds of procedures. One of them is to convert date to quarter and year in Excel. ...

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

Microsoft Excel is a wonderful tool that can help us not only with small spreadsheet stuff but also, with formulas, can automate too many processes ...

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 the COLUMN function, the CODE function, and ...

How to Calculate Contribution Percentage with Formula in Excel

We have values from different sources listed for certain periods. This listing indicates the contributions of each period of items over the period of ...

Combine CONCATENATE & TRANSPOSE Functions in Excel

Looking for ways to use CONCATENATE & TRANSPOSE functions together in Excel? Then, this is the right place for you. We usually use these two ...

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

An unix timestamp indicates how much time has passed since January 1, 1970 (epoch time). When the timestamp has 11 digits, it displays seconds; when ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo