Pendampingan Penggunaan Microsoft Excel Berbasis Link Antar Sheet sebagai Upaya Meningkatkan Ketelitian Review Laporan Keuangan Pemerintah Daerah
Abstract
This community service was conducted at the Bangkalan Regency Inspectorate with the aim of improving the accuracy and efficiency of the local government financial report review process using Microsoft Excel based on inter-sheet links. Partners faced problems with the process of processing and summarizing financial data, which was still done manually, which could lead to input errors, data discrepancies between reports, and yields. This activity was carried out in several stages, including identifying the problem, creating a Microsoft Excel format based on inter-sheet links, teaching how to use Microsoft Excel, conducting a simulation of a local government financial report review, and evaluating the results. The mentoring focused on the use of formulas and data connectivity between sheets to make the process of processing, validating, and consolidating financial report data easier. The results of the activity showed that the implementation of Microsoft Excel based on inter-sheet links can improve the efficiency of the local government financial report review process. This was evidenced by faster data recapitulation speed, lower input error rates, and better data consistency between financial reports. This activity also improves employee understanding and skills on how information technology can help manage financial data more efficiently and accurately. Therefore, the use of Microsoft Excel based on inter-sheet links can help the process of reviewing local government financial reports more efficiently, clearly, and accountably. By using more optimal information technology, this activity is expected to help improve regional financial governance.
References
Azhar, A. B., Putri, E. T., Fikri, M. F., & Assyukron, I. F. (2023). PELATIHAN MICROSOFT OFFICE SEBAGAI UPAYA PENINGKATAN. 7(4), 1–7.
Dewi, M. W., Sumiyati, S., & Sobriani, E. S. (2020). No Title. 02(02), 166–172.
Keuangan, K. L. (2023). DEKAT. 2, 48–65.
Kurniawan, I., Asma, F. R., Budiarso, I., & Abdillah, R. (2021). MENGEMBANGKAN KEMAMPUAN GURU DAN TENAGA ADMINISTRASI DALAM MENINGKATKAN KINERJA. 04(04), 371–375.
Laporan, P., Pemerintah, K., & Kudus, K. (2025). Jurnal Akuntansi dan Keuangan Vol . 14 No . 1 April 2025 FEB Universitas Budi Luhur. 14(1), 39–56.
Matematika, P. (2018). Pendidikan Matematika, FKIP Universitas Muhammadiyah Tapanuli Selatan. 1, 78–82.
Nasution, E. Y. (2023). Pengaruh Penerapan Sistem Informasi Pemerintah Daerah , Pemanfaatan Teknologi Informasi dan Kompetensi Sumber Daya Manusia terhadap Kualitas Laporan Keuangan. 2(3), 258–265.
Niati, A., Soelistiyono, A., & Ariefiantoro, T. (2019). E-DIMAS. 10(1), 105–110.
Odja, M. O., Likadja, F. J., Ina, W. T., & Pella, S. I. (2021). Penggunaan Microsoft Excel untuk Kemudahan Pengolahan Data Nilai Hasil Belajar Siswa. XV(2), 22–29.
Prasetyo, A., Saddewisasi, W., Adriyanto, A. T. R. I., & Kunci, K. (2022). Praktek Aplikasi Laporan Keuangan Menggunakan Microsoft Excel Pada Anggota Pengembangan Ekonomi Lokal ( PEL ) Kota Semarang. 2(2), 72–78.
Saggaf, A., Siregar, M. I., Hidayat, M., Puspita, M., & Atiyatna, D. P. (2023). PELATIHAN PENYUSUNAN LAPORAN KEUANGAN BERBASIS SOFTWARE EXCEL KEPADA PARA PELAKU UMKM DI KOPERASI SIMPAN PINJAM DI DESA MUARA PENIMBUNG ULU OGAN ILIR. 7(1), 15–20.
Santriaty, M., Sasanti, E. E., & Astuti, W. (2023). Mandiri : Jurnal Akuntansi dan Keuangan Pengaruh Penyajian Laporan Keuangan Dan Aksesibilitas Laporan Keuangan Terhadap Akuntabilitas Pengelolaan Keuangan Daerah Pendahuluan. 2(1).
Sinaga, L., Ami, G., Ginting, S., Sembiring, F., Saragih, P. L., Kemala, P., Lubis, D., & Matondang, K. A. (2026). Akuntabilitas Pengelolaan Keuangan Negara melalui Laporan Keuangan Pemerintah ( LKPD dan LKPP ) Perspektif Akuntansi Sektor Publik. 4(4), 23458–23466.
Suatu, S., Pengabdian, P., & Pesantren, P. (2024). SIPAKARAYA Pelatihan Microsoft Excel untuk Peningkatan Keterampilan Administrasi. 2(2), 150–158. https://doi.org/10.31605/sipakaraya.v2i2.3457
