PELATIHAN PENGGUNAAN APLIKASI MICROSOFT EXCEL UNTUK PEMBELAJARAN PERSAMAAN AKUNTANSI

Suwandi Suwandi, Turini Turini, Safitri Akbari, Gytha Nurhana Dhea Praadha Gitama, Ika Kartika

Abstract


Accounting learning at the secondary school level often faces obstacles in conveying basic concepts, especially in understanding the accounting equation. Students often experience difficulties in recording and processing financial transactions systematically due to the limitations of manual learning methods. To overcome this problem, Lecturers at Catur Insan Cendekia University (UCIC) Cirebon held Community Service activities in the form of training on the use of the Microsoft Excel application as a tool in learning accounting equations at Putera Nirmala High School - Cirebon City. This activity aims to improve students' understanding and skills in utilizing Microsoft Excel to compile and analyze financial transactions more effectively and efficiently. The implementation method uses a service learning (SL) approach, which includes material presentation, demonstration of relevant Excel features, and hands-on practice with accounting equation case studies. The results of the activity showed a significant increase in participants' ability to apply Microsoft Excel to prepare simple financial reports. With this training, it is hoped that accounting learning in high school can be more interactive, innovative and in line with developments in digital technology.


Full Text:

PDF

References


Ambarwati, M. F. L., & Adianti, D. (2022). Efisiensi dalam Pengelolaan Dokumen Berbasis Digital. Jurnal Administrasi Dan Kesekretarisan, 7(1), 95–109.

Astuti, E., Yunita, P., Tambunan, F., Wahyuni, F. S., & Setiyawati, R. I. (2023). Pelatihan Pengenalan Dan Penerapan Aplikasi Komputer Microsoft Excel Pada Smu Swasta Dharmawangsa Medan. Abdikan: Jurnal Pengabdian Masyarakat Bidang Sains Dan Teknologi, 2(1), 50–57.

Bukidz, D. P. (2022). Penerapan service learning dengan metode hybrid untuk mengembangkan motivasi kegiatan pembelajaran. Jurnal Sinergitas PKM & CSR, 6(3), 1–7.

Erislan, E. (2022). Excel Application Training To Improve Msme Financial Governance In Bandung District. ICCD, 4(1), 158–163.

Fitri, A. S., Wati, S. F. A., & Safitri, E. M. (2023). Improving Administrative Skills of Foster Children at Panti Asuhan Muhammadiyah Surabaya through Learning Microsoft Excel. Nusantara Science and Technology Proceedings, 289–291.

Fitriana, E. (2019). Pengembangan E-Modul Berbasis Aplikasi Android Materi Persamaan Dasar Akuntansi Mata Pelajaran Akuntansi Dasar Kelas X Akuntansi di SMK PGRI 1 Tulungagung. Jurnal Mahasiswa Teknologi Pendidikan, 9(2).

Hasan, M. S. (2021). Learning Model Service-Learning at Boarding School. Nazhruna: Jurnal Pendidikan Islam, 4(3), 804–821.

Hendaryan, R., Hidayat, T., & Herliani, S. (2022). Pelaksanaan literasi digital dalam meningkatkan kemampuan literasi siswa. Literasi: Jurnal Bahasa Dan Sastra Indonesia Serta Pembelajarannya, 6(1), 142–151.

Hikmah, R., Astuti, L. S., & Wulandari, S. (2022). Penggunaan Microsoft Excell Dalam Membuat Laporan Keuangan. Jurnal PkM (Pengabdian Kepada Masyarakat), 5(5), 494–501.

Indriyani, N. M. V., Sumartini, A. R. S. A. R., Putra, I. W. G. Y. D., & Putra, I. W. G. Y. D. (2024). Community Service “Guidance on Governance and Accounting Recording using Ms. Excel in The Si Kunyit Jamu Business Group in Denpasar.” MOVE: Journal of Community Service and Engagement, 4(2), 57–61.

Jaman, A., Suarni, A., & Sahib, M. K. (2023). Training and Assistance in Financial Administration Report Preparation Using Microsoft Excel. Indonesian Journal of Cultural and Community Development, 14(2).

Jensen, G. R. (2023). International public sector accounting standards (IPSAS). In Global encyclopedia of public administration, public policy, and governance (pp. 6968–6976). Springer.

Kraievskyi, V., Kolisnyk, O., & Skoryk, M. (2024). Digitalisation of the accounting and analytical support service for small businesses. Економіка Розвитку Систем, 6(2), 36–41.

Martodiryo, S., Rizky, M., & Hadi, R. (2023). Analysis of Learning Difficulties About Introduction to Accounting And Finance of Worksheet Material Learning. International Journal of Islamic Education, Research and Multiculturalism (IJIERM), 5(1), 192–212.

Molise, H. V. (2020). Exploring the content knowledge of accounting teachers in rural contexts: A call for a decoloniality approach. International Journal of Learning, Teaching and Educational Research, 19(8), 447–458.

Natsir, F., Bakhtiar, M. Y., & Anggraeni, N. K. P. (2024). Pemanfaatan Aplikasi Microsoft Office sebagai Media Pembelajaran di SMK Mutiara Depok. Jurnal PkM (Pengabdian Kepada Masyarakat), 7(5), 602–608.

Panudju, A. T., Nopianti, R., Tjeng, P. S., Hayyin, F., & Surani, D. (2024). Pelatihan Penggunaan Ms Excel dalam Membuat Laporan Keuangan UMKM di Kelurahan Banjar Agung, Cipocok Jaya, Serang-Banten. PEDAMAS (Pengabdian Kepada Masyarakat), 2(06), 1541–1546.

Putri, V. W., & Budiyanto, S. M. (2023). Analysis of Students Difficulties in Completing The Service Company Accounting Cycle Learning in Class X and XI AKL Students of SMK Muhammadiyah 2 Karanganyar. Proceedings International Conference on Education Innovation and Social Science, 657–663.

Rahayu, E. S., & Asyiah, N. (2024). Pelatihan Microsoft Excel Sebagai Bekal Masuk Dunia Kerja Untuk Siswa/I Kelas XII SMK Bakti Idhata. Abdi Jurnal Publikasi, 2(3), 122–127.

Rinaldi, M., & Nurhaliza, E. (2024). Pengantar Akuntansi: Teori dan Panduan Dasar Akuntansi. PT. Sonpedia Publishing Indonesia.

Sa’diyah, D. I., & Yuhertiana, I. (2021). Changes in the Recording of Cash-Based Accounting Methods to Accrual Base. International Journal of Community Service & Engagement, 2(2), 24–31.

Saiful, S., & Nikmah, N. (2024). Applying Excel in Preparing Financial Statements of the Central Bengkulu Village Owned Enterprises. SPEKTA (Jurnal Pengabdian Kepada Masyarakat: Teknologi Dan Aplikasi), 5(2), 180–191.

Santoso, E. K., Winarni, W., Darmansyah, D., Arifa, D., Handayani, S., & Angelita, M. (2023). Pelatihan keterampilan dalam pengelolaan data dengan Ms Excel. Prosiding Seminar Nasional Penelitian Dan Pengabdian Kepada Masyarakat LPPM Universitas’ Aisyiyah Yogyakarta, 1, 745–749.

Wulaningrum, R., Ibrahim, M. S., & Andromeda, T. C. (2021). Microsoft office excel macro-based information system application training for travel entrepreneurs in Samarinda. Community Empowerment, 6(10), 1925–1928.




DOI: http://dx.doi.org/10.33474/penadimas.v3i2.26876

Refbacks

  • There are currently no refbacks.


Creative Commons License
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.

Pena Dimas: Jurnal Pengabdian Masyarakat is indexed by:

  

    

        

       

This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.