Pelatihan Microsoft Excel Dasar untuk Meningkatkan Keterampilan Administrasi Guru dan Wali Santri
-
Baginda Oloan Lubis
*
Universitas Bina Sarana Informatika, Jakarta,
Indonesia
https://orcid.org/0000-0002-6839-9287
- Firstianty Wahyuhening Fibriany Universitas Bina Sarana Informatika, Jakarta, Indonesia
- Eri Riana Universitas Bina Sarana Informatika, Jakarta, Indonesia
- Santoso Setiawan Universitas Bina Sarana Informatika, Jakarta, Indonesia (*) Corresponding Author
Abstract
Administrative management and financial record-keeping in non-formal educational institutions such as Taman Pendidikan Al-Qur'an (TPQ) are still predominantly performed manually, resulting in various challenges, including difficulties in data retrieval, a high risk of data loss, low accuracy, and inefficient workflows. Similar issues were identified at TPQ Bina Ummah, where teachers and administrative staff had limited proficiency in using Microsoft Excel for administrative management and recording cash inflows and outflows. Consequently, data recapitulation was time-consuming and prone to calculation errors. This community service program aimed to improve the participants' competency in using Microsoft Excel to support more effective and accurate administrative management. The implementation method consisted of needs assessment, development of training modules, hands-on workshops, practical mentoring, and evaluation through pre-test and post-test assessments. The training focused on four core competencies: creating tables, using the SUM and AVERAGE functions, applying the Sort and Filter features, and configuring document print settings. The activity was conducted offline on May 9, 2026, and attended by 20 participants, consisting of teachers and administrative staff of TPQ Bina Ummah. The evaluation results showed that the average pre-test score increased from 45.5 to 82.0 in the post-test, representing an improvement of 36.5 points (approximately 80.2% compared with the initial score). Furthermore, 90% of the participants were able to independently prepare cash receipt and cash disbursement reports using Microsoft Excel based on the case studies provided. These findings indicate that the training successfully enhanced participants' competencies in administrative management while strengthening their digital literacy to support more professional, effective, and accountable administrative governance within the TPQ.
Downloads
References
Aziz, F. A., & Luayyin, R. H. (2025). Implementasi Pengelolaan Dana Infaq di TPQ Al-Hidayah Probolinggo. El-Mal: Jurnal Kajian Ekonomi & Bisnis Islam, 6(6), 1929–1945. https://doi.org/1047467/elmal.v6i6.7457
Badrul, M., Aziz, R. A., Dewi, Y. N., & Septiana, L. (2022). Pelatihan Microsoft Excel 2016 Untuk Menunjang Kegiatan Administrasi Bagi Staff Dan Guru TPQ Bina Ummah. TRIDHARMADIMAS: Jurnal Pengabdian Kepada Masyarakat Jayakarta, 2(1), 39–46. https://doi.org/10.52362/tridharmadimas.v2i1.835
Chudzaifah, I. (2021). Tridharma Perguruan Tinggi : Sinergitas Akademisi dan Masyarakat dalam Membangun Peradaban. AL-KHIDMAH: Jurnal Pengabdian Dan Pendampingan Masyarakat, 1(1), 79–91. https://doi.org/10.47945/al-khidmah.v1i1.384
Eprilianto, D. F., Megawati, S., Pradana, G. W., Sari, Y. E. K., Hibatulloh, M. H., Sari, L. A., Khoirudin, M. R., & Sheren, A. V. (2025). Digitalisasi Administrasi dan Penguatan Literasi Digital sebagai Katalisator Pelayanan Publik yang Inovatif dan Berkelanjutan di Desa Beluk Kenek Kabupaten Sumenep. Jurnal Pengabdian Masyarakat Indonesia, 4(3), 25–42. https://doi.org/10.55606/jpmi.v4i2.5813
Farhani, A. (2024). Aplikasi Komputer Bisnis Panduan Praktis Bagi Pengajar Dan Mahasiswa. Deepublish.
Fibriany, F. W., Lubis, B. O., Riana, E., & Utami, D. Y. (2024). Pelatihan Penggunaan Microsoft Excel Untuk Mengolah Data Di Himpaudi Cempaka Putih. In Communnity Development Journal (Vol. 5, Issue 6). https://doi.org/10.31004/cdj.v5i6.37564
Fibriany, W., Lubis, B. O., & Riana, E. (2025). Pelatihan Melindungi dan Mencetak Dokumen Microsoft Excel Di SPS Mawar Indah. In Jurnal Pengabdian Kepada Masyarakat Mandiri (JPMM) (Vol. 3, Issue 2). https://doi.org/10.55642/jpmm.v3i02
Hidayat, T., Handayani, Y., Novitaningrum, D., Aprilia, T., Waluyo, T. M., Setiawan, D., & Siroj, T. A. (2025). Peningkatan Kompetensi Digital Siswa melalui Pelatihan Pemrograman Web dan Pengolahan Data. Jurnal Pengabdian Kepada Masyarakat Indonesia (JPKMI), 5(2), 182–189. https://doi.org/10.55606/jpkmi.v5i2.7867
Jusriadi, Prasong, M., Pakro, P., Prasong, M. A., Galeko, M., Bain, S. N., & Lobang, I. (2026). Strategi Pengelolaan TPQ dalam Meningkatkan Kualitas Pendidikan Al-Qur’an di TPQ Al-Anzor Waluom Desa Wolwal Tengah. Menara Ilmu : Jurnal Penelitian Dan Kajian Ilmiah, 20(2), 452–462. https://doi.org/10.31869/mi.v20i2.7954
Karuniawan, H., Padli, S., & Rianis, B. (2024). Pelatihan Microsoft Office Excel Sebagai Upaya Peningkatan Kompetensi Siswa SMKN 1 Praya Tengah Dalam Mengolah Data. Bumi : Jurnal Hasil Kegiatan Sosialisasi Pengabdian Kepada Masyarakat, 2(3), 18–27. https://doi.org/10.61132/bumi.v2i3.149
Lubis, B. O., Fibriany, F. W., & Riana, E. (2023). Pelatihan Penggunaan dan Pemanfaatan Canva Untuk Pemasaran Secara Digital Bagi POKJA TKQ/TPQ Kecamatan Tanjung Priok. Community Development Journal: Jurnal Pengabdian Masyarakat, 4(2), 3388–3394. https://doi.org/10.31004/cdj.v4i2.15268
Lubis, B. O., Fibriany, F. W., Riana, E., & Utami, D. Y. (2024). Pelatihan Pembuatan Profil Organisasi Di Himpaudi Cempaka Putih. Jurnal Pengabdian Kolaborasi Dan Inovasi IPTEKS, 2(3), 789–796. https://doi.org/10.59407/jpki2.v2i3.783
Nababan, C. D., Asril, B. W., Samosir, H. S., Silaen, T. H., Siahaan, N. D. E., Siregar, G. D. A., Simarmata, R. A. T., & Sidabutar, A. E. (2026). Pelatihan Microsoft Excel Untuk Meningkatkan Kompetensi Pengolahan Data Akademik Guru Di Smp Negeri 1 Satu Atap Tampahan. Jurnal Abdimas Ilmiah Citra Bakti, 7(1), 250–261. https://doi.org/10.38048/jailcb.v7i1.6390
Permatasari, P., Wahyuningsih, S., & Ekawanti, W. (2024). Pemanfaatan Ms. Excel Dalam Laporan Keuangan : Upaya Peningkatan Pengelolaan Usaha Toko Sembako Limus Tangerang. Jurnal Pengabdian Masyarakat: Ekonomi Dan Bisnis Digital (JPMEBD), 1(4), 378–382. https://doi.org/10.70248/jpmebd.v1i4.1676
Radjak, D. A., Ra’is, D. U., & Rohman, A. (2024). Pembangunan Masyarakat Desa. Forind.
Rahmah, I. S., & Mubarak, L. A. (2025). Transformasi Digital dalam Manajemen Pendidikan Nonformal di Taman Pendidikan Al-Qur ’ an (TPQ) Al Manar. Socius: Jurnal Penelitian Ilmu-Ilmu Sosial, 2(12), 877–883. https://doi.org/10.5281/zenodo.16358688
Ramadhani, M. W., Akib, A., Utami, D., Utami, S., & Majiding, N. C. (2025). Pelatihan Aplikasi Akuntansi (Ms. Excel) untuk Meningkatkan Keterampilan Akuntansi Mahasiswa Pendidikan Akuntansi UNM dalam Manajemen Laporan Keuangan. PEDATI Jurnal Pengabdian Perguruan Tinggi, 3(2), 67–75. https://doi.org/10.26623/jp.v3i2.13079
Saputra, I. F., Taufik, G., Lubis, B. O., Arifitama, B., Santoso, B., Rahayu, Y. S., Ariyati, I., Prihatin, T., Riyanto, V., & Yudhistira. (2026). Ilmu Komputer Dasar: Konsep, Teknologi, dan Aplikasi. PT Bukuloka Literasi Bangsa.
Sari, S., & Firmansyah. (2025). Penguatan Administrasi dalam Lembaga Pendidikan Islam Luar Sekolah. Edulead : Journal of Education Management, 7(2), 136–147. https://doi.org/10.47453/edulead.v7i2.3599
Supriadi, D., Elfiyanti, N., Saleh, S. G., Allo, R. P., Pradita, A., Astriani, Y., Wirda, Ririn, Padalla, I., Hardianto, & Nisraeni. (2025). Pemberdayaan Masyarakat Melalui Pelatihan Microsoft Office untuk Meningkatkan Kinerja Perangkat Desa Poreang. Madaniya, 6(1), 547–552. https://doi.org/10.53696/27214834.1169
Wahyuhening Fibriany, F., Lubis, B. O., & Eriana, E. (2023). Pelatihan Komputer Microsoft Word 2016 Untuk Guru dan Orang Tua Murid Satuan PAUD Sejenis Negeri Bale Bermain Cempaka Putih. Jurnal Pengabdian Multidisiplin, 3(3), 1–8. https://doi.org/10.51214/00202303701000
Bila bermanfaat silahkan share artikel ini
Berikan Komentar Anda terhadap artikel Pelatihan Microsoft Excel Dasar untuk Meningkatkan Keterampilan Administrasi Guru dan Wali Santri
Pages: 84-92
Copyright (c) 2026 Baginda Oloan Lubis, Firstianty Wahyuhening Fibriany, Eri Riana, Santoso Setiawan
This work is licensed under a Creative Commons Attribution 4.0 International License.
Authors who publish with this journal agree to the following terms:
- Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under Creative Commons Attribution 4.0 International License that allows others to share the work with an acknowledgment of the work's authorship and initial publication in this journal.
- Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgment of its initial publication in this journal.
- Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work (Refer to The Effect of Open Access).
