Pemanfaatan Microsoft Excel untuk Aplikasi Data Pelanggan pada Pada Usaha Jasa Pembersihan Dan Perawatan Sepatu, Tas, Dan Topi

Fajar Astuti Hermawati; Aidil Primasetya Armin

doi:10.31849/dinamisia.v5i4.6642

Fajar Astuti Hermawati Universitas 17 Agustus 1945 Surabaya
Aidil Primasetya Armin Universitas 17 Agustus 1945 Surabaya

DOI: https://doi.org/10.31849/dinamisia.v5i4.6642

Keywords: Customer Application, Microsoft Excel, Services, Micro-business

Abstract

Scar Wash is a micro-business engaged in the care and cleaning of bags, hats and shoes located in the Karang Menjangan area of Surabaya. In the process, partners face problems in the process of storing customer data is still done in the manual form. So it isn't easy in knowing information about customers and what transactions have been made by satisfied customers to improve service. Since of these reasons, we offer to create desktop applications by utilizing a Microsoft Excel spreadsheet application that is quite familiar to business owners. The system consists of three main menus, namely the customer data, the service data and the transaction menu. The customer data menu is for storing customer data. The service data menu is for managing service data provided by partners and the rates of each service provided. The transaction menu is used to record every transaction of a customer that includes services and the total cost that the customer must pay. This application has the advantage of being easy to install. After all, it does not require software other than Microsoft Excel, small and fast because it runs directly on the Excel application itself and is easy to use because it has a combo-box facility for selecting customer data and service data

Downloads

Download data is not yet available.

References

Andriyani, D., Harahap, E., Badruzzaman, F. H., Fajar, M. Y., & Darmawan, D. (2019). Aplikasi Microsoft Excel Dalam Penyelesaian Masalah Rata-rata Data Berkelompok. Jurnal Matematika, 18(1), 41–46.

Hamise, C. O., Maharibe, A. J., & Lintong, J. S. (2020). Desain Aplikasi Akuntansi Untuk Reseller Online Shop Berdasarkan SAK EMKM Berbasis VBA Macro Microsoft Excel (Studi Kasus Online Shop Roch Store Manado). Jurnal Bisnis Dan Kewirausahaan, 16(1), 44–57. https://doi.org/10.31940/jbk.v16i1.1823

Hardianto, R., Wiza, F., Studi, P., Informatika, T., Komputer, F. I., Kuning, U. L., … Kuning, U. L. (2019). Pelatihan office perkantoran di sma pgri pekanbaru sebagai bekal menyonsong revolusi industri 4.0. Dinamisia : Jurnal Pengabdian Kepada Masyarakat, 3(1), 53–61.

Harmastuti, & Setyowati, D. (2018). Pemanfaatan Microsoft Excel Untuk Pembelajaran Matematika Dan Grafik. Jurnal Dharma Bakti, 1(1), 57–66.

Martinus Maslim, Adithama, S. P., & Nugroho, A. H. T. (2020). Pembangunan Sistem Informasi Penjualan Pada Usaha Mikro, Kecil, Dan Menengah (Studi Kasus : Pahala Fotokopi dan Digital Printing). Dinamisia : Jurnal Pengabdian Kepada Masyarakat, 4(1), 95–105. https://doi.org/10.31849/dinamisia.v4i1.3363

Putri, A. R. (2015). Optimalisasi Penggunaan Microsoft Excel untuk Pengolahan Nilai Raport di SMAN 1 Ngunut Tulungagung. J-Adimas, 3(1), 1–4.

Rustendi, T. (2019). Aplikasi Sistem PDE Berbasis Excel Untuk Akutansi Keuangan Organisasi Nir-laba. Jurnal Pengabdian Siliwangi, 5(1), 1–7.

Sukmawan, L. P., & Utomo, H. (2017). Aplikasi Microsoft Excel VBA Untuk Database Penjualan dan Peramalan Penjualan dengan Metode Trend di CV Agro Industri Malang. Jurnal Aplikasi Bisnis, 3(2), 19–24.

Waguespack, L. J., Hunsinger, S., Fryling, M., Sharp, J., Wu, P., Babb, J., … Ellington, V. (2017). Microsoft Excel®: Is It An Important Job Skill for College Graduates? Information Systems Education Journal (ISEDJ), 15(3), 15.

Zahara, Sukartini, Amy, F., Eliyanora, & Yossi, S. (2013). Perancangan Model Penyusunan Laporan Keuangan Perusahaan dengan Program Excell For Accounting(EFA). Simposium Nasional Akuntansi Vokasi Ke-2, 648–660.