TITLE
DYNAMIC ARRAYS IN MS EXCEL FOR DATA PROCESSING AND ANALYSIS IN INFORMATION SYSTEMS
AUTHOR(S)
Valentina P. Todorova-Lazarova
ABSTRACT
Managing and analyzing data effectively is a central issue in modern information Managing and analyzing data effectively is a central issue in modern information systems. This study explores the potential of dynamic arrays in Microsoft Excel for improving efficiency in data processing and analytical workflows. The methodology is based on applied demonstrations and comparative analysis between traditional
formulas and dynamic approaches, including named ranges, array formulas, and new functions available in Excel 365. Key results show that dynamic arrays support automation, enhance flexibility, and improve data accuracy, especially when datasets change frequently. The findings confirm that such tools are valuable in business settings, educational contexts, and lightweight ETL processes. The conclusion emphasizes the
educational benefits and real-world applicability of dynamic arrays, particularly in resource-constrained scenarios. The originality of the research lies in its integrated perspective—combining technical application
with pedagogical value—and its practical demonstration of Excel as an accessible platform for developing analytical skills.
DOI
How to cite this article:
Valentina P. Todorova-Lazarova, DYNAMIC ARRAYS IN MS EXCEL FOR DATA PROCESSING AND ANALYSIS IN INFORMATION SYSTEMS, UNITECH – SELECTED PAPERS - 2025