Socialization & Training on Modern Administration: Improving Correspondence and Data Management Skills Using Microsoft Office at the Kelurahan Office in Kel. Manggis Kec. Bathin III Kab. Bungo

Abstract

Efficient administrative management at the urban village level is key to excellent public services. However, optimizing the use of office technology is often hampered by the limited technical skills of staff in operating in-depth software. In Manggis Urban Village Office, Bathin III Sub-district, Bungo Regency, data management and correspondence still face obstacles in time efficiency and format standardization. This PKM activity aims to improve the competence of village officials in modern administration through strengthening skills in using Microsoft Office. The method of implementing activities uses socialization methods, intensive training (workshops), and direct assistance. The material focused on Mail Merge techniques in MS Word to accelerate the creation of mass mailings and table management and basic formulas in MS Excel for organizing population data. The results of the training showed a significant improvement in the technical skills of the participants. Before the training, most staff typed letters manually one by one. After the training, staff were able to implement a more structured and automated administrative system. Conclusion: Through this training, the administrative process at Kantor Kelurahan Manggis has become faster, more accurate and professional, which directly contributes to improving the quality of service for the local community.