Excel Formulas

How to Calculate Overtime Percentage in Excel (3 Methods)

Calculating overtime percentage means finding out how many extra hours of work are done by a person after the regular work shift is over. To ensures ...

How to Calculate Accrued Vacation Time in Excel (with Easy Steps)

What Is Accrued Vacation Time? Generally, employees get a certain amount of days to leave for vacation, personal reasons, or sickness. But if the ...

Daily Wages Sheet Format in Excel (with Quick Steps)

We frequently need to calculate the wages of the employees on a yearly, monthly, and daily basis. To make a sheet format to compute daily wages, ...

Make Attendance Sheet with Salary Format in Excel: 6 Steps

Consider the following information about some employees of an organization. In the dataset, columns C, D, and E contain the data for Employee ID, ...

How to Calculate Overtime Hours in Excel Using IF Function

Excel is a useful tool to perform any type of calculation. Therefore, users try to calculate overtime hours in Excel using the IF function. The IF ...

How to Make Salary Sheet in Excel with Formula (with Detailed Steps)

A salary sheet is a very handy tool regarding the distribution of salaries among the employees of a company. There are many allowances and deductions ...

Per Day Salary Calculation Formula in Excel (2 Suitable Examples)

If you are looking for per day salary calculation formula in Excel, this article is for you. Here, we will walk you through 2 easy and suitable ...

How to Mail Merge from Excel to Outlook (with Easy Steps)

Mail Merge is a fantastic way to send an email to a large number of people with one click. It is used mostly to send personalized mail to the users ...

How to Calculate HRA on Basic Salary in Excel – 3 Quick Methods

The following dataset contains the salary slip of an employee. B12:C17 showcases the income sources and the total salary for May. Method 1 ...

How to Calculate DA on Basic Salary in Excel (3 Easy Ways)

Sometimes you may need to Calculate Dearness Allowance (DA) on Basic Salary in Excel. In this article, I’m going to explain to you three methods of ...

How to Use Custom Date Filter in Excel (5 Easy Ways)

In this article, we will learn to use a custom date filter in Excel. Using a custom date filter one can filter a data series from a date to another ...

How to Calculate Basic Salary in Excel (3 Common Cases)

If you run an institution or work for a company, then you may need to calculate the basic salary of the employees of the institution. In this ...

How to Use Grouping and Consolidation Tools in Excel?

This article shows you how to use grouping and consolidation tools in Excel. The Excel grouping tool groups two or more rows or columns. The user can ...

How to Use Consolidate Function for Text Data in Excel?

While working on multiple worksheets, you may want to consolidate text data with the Excel function. So you can combine text data from multiple ...

How to Remove Consolidation in Excel (2 Handy Methods)

Consolidation, merging, or combining data in a cell from different rows and columns is a common phenomenon. But, the hard part is to remove this ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo