Training on the use of Microsoft Excel in Data Recapitulation at Community Hall 03, Paseban Village, Senen District, Central Jakarta Province

Authors

  • Malik Hidayat Sekolah Tinggi Ilmu Ekonomi Y.A.I Jakarta
  • Nursiti Sekolah Tinggi Ilmu Ekonomi YAI
  • Henni Handari Sekolah Tinggi Ilmu Ekonomi YAI

DOI:

https://doi.org/10.37010/kangmas.v4i2.1188

Keywords:

data, ms. excel, recapitulation, citizen

Abstract

The purpose of implementing this community service is to increase the knowledge and skills of RW residents. 03 Paseban Village, Senen District, Central Jakarta uses Microsoft Excel to recapitulate data or collect data on residents. The implementation of this activity is carried out in three stages, namely preparation, implementation, and evaluation. The implementation phase begins with the basics of using Microsoft Excel. In the preparatory stage, the community service team was surveyed to find out the conditions and analyze the place to be used. Furthermore, the team prepared material that would be provided in providing training to community service participants. This service activity includes presentations, lectures with questions and answers, and practice. When delivering the material, the community service team conducted a question and answer session with the participants who were expected to be able to interact with the servants and participants. The last stage is the evaluation stage. Community service training with the theme of training on using Microsoft Excel in recapitulating citizen data to improve skills in using technology in the form of computers was successfully carried out. Based on the results of the feedback obtained, information that this activity is very relevant to the needs of the participants. They feel they are gaining useful insights and skills. Residents of RW 03 Paseban Village feel very happy and helped by the training provided, they feel that they have insight into the use of Ms. Excel will later make it easy for them to collect citizen data/recapitulation if it is to be used. This will also minimize the use of paper for storing citizen data which may be at risk of loss or damage.

Downloads

Download data is not yet available.

References

David, D. (2019). Peningkatan Keterampilan Penggunaan Macro VBA. Seminar Nasional Pengabdian Pada Masyarakat 2019, 29–37.

Fadhillah, Y., Aswan, N., Siregar, M. N. H., & Hasibuan, F. A. (2021). Peningkatan Kemampuan dan Keterampilan Penggunaan Microsoft Excel Dalam Pembelajaran Matematika Pada Siswa YPKS Padangsidimpuan. Jurnal Pengabdian Kepada Masyarakat Radisi, 1(3).

Hermawati, F. A., & Armin, A. P. (2021). Pemanfaatan Microsoft Excel untuk Aplikasi Data Pelanggan pada Pada Usaha Jasa Pembersihan Dan Perawatan Sepatu, Tas, Dan Topi. Dinamisia?: Jurnal Pengabdian Kepada Masyarakat, 5(4). https://doi.org/10.31849/dinamisia.v5i4.664 2.

https://doi.org/10.25157/teorema.v4i1.1723 Setyowati, D. (2019). Pelatihan Membuat Grafik dalam Microdoft Excel untuk Pengolahan dan Penyajian Data. Jurnal Dharma Bakti- LPPM IST AKPRIND Yogyakarta, 2(2), 101–112.

Julaeha, S., & Somawati, S. (2019). Sosialisasi Pengoperasian Microsoft Excel untuk Administrasi Data Matematis pada Karang Taruna. Jurnal PkM Pengabdian kepada Masyarakat, 2(03), 280.

Ningsih, S., & Dewi, M. W. (2020). Peningkatan Sumber Daya Manusia Melalui Pelatihan Komputer Microsoft Excel Bagi Perangkat Desa Wirogunan. 02(02), 7.

Patmawati, H., & Santika, S. (2016). Penggunaan Software Microsoft Excel sebagai Alternatif Pengolahan Data Statistika Penelitian Mahasiswa Tingkat Akhir. Seminar Nasional Matematika X Universitas Negeri Semarang 2016, 124–129.

Putri, A. R. (2015). Optimalisasi Penggunaan Microsoft Excel untuk Pengolahan Nilai Raport di SMAN 1 Ngunut Tulungagung. J- ADIMAS (Jurnal Pengabdian kepada Masyarakat), 3(1), 1–5.

Rizaldi, R. (2019). Pelatihan Pengolahan Data Administrasi Perkantoran Menggunakan Aplikasi Microsoft Excel pada Balai Desa Pinanggripan Kecamatan Air Batu Kabupaten Asahan. Jurdimas (Jurnal Pengabdian Kepada Masyarakat) Royal, 2(2), 107–114.

Santika, S., Nugraha, D. A., & Solihat, A. N. (2019). Efektivitas Penggunaan Lembar Kerja Berbasis Masalah dengan Bantuan Microsoft Excel pada Mata Kuliah Program Komputer. TEOREMA?: Teori dan Riset Matematika, 4(1),23.

Shohabatussa’adah, S., & Muasomah, M. (2021). Pemanfaatan Microsoft Excel dalam Membantu Penyusunan Laporan Keuangan di TPQ An-Najah Tirto Pekalongan. Al- Khidmat: Jurnal Pengabdian Kepada Masyarakat,

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.13.

Published

2023-07-14

How to Cite

Hidayat, M., Nursiti, N., & Handari, H. (2023). Training on the use of Microsoft Excel in Data Recapitulation at Community Hall 03, Paseban Village, Senen District, Central Jakarta Province. KANGMAS: Karya Ilmiah Pengabdian Masyarakat, 4(2), 51–55. https://doi.org/10.37010/kangmas.v4i2.1188
Abstract viewed = 94 times