Automating Manual Excel Tasks

Gwanak-gu in Seoul (District Mayor Park Junhee) announced on September 27 that it will introduce an automation program, developed directly by its employees, into practical work tasks starting next month. The entire process—from planning to development—was handled by staff in charge of practical tasks, without outsourcing.

Staff Club 'Innovation AI Club' of Gwanak-gu. Provided by Gwanak-gu.

Staff Club 'Innovation AI Club' of Gwanak-gu. Provided by Gwanak-gu.

View original image

This program was created by the 'Innovation AI Club,' a staff research group formed earlier this year. The club began its activities in April and collected about 30 ideas from employees on "tasks to improve with AI." Out of these, the idea that received the most support—"Excel-based administrative automation"—was selected as the first project. During development, feedback from local community center staff and others was incorporated.


The program is designed to automate tasks that were previously handled manually, such as managing resident self-governance program schedules, collecting course fees, and administrating registrants. The district plans to upload the program onto its internal platform, the "Gwanak AI Yard," in October so that employees can use it in their actual work tasks. By doing so, Gwanak-gu expects to reduce repetitive work and enable staff to focus more on resident-facing services such as handling civil complaints.


Gwanak-gu is also conducting education programs and competitions to enhance employees' AI capabilities. In August, the district launched and began operating its own "Gwanak AI Yard," a platform for sharing automation programs and ideas. In addition, nine staff members received the Ministry of the Interior and Safety’s "AI Champion" certification last year, and 15 more obtained the certification by August of this year.



District Mayor Park Junhee stated, "This case is a meaningful step toward employee-led work innovation, as staff members who best understand field issues directly identified the necessary functions and developed them into a program. Going forward, we will actively utilize artificial intelligence and other digital technologies in administration to improve work practices and raise the quality of administrative services experienced by residents."


This content was produced with the assistance of AI translation services.

© The Asia Business Daily. All rights reserved. Unauthorized AI training and use prohibited.

Today’s Briefing