How to Calculate Salary in Excel: A Step-by-Step Guide for Beginners

 

SEO Title: How to Calculate Salary in Excel: Step-by-Step Payroll Guide
Meta Description: Learn how to calculate salary in Excel using basic payroll formulas, earnings, deductions, net salary and practical Excel functions.

Microsoft Excel is widely used in HR and payroll operations for employee data management, salary calculations and payroll reporting.

Step 1: Create Your Payroll Sheet

Create columns such as:

• Employee ID

• Employee Name

• Basic Salary

• Allowances

• Incentives

• Overtime

• Gross Earnings

• Deductions

• Net Salary

Step 2: Calculate Total Earnings

If Basic Salary is in cell C2 and Allowances are in D2 and E2, a simple formula could be:

=SUM(C2:E2)

Additional approved earnings can also be included.

Step 3: Calculate Gross Salary

You can combine all applicable earnings using:

=SUM(C2:F2)

The exact cell references will depend on your payroll worksheet.

Step 4: Calculate Total Deductions

If deduction values are stored in separate columns:

=SUM(G2:J2)

Step 5: Calculate Net Salary

A simple formula is:

=Gross Salary - Total Deductions

For example:

=F2-K2

Useful Excel Functions for Payroll

SUM

Used to add earnings or deductions.

IF

Useful for conditional calculations.

Example:

=IF(C2>0,C2,0)

XLOOKUP

Useful for retrieving employee information or salary-related data from another table.

SUMIFS

Useful for conditional calculations involving multiple criteria.

ROUND

Useful for rounding calculated amounts according to organisational requirements.

Why Learn Excel for Payroll?

Excel skills can help HR and payroll professionals:

• Automate calculations

• Reduce manual work

• Create payroll registers

• Analyse salary data

• Prepare HR MIS

• Identify payroll variances

Learn Advanced Excel for HR at Palium Skills

Palium Skills combines practical payroll knowledge with Advanced Excel, helping learners develop job-relevant skills for HR and payroll roles.

Contact Palium Skills

South Kolkata: 1st Floor, Sheeba Bhavan, 1/22 Poddar Nagar, Near South City Mall, Kolkata – 700068

Salt Lake: 5th Floor, RDB Boulevard, Block GP, Salt Lake Electronic Complex, Kolkata – 700091

Call: +91 8420594969
WhatsApp: +91 9903130500
Email: info@paliumskills.com