OPTIMALISASI KETERAMPILAN MICROSOFT EXCEL BAGI SANTRI PONDOK PESANTREN TAHFIZH AL-QURAN DAARUL HIKMAH CIPUTAT TANGERANG SELATAN MELALUI PELATIHAN LANJUTAN
Abstract
The ability to use data processing software such as Microsoft Excel is an important skill that all students should acquire—including those studying in Islamic boarding schools (pesantren). However, limited access to technology training in many pesantren has led to a situation where most santri only understand the basic functions of Microsoft Excel. This community service program was designed to improve the santri's advanced Excel skills at Pondok Pesantren Tahfizh Al-Qur’an Daarul Hikmah in Ciputat, South Tangerang. The focus was on supporting administrative data management within the pesantren. The training method combined interactive lectures, live demonstrations, and hands-on practice with advanced Excel formulas such as IF, VLOOKUP, COUNTIF, and SUMIF, as well as the use of data visualization tools. To evaluate learning outcomes, we used questionnaires and direct observation to assess participants’ understanding and practical skills. The results showed a significant improvement in participants’ ability to use advanced Excel features effectively. They also demonstrated increased confidence and efficiency in managing administrative data. Notably, the number of participants exceeded expectations, with strong engagement throughout the sessions. Beyond skill development, the training raised awareness among santri about the importance of mastering digital tools as a critical asset for their future careers. In conclusion, the program proved to be an effective model for technology-based empowerment in pesantren settings. It is hoped that this initiative will continue in the future to reach a wider and more lasting impact.
References
Adri, D., & Ramadhan, L. O. M. (2021). Aplikasi Microsoft Excel dalam Pembelajaran Matematika Materi Bangun Ruang. Edukatif : Jurnal Ilmu Pendidikan, 3(5), 3376–3384. https://doi.org/10.31004/edukatif.v3i5.922
Hendrian, S., & Hapsari, A. T. (2023). Penerapan Fungsi Rumus Pada Microsoft Excel Bagi Guru-Guru di SD Negeri Sukapura 02 Kabupaten Bandung. Jurnal Pengabdian Harapan Bangsa, 1(3), 161–164. https://doi.org/10.56854/jphb.v1i3.139
Idayat, R., Insani, M. R. P., Nurhayati, Ishak, A., Satofona, N., Multazam, Rahman, M. F., Yuda, Saputra, D. E., Ananda, R. P., & Bahri, D. S. (2021). Pemanfaatan Penggunaan Microsoft Excel Secara Efektif Terhadap Pembelajaran Siswa-Siswi SMP Muhammadiyah 44 Pamulang. JATIMIKA: Jurnal Kreativitas Mahasiswa Informatika, 2(2), 331–336. http://openjournal.unpam.ac.id/index.php/JATIMIKA/article/view/15996
Novita, D., Sihotang, F. P., & Khairani, S. (2023). Pelatihan Penggunaan Microsoft Excel Untuk Mengolah Data Bagi Siswa/i SMK Bina Cipta Palembang. Fordicate, 2(2), 109– 118. https://doi.org/10.35957/fordicate.v2i2.4759
PasarTrainer.com. (2024). Microsoft Excel: Definisi, Fungsi, dan Rumus Penting. https://pasartrainer.com/blog/microsoft-excel-definisi-fungsi-dan-rumus-penting
Pengertian Microsoft Excel beserta Fungsinya. (n.d.). https://kumparan.com/berita- update/pengertian-microsoft-excel-beserta-fungsinya-21eXO7sAdTq/1
Petro, S., & Swatan, K. H. (2019). Pelatihan Microsoft Excel Sebagai Penunjang Ketrampilan Hard Skill Bagi Siswa Pada Smk Ypsei Palangka Raya. Jurnal Abdimas BSI: Jurnal Pengabdian Kepada Masyarakat, 2(2), 280–286. https://doi.org/10.31294/jabdimas.v2i2.6011
Rizaldi, Anggraeni, D., Dorthy, H., Sinaga, E., Informasi, S., Royal, U., Tinggi, S., Ekonomi, I., & Prasetya, E. (2024). Merancang Tabel Dan Pengetahuan Rumus Dasar Microsoft Excel Bagi Pemula. Juli, 2, 116–120.
Sari, N. P., Yusrizal, & Khaldun, I. (2015). Efektifitas Media Interaktif Berbasis Microsoft Excel Terhadap Peningkatan Keterampilan Proses Sains Pada Konsep Kelarutan Dan Hasil Kali Kelarutan. Jurnal Pendidikan Sains Indonesia, 03(02), 56–65.
