ANALYZING STUDENTS MASTERY OF EXCEL DATA FEATURES IN OFFICE ADMINISTRATION EDUCATION
Keywords:
Microsoft Excel, feature mastery, student competence, digital literacy, office administrationAbstract
This study aims to analyze the level of mastery among Office Administration Education students regarding various data processing features in Microsoft Excel. In today’s digital workplace, proficiency in Excel is essential, yet many students still struggle with functions beyond the basic level. The problem addressed in this research is the gap between the required digital skills in the professional environment and the actual competencies possessed by students. A descriptive quantitative method was employed, involving five selected students from the 2nd, 4th, and 6th semesters as respondents. Data were collected through a structured Likert-scale questionnaire that measured proficiency across basic, intermediate, and advanced Excel features. The results indicate that students exhibit strong proficiency in basic functions such as SUM and AVERAGE. However, their understanding and application of more complex functions such as IF statements, Pivot Tables, and VLOOKUP are significantly weaker. This suggests a lack of exposure to more advanced digital tools within the current curriculum. The findings underscore the need for more comprehensive and practical digital literacy training to bridge the skills gap and better prepare students for the demands of modern administrative work environments.
References
Alshare, K., & Lane, P. L. (2020). Predicting student-perceived learning outcomes using course learning objectives: An empirical investigation. Decision Sciences Journal of Innovative Education, 9(3), 409–437. https://doi.org/10.1111/j.1540-4609.2011.00316.x
Chandra, R., Prasetyo, M. A., & Kartika, I. (2025). Digital tool integration in administrative training: A case for Power BI and Excel in higher education. Journal of Educational Technology and Business, 12(1), 22–36.
Davis, F. D. (2020). Perceived usefulness, perceived ease of use, and user acceptance of information technology. MIS Quarterly, 13(3), 319–340. https://doi.org/10.2307/249008
Ghasemi, M., Shafeiepour, V., Aslani, M., & Barvayeh, E. (2021). The impact of using Microsoft Excel in teaching mathematics. Procedia - Social and Behavioral Sciences, 28(2), 426–430. https://doi.org/10.1016/j.sbspro.2021.10.111
Hall, M., Ramsay, A., & Raven, J. (2020). Changing the learning environment to promote deep learning approaches in first-year accounting students. Accounting Education, 13(4), 489–505. https://doi.org/10.1080/0963928042000306837
Ibrahim, M., & Nat, M. (2022). Enhancing digital skills through Excel-based learning: An applied approach in Indonesian higher education. Journal of Education and Learning, 11(3), 210–218. https://doi.org/10.5539/jel.v11n3p210
Lim, C. P., & Tay, L. Y. (2023). ICT in an elementary school: Students’ engagement in higher-order thinking. Journal of Educational Multimedia and Hypermedia, 12(4), 425–451.
Lin, Y., & Yu, T. (2023). Exploring spreadsheet proficiency and digital self-efficacy among business students. Asia Pacific Journal of Business Education, 5(2), 145–159. https://doi.org/10.1007/s11846-023-00523-6
Pranoto, H., & Sulistyo, R. (2024). Embedding advanced Excel tools in business administration curricula: Effects on graduate employability. Indonesian Journal of Educational Research and Technology, 4(1), 75–88. https://doi.org/10.31002/ijert.v4i1.654
Prensky, M. (2021). Digital natives, digital immigrants. On the Horizon, 9(5), 1–6. https://doi.org/10.1108/10748120110424816
UNESCO. (2022). Digital skills for life and work: Global framework on education for digital literacy. UNESCO Publishing. https://unesdoc.unesco.org/ark:/48223/pf0000382940
UNESCO. (2022). Digital skills critical for jobs and social inclusion. https://en.unesco.org/news/digital-skills-critical-jobs-and-social-inclusion
Widiastuti, F., & Mahadwartha, P. A. (2022). Enhancing students’ digital literacy skills through spreadsheet training: A case study in business administration. International Journal of Educational Management and Innovation, 3(1), 1–10. https://doi.org/10.12928/ijemi.v3i1.4907
Widiastuti, R., & Mahadwartha, P. A. (2022). Excel-based performance enhancement during student internships in SMEs. Jurnal Manajemen dan Kewirausahaan, 24(1), 67–78. https://doi.org/10.9744/jmk.24.1.67-78
