Article Per Year (5 Year)
p-Index From 2021 - 2026
1.896
P-Index
This Author published in this journals
All Journal Jurnal Linears SELAPARANG: Jurnal Pengabdian Masyarakat Berkemajuan Agro Bali: Agricultural Journal Bandar: Journal of Civil Engineering Jurnal Dedikasi Pusaka : Journal of Tourism, Hospitality, Travel and Business Event Malaqbiq : Jurnal Pengabdian kepada Masyarakat. Journal of Green Science and Technology Jurnal Pengabdian Kepada Masyarakat Indonesia
Mulawarman, Ade
Universitas Sulawesi Barat
Religion Agriculture, Biological Sciences & Forestry Arts Humanities Chemical Engineering, Chemistry & Bioengineering Civil Engineering, Building, Construction & Architecture Computer Science & IT Control & Systems Engineering Decision Sciences, Operations Research & Management Economics, Econometrics & Finance Education Electrical & Electronics Engineering Engineering Environmental Science Health Professions Languange, Linguistic, Communication & Media Law, Crime, Criminology & Criminal Justice Medicine & Pharmacology Nursing Public Health Social Sciences Transportation Other

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

Found 11 Documents
Search

 1   2 
Pengembangan aplikasi persuratan berbasis Excel VBA untuk mengoptimalisasi layanan administrasi di Desa Batulaya Ade Mulawarman; Farid Wajidi; Rahmiyatal Munaja; Andi Nur Fiqhi Utami; Candaria Candaria
SELAPARANG: Jurnal Pengabdian Masyarakat Berkemajuan Vol 9, No 4 (2025): Juli
Publisher : Universitas Muhammadiyah Mataram

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.31764/jpmb.v9i4.32541

Abstract

Abstrak Program pengabdian masyarakat di Desa Batulaya bertujuan untuk meningkatkan efisiensi administrasi desa melalui pengembangan aplikasi berbasis Excel VBA. Aplikasi ini dirancang untuk mempermudah pembuatan dan pengelolaan surat menyurat, yang sebelumnya dilakukan secara manual. Proses manual ini sering kali memakan waktu lama dan rentan terhadap kesalahan administratif. Melalui pelatihan dan pendampingan implementasi, aparat desa diajarkan cara mengoperasikan aplikasi, memodifikasi template surat, dan mengotomatisasi tugas administratif lainnya. Evaluasi terhadap hasil implementasi menunjukkan adanya peningkatan signifikan dalam efisiensi kerja aparat desa, dengan pengurangan waktu pembuatan surat dari rata-rata 15 menit menjadi hanya 5 menit. Selain itu, aplikasi ini berhasil mengurangi kesalahan administratif yang sering terjadi pada proses manual, meningkatkan akurasi data, dan memperbaiki sistem pengarsipan. Dengan antarmuka sederhana, aplikasi ini mudah digunakan bahkan bagi pengguna dengan pengetahuan teknologi terbatas. Inovasi ini memberikan solusi teknologi yang tepat guna dan berpotensi untuk direplikasi di desa-desa lain dengan tantangan serupa. Program ini juga memberikan dampak jangka panjang berupa peningkatan kapasitas sumber daya manusia desa dalam memanfaatkan teknologi informasi untuk mendukung administrasi yang lebih modern dan efisien. Kata kunci: aplikasi excel VBA; administrasi desa; efisiensi administrasi; pelatihan teknologi informasi; pengarsipan surat  Abstract The community service program in Batulaya Village aims to improve administrative efficiency through the development of an Excel VBA-based application. This application is designed to simplify the creation and management of letters, which were previously done manually. Manual processes often took a long time and were prone to administrative errors. Through training and implementation assistance, village officials were taught how to operate the application, modify letter templates, and automate other administrative tasks. The evaluation of the implementation results showed a significant improvement in the work efficiency of village officials, reducing the time required to create a letter from an average of 15 minutes to just 5 minutes. Additionally, the application successfully reduced administrative errors, enhanced data accuracy, and improved the document archiving system. With its simple interface, the application is easy to use even for users with limited technological knowledge. This innovation provides an appropriate technological solution and has the potential to be replicated in other villages facing similar challenges. The program also delivers long-term impacts by enhancing the human resource capacity of the village in utilizing information technology to support more modern and efficient administration. Keywords: excel VBA application; village administration; administrative efficiency; information technology training; letter archiving
Co-Authors Abdullah, Muhammad Arafat Adip Wahyudi Anggit Priadmojo Arifuddin Akil Arifuddin Akil Arifuddin Akil Astinawaty Candaria Candaria Dedi Hadian Dwi Ahrisa Putri Erwin, Muh. Alfarezi Farid Wajidi farid wajidi Kurniati Kurniati Maskur, Nurftriani Mufti Hatur Rahmah Muh. Adrian Muh. Adrian Muh. Arhim Muhammad Arafat Abdullah Muhammad Arafat Abdullah Muhammad Arsyad Muhammad Arsyad Mukhlis, Jafar Munaja, Rahmiyatal Mustari Mustari Nur Adyla S Nur Fiqhi Utami, Andi Nur, Nahya Nurfitriani Maskur Nurhikmah Paddiyatu Nurlaela Nurlaela NURLAELA NURLAELA Parenreng, Jumadi M. Rabi’atul Adawia Haupea Rahmiyatal Munaja Rahmiyatal munaja Hatta Rifky Gunawan Rifky Gunawan Sumarni B Uca, Uca Widyanti Utami A