Optimizing the Use of Microsoft Excel for Employees' Administrative Tasks at Le Premier Hotel Kota Deltamas, Cikarang

Authors

  • Weli Weli Universitas Katolik Indonesia Atma Jaya
  • Rilo Pambudi Universitas Katolik Indonesia Atma Jaya
  • Esther Meilia Universitas Katolik Indonesia Atma Jaya
  • Daniel Joshua Universitas Katolik Indonesia Atma Jaya

DOI:

https://doi.org/10.25170/mitra.v5i1.1347

Keywords:

tutorial; microsoft excel; reporting; employee

Abstract

This community service activity was motivated by the needs of the employees at Le Premier Hotel, Kota Deltamas, Cikarang. They are mostly unfamiliar with Microsoft Excel and do not use it for data processing and completing their daily tasks. Microsoft Excel is an automated data processing application that can be used for various administrative purposes, from simple to complex ones. Forty employees of Le Premier Hotel participated in this program. Preliminary analysis results show that only a few employees can use Microsoft Excel while the ability to use this application is needed as the work volumes and the timeline for finishing the increase of the work. This activity aims to train the employees at Le Premier Hotel Kota Deltamas, Cikarang on how to use Microsoft Excel in completing their daily tasks. With this, it is hoped that they could complete their work more quickly and more accurately which will improve their work performance and skill. The method adopted in implementing this community service program is tutoring and hands-on training of Microsoft Excel using a computer or a laptop. The results are positive, i.e. adding knowledge and skills of how to use some basic operations for report preparation needs. The activities ran smoothly as scheduled. In addition, the activity was easily and comfortably held because all the participants had a laptop provided by the Le Premier Hotel Kota Deltamas, Cikarang. The participants claimed that this community service program has benefited them, and expected to get more advanced training to improve their capabilities in using Microsoft Excel and to facilitate them in completing their tasks.

References

Achadiyah, B. N. (2019). Otomatisasi pencatatan akuntansi pada UMKM. Jurnal Akuntansi Multiparadigma, 10(1). https://doi.org/10.18202/jamal.2019.04.10011.

Hanif, A. (2019). Sistem informasi sederhana menggunakan spreadsheet dan macro untuk usaha mikro informal. Seminar Nasional Teknologi Komputer & Sains (SAINTEKS), 1(1), 851–855. https://www.prosiding.seminarid.com/index.php/sainteks/article/view/241.

Harto, B., Saidah, L., & Rukmanda, M. R. (2020). Pelatihan pembuatan business plan menggunakan aplikasi excel bagi UMKM Juara Kota Bandung. Jurnal Kuat: Keuangan Umum dan Akuntansi Terapan, 2(1), 18–22.

Hidayatulloh, A., Ainy, R. N., & Nafiati, L. (2019). Peningkatan akuntabilitas keuangan kelompok UMKM ‘ Aisyiah Bantul melalui pelatihan pembukuan dan perpajakan. Seminar Nasional Hasil Pengabdian kepada Masyarakat, 23, 681–686.

Https://support.microsoft.com/id-id/office/rumus-dan-fungsi-294d9486-b332-48ed-b489-abe7d0f9eda9?ui=id-ID&rs=id-ID&ad=ID.

Ilsan, M., Salim, M., & Husain, T. K. (2020). Pelatihan teknik menyusun laporan keuangan untuk UMKM agribisnis. JIPEMAS: Jurnal Inovasi Hasil Pengabdian Masyarakat, 3(2), 102. https://doi.org/10.33474/jipemas.v3i2.5993.

Musa, I., & Maninggarjati, R. (2020). Rancangan sistem informasi penjualan pada river side store Samarinda menggunakan macro Microsoft Excel (Designing sales information system at riverside store Samarinda). PROSIDING SNITT Politeknik Negeri Balikpapan, 4, 341–350.

Novita, S. M., & Wulanditya, P. (2020). Desain Microsoft Excel for accounting bagi UMKM (Studi kasus pada LS Farm Mojokerto). Jurnal Riset Terapan Akuntansi, 4(2), 192–205.

Pamungkas, B., & Triandi, T. (2007). Telaahan penerapan sistem informasi akuntansi berbasis komputer akuntansi (menggunakan Microsoft Excel) dalam penyajian laporan keuangan (Studi Kasus pada Rumah Sakit Islam Bogor). Jurnal Ilmiah Kesatuan, 9(2), 94–97. https://doi.org/10.33062/jib.v6i02.221.

Weli, W., & Widjaya,J. (2016). Analisis penerimaan spreadsheet method untuk penyusunan laporan keuangan oleh mahasiswa (Studi kasus pada Mahasiswa Akuntansi FEB Unika Atma Jaya Jakarta). Jurnal Manajemen dan Bisnis Sriwijaya, 14(2), 183–194. https://doi.org/10.1017/CBO9781107415324.004.

Wibawa, B. M., Baihaqi, I., Hanoum, S., Ardiantono, D. S., Kunaifi, A., Persada, S. F., Sinansari, P., & Nareswari, N. (2019). Model pelatihan dan pendampingan penyusunan laporan keuangan berbasis cloud bagi pelaku UMKM. Sewagati, 3(3), 51–56. https://doi.org/10.12962/j26139960.v3i3.5962.

Published

2021-05-26

How to Cite

Weli, W., Pambudi, R., Meilia, E., & Joshua, D. (2021). Optimizing the Use of Microsoft Excel for Employees’ Administrative Tasks at Le Premier Hotel Kota Deltamas, Cikarang. MITRA: Jurnal Pemberdayaan Masyarakat, 5(1), 17–29. https://doi.org/10.25170/mitra.v5i1.1347
Abstract views: 371 | PDF downloads: 493