Simple Financial Recording Training Using Excel For Vocational School Students

Danang Adi Putra; Pratana Puspa Midiastuty; Eddy Suranta; Rini Indriani; Robinson Robinson

doi:10.70963/mandiri.v2i1.897

Authors

Danang Adi Putra Universitas Bengkulu
Pratana Puspa Midiastuty Universitas Bengkulu
Eddy Suranta Universitas Bengkulu
Rini Indriani Universitas Bengkulu
Robinson Robinson Universitas Bengkulu

DOI:

https://doi.org/10.70963/mandiri.v2i1.897

Keywords:

Training, Financial Record-Keeping, Microsoft Excel, Vocational Students, Financial Literacy, Basic Accounting

Abstract

This training aims to improve the financial recording skills of Vocational High School (SMK) students through the use of Microsoft Excel as a practical tool. The problem that is often faced by vocational school students, especially majoring in accounting or business, is the lack of understanding and skills in conducting financial recording systematically and efficiently. In this activity, participants were trained starting from the introduction of the basic functions of Excel, the creation of simple financial report formats, to the use of basic formulas such as SUM, IF, and VLOOKUP to support basic accounting processes. This training was carried out in the form of an interactive workshop for two days with lecture methods, hands-on practice, and discussion. The results of the evaluation showed an increase in students' understanding and skills in compiling daily and monthly financial reports using Excel. This activity also encourages students to be better prepared to face the needs of the world of work, especially in the fields of administration and finance. With a hands-on approach, this training has a positive impact on the mastery of basic technology and accounting for vocational school students.

References

Arens, A. A., Elder, R. J., & Beasley, M. S. (2017). Auditing and assurance services: An integrated approach (16th ed.). Pearson Education.

Fitriani, S., & Wahyuni, S. (2021). Pengaruh penggunaan Microsoft Excel terhadap hasil belajar akuntansi siswa SMK. Jurnal Pendidikan Akuntansi Indonesia, 19(2), 112–120. https://doi.org/10.21831/jpai.v19i2.40215

Hariyadi, R. (2020). Penerapan media pembelajaran Microsoft Excel dalam meningkatkan kemampuan siswa pada kompetensi dasar pencatatan transaksi. Jurnal Edukasi Akuntansi, 8(1), 45–55.

Kementerian Pendidikan dan Kebudayaan. (2020). Kurikulum SMK revisi 2020. Direktorat Jenderal Pendidikan Vokasi.

Peraturan Presiden Republik Indonesia Nomor 68 Tahun 2022 tentang Revitalisasi Pendidikan dan Pelatihan Vokasi serta Pelatihan Kerja. (2022).

Purnama, B. E. (2022). Pelatihan Microsoft Excel dasar bagi siswa SMK untuk pencatatan transaksi keuangan. Jurnal Pengabdian Masyarakat Vokasi, 4(1), 89–96.

Sugiyanto, T. (2020). Penguasaan aplikasi pengolah angka untuk tenaga administrasi keuangan. Jurnal Teknologi dan Pendidikan, 18(3), 130–140.

Wicaksono, A., & Lestari, R. (2019). Strategi pembelajaran berbasis digital pada pendidikan vokasi. Jurnal Pendidikan Vokasi, 9(2), 145–157.