ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
PROJECT 4: Payroll Management System
2
3
Tools:
4
Google Sheets
5
Skills Used:
6
XLOOKUP, IF, AVERAGE, conditional formatting
7
8
Description:
9
10
Built a payroll system to calculate monthly salaries.
11
12
Used lookup functions to retrieve employee details.
13
14
Applied logic to flag attendance status.
15
16
Generated payroll summaries including total cost and average salary.
17
18
Key Outcome:
19
20
Improved payroll accuracy and attendance monitoring.
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100