The Utilization of Microsoft Excel for Business Data Analysis: Case Study & Implementation
Abstract
Many vocational high school students do not yet possess the proficiency to manage and analyze data optimally. This is due to a lack of understanding of software applications such as Microsoft Excel, which are very useful in business operations. Therefore, this community service activity aims to enhance students' competence in using Excel as a tool for analyzing business data at SMK Letris Indonesia 2. This study used a qualitative method with a case study approach. Data were obtained through interviews with teachers at the school. This research was conducted based on direct practice (hands-on training) regarding the use of Excel, starting from basic functions to advanced features such as pivot tables, conditional formatting, and logic and statistical functions. This research is adjusted to the needs of the business and industrial world (DUDI) so that students can understand the application of Excel in the real world. This activity is in line with the spirit of Merdeka Belajar and the implementation of a project-based curriculum, which emphasizes the importance of mastering practical skills in addition to theoretical understanding. As a result, students can adapt to technological developments and innovate in the business field. In conclusion, training is still needed so that students can improve and develop their abilities
References
1. Kadir, A. (2017). Panduan Lengkap Microsoft Excel untuk Profesional Bisnis. Yogyakarta: Andi.
2. Kebudayaan, K. P. (2022, Februari 22). Kementrian Pendidikan dan Kebudayaan. Retrieved from https://pmpk.kemdikbud.go.id/assets/docs/UU_2003_No_20_-Sistem_Pendidikan_Nasional.pdf
3. Kotler, P., & Keller, K. L. (2016). Marketing Management (15th ed.). Pearson Education.
4. Laudon, K. C., & Laudon, J. P. (2020). Management Information Systems: Managing the Digital Firm (16th ed.). Pearson.
5. McLeod, R., & Schell, G. P. (2008). Management Information Systems (10th ed.). Pearson Education
6. Prawiyogi, A. G., Sadiah, T. L., Purwanugraha, A., & Elisa, P. N. (2021). Penggunaan Media Big Book untuk Menumbuhkan Minat Baca Siswa di Sekolah Dasar. Jurnal Basicedu.
7. Priyanto, D. (2020). Teknik Pengolahan Data Menggunakan Microsoft Excel dan SPSS. Yogyakarta: Deepublish.
8. Purwanto. (2018). Teknik Penyusunan Instrumen Uji Validasi dan Reliabilita Penelitian Ekonomi Syariah. Magelang: StaiaPress.
9. Sugiyono. (2018). Metode Penelitian Kombinasi (Mix Methods). Bandung: Alfabeta.
10. Suyanto, M. (2016). Smart Business: Cara Cerdas Mengelola Informasi dan Data Bisnis. Yogyakarta: Andi.
11. Wahyuni, S. (2021). Peran Microsoft Excel dalam Meningkatkan Keterampilan Analisis Data Siswa. Jurnal Teknologi dan Pembelajaran, 6(1), 55–63.
This work is licensed under a 