EmployeeData Sheet
Employee Monthly Date
Name Department Gender Job Title Score
ID Salary Joined
2018-04-
E001 Alice Otieno HR F HR Officer 75,000 88
10
Brian Software 2019-08-
E002 IT M 120,000 92
Kimani Engineer 23
2020-01-
E003 Carol Njoki Finance F Accountant 98,000 79
15
Daniel 2017-06-
E004 Marketing M Marketer 65,000 63
Mwangi 30
2016-11-
E005 Eva Achieng IT F Data Analyst 110,000 95
05
2021-02-
E006 Fred Otieno Finance M Auditor 85,000 72
28
Grace 2022-07-
E007 HR F Recruiter 70,000 58
Wanjiru 19
Hassan 2015-09-
E008 Marketing M Sales Rep 60,000 61
Yusuf 12
You can also create a second sheet named DepartmentManagers like this:
Department Manager Name
HR Jane Muthoni
IT Samuel Ochieng
Finance Lydia Njeri
Marketing Peter Omondi