Excel Formulas

How to Create a Monthly Salary Sheet Format in Excel

Here's the dataset we'll build on. We have some employees and their basic salary. We will calculate their net salary and deductions. Step ...

How to Calculate Discount in Excel (2 Easy Methods)

Discount is a term used in a pricing system that merges with the selling price to boost sales. This discount calculation system is used worldwide in ...

How to Create Salary Slip Format with Formula in Excel Sheet

Let’s assume we have a large worksheet that contains the information about several Employee salary statements. The data for the Employee name, the ...

Excel Calculate Hours Between Two Times After Midnight (3 Methods)

Calculating time is usually seen for hourly wages-based workers. It may be seen that working is long, maybe work finishes after midnight. In that ...

How to Calculate Area of Irregular Shape in Excel (3 Easy Methods)

We perform numerous mathematical operations in MS Excel. There are many different built-in functions and features that help us to perform various ...

How to Calculate 10 Percent Discount in Excel (With Easy Steps)

Discount Calculation is one of the formulas that frequently utilize Excel. Excel makes it simpler and quicker to perform the calculations related to ...

How to Calculate Sales Growth over 3 Years in Excel (2 Methods)

Measuring sales growth is one of the key points to measuring the overall company growth. Because more sales mean more potential for higher profit. ...

How to Use Nested IF Function in Excel (7 Examples)

When a function is inserted inside another function, then it is called a nested function. In this article, we will learn how to use the nested IF ...

How to Calculate Log Base 2 in Excel (2 Methods)

  Method 1 - Use Excel LOG Function The LOG function computes the logarithm of a number to a particular base. In order to use the LOG ...

How to Remove Asterisk in Excel (5 Simple Methods)

While working in Microsoft Excel, you might see some not useful asterisk(*) in different cells. This may create problems while editing a dataset or ...

How to Calculate Bonus Percentage in Excel (Step-by-Step Guide)

Every office deals with bonuses on salary for various festivals and occasions. This bonus varies from employee to employee. It depends on employee ...

How to Calculate Production Cost in Excel (3 Effective Ways)

The phrase production cost is used in management accounting. And use to describe the total cost of manufacturing items or providing services. It ...

Bonus Calculation as per Bonus Act in Excel (3 Suitable Examples)

When you maintain a company, you have to give some bonus to your employees to make them more dedicated to your company. It is a trendy policy in ...

How to Calculate Cut and Fill Volume in Excel (3 Steps)

Step 1: Formatting Data in Excel to Calculate Cut and Fill Volume To make the data more understandable, we’ll format it appropriately. Assume ...

How to Filter Last 30 Days of Date in Excel (5 Easy Ways)

Typical Excel worksheets contain hundreds of rows with dates, amounts, etc. as entries. As a result, finding entries within a specific time period ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo