International Journal of Teaching and Learning (INJOTEL)
Vol. 2 No. 11 (2025): JULY

ANALYZING STUDENTS MASTERY OF EXCEL DATA FEATURES IN OFFICE ADMINISTRATION EDUCATION

Intan Fitria Khalila (University State of Jakarta, Indonesia)
Marsofiyati (University State of Jakarta, Indonesia)
Eka Dwi Utari (University State of Jakarta, Indonesia)



Article Info

Publish Date
01 Jul 2025

Abstract

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.

Copyrights © 2025






Journal Info

Abbrev

INJOTEL

Publisher

Subject

Education Mathematics Other

Description

International Journal of Teaching and Learning (INJOTEL) publishes articles on education and learning in general. Contains articles / research results written by experts, scientists, practitioners, and reviewers in the field of education and learning. Some of International Journal of Teaching and ...