PELS (Procedia of Engineering and Life Science)
Vol 1 No 2 (2021): Proceedings of the 2nd Seminar Nasional Sains 2021

Personnel Information System Using Microsoft Excel (Case Study: Bima City Health Office)

Wulan Ramdhani (Universitas ‘Aisyiyah Yogyakarta, Indonesia)
Arizona Firdonsyah (Universitas ‘Aisyiyah Yogyakarta, Indonesia)



Article Info

Publish Date
14 Jul 2021

Abstract

Information system is a system that has the ability to collect information from all sources and use various media to display information. Microsoft Excel is a spreasheet application program (electronic worksheet), the function of Microsoft Excel is to perform calculation operations and can present data in table form, while the filter and sort data functions are used to sort or filter data, for example: the ascending function and descending to sort data from the largest or from the smallest, the Sort By and Sort On features, in addition to the filter function to display data with certain criteria, the filter feature function or often referred to as autofilter, which functions to display certain rows of data according to filters already applied and hides the rest of the remaining rows of data. This study aims to facilitate the search for staffing data at the Health Office of the City of Bima, the method of data collection using 2 methods, namely literature study and observation, the results of research that have been conducted are that there is no personnel information system because the process of searching and recording personnel data is still done manually.

Copyrights © 2021






Journal Info

Abbrev

PELS

Publisher

Subject

Computer Science & IT Control & Systems Engineering Electrical & Electronics Engineering Engineering

Description

PELS (Procedia of Engineering and Life Science) is an international journal published by Faculty of Science and Technology Universitas Muhammadiyah Sidoarjo. The research article submitted to this online journal will be double blind peer-reviewed (Both reviewer and author remain anonymous to each ...