Pelatihan Pembuatan Laporan Kerja  Menggunakan Microsoft Excel Guna Mendukung Keahlian Staf Desa Kota Batu

Utami, Lilyani Asri; Yulia, Eka Rini; Ernawati, Siti; Hertyana, Hylenarti

doi:10.31294/jabdimas.v4i2.10342

“…Fungsi program Excel untuk mengolah data secara otomatis seperti perhitungan, rumus, pemakaian fungsi, tabel, pembuatan grafik dan manajemen data. Microsoft Excel memiliki banyak fitur dan dapat mengolah data dengan menggunakan rumus-rumus yang sudah tersedia (Septa et al, 2023).…”

Section: A Latar Belakangunclassified

“…Selain fitur pengolaan data, Microsoft Excel juga dapat digunakan untuk menghitung angka-angka, bekerja dengan daftar data dan menganalisis data serta merepresentasikan data dalam bentuk grafik atau diagram (Aditama et al, 2021). Penggunaan Microsoft Excel juga dapat membantu pembuatan laporan kerja guna mendukung keahlian bidang ekonomi di daerah Tangerang Selatan, Banten (Septa et al, 2023). Microsoft Excel juga digunakan untuk mendukung efektivitas pengerjaan pekerjaan harian pada ASN Kantor Pelayanan Kekayaan Negara dan Lelang (KPKNL) Bekasi.…”

Section: A Latar Belakangunclassified

Pengenalan Pemanfaatan Basis Data (Database) Pada Microsoft Excel Pada Kantor Desa Untuk Membantu Pencatatan Dan Pengelolaan Data

Arista,

Muliawati,

Rahayu

2024

JMM

0

View full text Add to dashboard Cite

Abstrak: Pemanfaatan teknologi informasi menjadi penting di era digital. Kantor desa tidak lagi melalukan pelayanan secara manual dengan mencatatkan dan mengolah data menggunakan kertas dan pena. Saat ini, para pegawai di kantor desa juga dituntut dapat memanfaatkan berbagai perangkat digital seperti perangkat lunak Microsoft Excel. Oleh karena itu, tim dari dosen Fakultas Ilmu Komputer UPN Veteran Jakarta berupaya melaksanakan pengenalan pemanfaatan database pada Microsoft Excel sebagai upaya realisasi kegiatan pengabdian kepada masyarakat. Tujuan kegiatan ini yaitu membantu memberi pengenalan hard skill terkait pemanfaatan database pada Microsoft Excel untuk mencatat dan mengolah data. Kegiatan dilaksanakan melalui metode sosialisasi pemaparan materi. Kegiatan pengabdian ini dilaksanakan di satu mitra yaitu Kantor Desa Rawapanjang dengan melibatkan peserta sebanyak 11 perangkat desa. Pada pre-test pemateri menanyakan fungsi dari beberapa menu yang terdapat pada Microsoft Excel. Pada akhir kegiatan dilakukan pemberian post-test untuk menguji pemahaman peserta melalui tanya jawab secara lisan 5 soal terkait materi yang disampaikan. Berdasarkan hasil pengabdian, diketahui 90% peserta dapat menjawab 5 soal post-test dengan tepat. Sebagai evaluasi dan upaya berkelanjutan akan dilaksanakan pelatihan dan pendampingan implementasi dari konsep pengenalan yang telah dipelajari melalui praktik.Abstract: The use of information technology is important in the digital era. Village offices no longer carry out services manually by recording and processing data using paper and pen. Currently, employees at village offices are also required to be able to utilize various digital tools such as Microsoft Excel software. Therefore, a team of lecturers from the Faculty of Computer Science, UPN Veteran Jakarta, is trying to introduce the use of databases in Microsoft Excel as an effort to realize community service activities. The aim of this activity is to help provide an introduction to hard skills related to using databases in Microsoft Excel to record and process data. Activities are carried out through the socialization method of presenting material. This service activity was carried out at one partner, namely the Rawapanjang Village Office, involving 11 village officials as participants. In the pre-test the speaker asked about the functions of several menus in Microsoft Excel. At the end of the activity, a post-test was given to test participants' understanding through verbal question and answer questions regarding the material presented. Based on the results of the service, it is known that 90% of participants were able to answer the 5 post-test questions correctly. As an evaluation and ongoing effort, training and assistance will be carried out in the implementation of introductory concepts that have been learned through practice.

show abstract

Training and Assistance in Financial Administration Report Preparation Using Microsoft Excel

Jaman,

Suarni,

Sahib

2023

Ind. Jour. Cul. Comm. Dev

0

View full text Add to dashboard Cite

This article presents the outcomes of the Program Pengabdian Kepada Masyarakat (PKM) undertaken by a social movement organization in Indonesia. The program aimed to enhance the financial reporting capabilities of its leadership through a three-phase approach comprising training, mentoring, and evaluation of financial administration records. Virtual pre-training equipped participants with essential Excel and financial application skills. The results showed a significant improvement in financial reporting, ensuring transparency and accountability. Moreover, the financial administration training facilitated better planning and informed decision-making, fostering sustainable development. These implications resonate globally, encouraging similar community engagement initiatives to advance financial transparency and effectiveness. Highlights: Enhanced Financial Reporting: The three-phase approach led to a significant improvement in the organization's financial reporting capabilities, ensuring greater transparency and accountability. Empowered Decision-Making: The financial administration training enabled better planning and informed decision-making, contributing to the sustainable development of the social movement organization. Global Implications: The program's success inspires related scientists and organizations worldwide to implement similar community engagement initiatives, advancing financial transparency and effectiveness on a broader scale. Keywords: Financial reporting, Community engagement, Sustainable development, Training, Transparency

show abstract

Training and Assistance in Financial Administration Report Preparation Using Microsoft Excel

Jam’an

¹

,

Suarni

²

,

Sahib

³

2023

Ind. Jour. Cul. Comm. Dev

0

View full text Add to dashboard Cite

This article presents the outcomes of the Program Pengabdian Kepada Masyarakat (PKM) undertaken by a social movement organization in Indonesia. The program aimed to enhance the financial reporting capabilities of its leadership through a three-phase approach comprising training, mentoring, and evaluation of financial administration records. Virtual pre-training equipped participants with essential Excel and financial application skills. The results showed a significant improvement in financial reporting, ensuring transparency and accountability. Moreover, the financial administration training facilitated better planning and informed decision-making, fostering sustainable development. These implications resonate globally, encouraging similar community engagement initiatives to advance financial transparency and effectiveness. Highlights: Enhanced Financial Reporting: The three-phase approach led to a significant improvement in the organization's financial reporting capabilities, ensuring greater transparency and accountability. Empowered Decision-Making: The financial administration training enabled better planning and informed decision-making, contributing to the sustainable development of the social movement organization. Global Implications: The program's success inspires related scientists and organizations worldwide to implement similar community engagement initiatives, advancing financial transparency and effectiveness on a broader scale. Keywords: Financial reporting, Community engagement, Sustainable development, Training, Transparency

show abstract

Pelatihan Pembuatan Laporan Kerja Menggunakan Microsoft Excel Guna Mendukung Keahlian Staf Desa Kota Batu

Cited by 3 publications

References 1 publication

Pengenalan Pemanfaatan Basis Data (Database) Pada Microsoft Excel Pada Kantor Desa Untuk Membantu Pencatatan Dan Pengelolaan Data

Pengenalan Pemanfaatan Basis Data (Database) Pada Microsoft Excel Pada Kantor Desa Untuk Membantu Pencatatan Dan Pengelolaan Data

Training and Assistance in Financial Administration Report Preparation Using Microsoft Excel

Training and Assistance in Financial Administration Report Preparation Using Microsoft Excel

Contact Info

Product

Resources

About