Article Per Year (5 Year)
p-Index From 2021 - 2026
0.23
P-Index
This Author published in this journals
All Journal Komunita: Jurnal Pengabdian dan Pemberdayaan Masyarakat
Salvin Cahya Pratama
Universitas Trunojoyo Madura
Economics, Econometrics & Finance Environmental Science Public Health Social Sciences

Published : 1 Documents Claim Missing Document
Claim Missing Document
Check
Articles

Found 1 Documents
Search

 1 
Pendampingan Penggunaan Microsoft Excel Berbasis Link Antar Sheet sebagai Upaya Meningkatkan Ketelitian Review Laporan Keuangan Pemerintah Daerah Salvin Cahya Pratama; Mohamad Djasuli
KOMUNITA: Jurnal Pengabdian dan Pemberdayaan Masyarakat Vol 5 No 3 (2026): Agustus
Publisher : PELITA NUSA TENGGARA

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.60004/komunita.v5i3.851

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.
Co-Authors Mohamad Djasuli