Objective

Build an employee payroll and attendance management system.

Worksheets

  1. Employee_Master
  2. Attendance
  3. Salary
  4. Payroll_Summary
  5. HR_Dashboard

Data Fields

  • Employee ID
  • Employee Name
  • Department
  • Basic Salary
  • Working Days
  • Present Days
  • Leave Days
  • Overtime
  • Allowances
  • Deductions
  • Net Salary

Formula Examples

Attendance %

=Present_Days/Working_Days*100

Overtime Amount

=Overtime_Hours*Overtime_Rate

Net Salary

=Basic_Salary+Allowances+Overtime-Deductions

Practice

Create department-wise salary analysis and an HR dashboard.

PreviousNext