SYSTEMATIZATION OF CONDITIONAL FORMATTING AS A TOOL FOR AUTOMATED VISUAL DATA ANALYSIS

Authors

DOI:

https://doi.org/10.30890/2709-2313.2025-43-01-014

Keywords:

conditional formatting, automated visual analysis, systematization, Big Data, proactive control, logical formulas, table control

Abstract

The article explores the theoretical and methodological foundations and practical aspects of using conditional formatting in the MS Excel environment as a tool for automated visual data analysis under conditions of digital transformation and the challenge

References

Adamyk, O. (2016). Informatsiini tekhnolohii v kompiuternykh systemakh bukhhalterskoho obliku: problemy orhanizatsii danykh ta yikh potokiv [Information Technology in the Computer Systems of Accounting: Issues of Organizing the Data and Data Streams]. Biznes Inform, 10, pp. 348–353 (in Ukrainian).

Adonin, S., Kuriacha, N. (2021). Suchasni metody vykladannia z vykorystanniam informatsiinykh tekhnolohii [Modern teaching methods with the use of information technologies], Efektyvna ekonomika, vol. 4, Available at: http://www.economy.nayka.com.ua/?op=1&z=8790 Accessed 05 November 2025.

DOI: 10.32702/2307-2105-2021.4.85

Nuzhna, S. (2023). OUTSOURCING OF INFORMATION TECHNOLOGIES AS A TOOL OF INNOVATIVE MANAGEMENT OF FINANCIAL AND CREDIT INSTITUTIONS. Materialy konferentsii MTsND, (31.03.2023; Sumy, Ukraina), pp. 28–31. Available at: https://archive.mcnd.org.ua/index.php/conference-proceeding/article/view/478 (in Ukrainian).

Babinska, S. (2022). Informatsiini potoky mizh korystuvachamy bukhhalterskoi informatsii. [Information flows between users of accounting information]. Economy and Society. (43).

DOI: 10.32782/2524-0072/2022-43-25

Havrilenko, N., Kozitska, N. (2022). Analitychne zabezpechennia tsyfrovykh transformatsii [Analytical support of digital transformations]. Economy and Society. (38).

DOI: 10.32782/2524-0072/2022-38-38

Harkusha, S. (2021). Orhanizatsiia bezpaperovoho upravlinskoho obliku na pidpryiemstvakh maloho biznesu [Organization of paperless management accounting in small business enterprises]. Economy and Society, (23).

DOI: 10.32782/2524-0072/2021-23-12

Ivakhnenkov, S. (2010). Informatsiini tekhnolohii audytu ta vnutrishnohospodarskoho kontroliu v konteksti svitovoi intehratsii [Information technology audit and internal control in the context of world integration]. Zhytomyr: Ruta (in Ukrainian).

Korablinova, I.A. (2018). Informatsiine seredovyshche kompanii v umovakh suchasnoi khvyli «tsyfrovoi transformatsii» [Information environment of the company in the conditions of the modern wave of "digital transformation"]. Naukovo-vyrobnychyi zhurnal «Biznes-navihator», vol. 2-2(45), pp.11-15 (in Ukrainian).

Korol, S., Klochko, A. (2020). Tsyfrovi tekhnolohii v obliku y audyti [Digital technologies in accounting and auditing]. Derzhava ta rehiony. vol. 1, pp. 170–176 .

DOI: 10.32840/1814-1161/2020-1-29

Korol, S.,Polovyk, Ye. (2019). Didzhytalizatsiia ekonomiky profesiinoho rozvytku [Digitization of the Economy as Professional Development Factor]. Modern Economics. 18(2019), pp. 67-73.

DOI: 10.31521/modecon.V18(2019)-11

Moroz, S. and Nuzhna, S. (2021). Intehratsiia informatsiinykh system i tekhnolohii u pobudovi informatsiinoho prostoru silskohospodarskykh pidpryiemstv [Integration of information systems and technologies in construction of information space of agricultural enterprises]. Efektyvna ekonomika.vol. 5.

DOI: 10.32702/2307-2105-2021.5.87

Nuzhna S., Karimov H. & Karimov I. (2025). Excel-shablony dlia bukhhaltera ta finansovoho menedzhera [Excel templates for accountants and financial managers].Ekonomichnyi analiz. 34(1). pp. 213-225.

DOI: 10.35774/econa2024.01.213

Oneshko, S., Viter, S. & Viremeichyk, А. (2021). [Audit development strategy in the condition of digital economy]. Investytsiyi: praktyka ta dosvid. vol. 15, pp. 64–69.

DOI: 10.32702/2306-6814.2021.15.64

Plaksiienko, V., Lipskyi, R. (2018). Bukhhalterskyi oblik v upravlinni pidpryiemstvom: problemy teorii i praktyky [Accounting in enterprise management: problems of theory and practice]. Available at: https://www.pdaa.edu.ua/sites/default/files/nppdaa/7.2/039.pdf pp. 39-43. Accessed 05 November 2025. (in Ukrainian).

Putseneilo, P.R. and Humeniuk, O.O. (2018). [Digital economy as the new vector of reconstruction of the traditional economy]. Innovatsiina ekonomika. vol. 5-6, pp. 131-143. Available at: http://inneco.org/index.php/innecoua/article/view/305 (in Ukrainian).

Tarlopov I. O. (2020). Orhanizatsiia bukhhalterskoho obliku na pidpryiemstvakh v umovakh tsyfrovoi ekonomiky [Organization of accounting at enterprises in the digital economy. Investments: practice and experience]. Investytsii: praktyka ta dosvid. no. 17-18. pp. 24-28. Available at: http://www.investplan.com.ua/pdf/17-18_2020/6.pdf (in Ukrainian).

Technology and innovation. Big Data. Available at: https://www.it.ua/knowled ge-base/technology-innovation/big-data-bolshie-dannye Accessed: 05 November 2025 (in Ukrainian).

Kholiavko, N., Popelo, O., Dubyna, M., & Tarasenko, A. (2022). [Modern information technologies in the market of financial services of Ukraine]. Problems and Prospects of Economics and Management. 1(29), pp. 77–87.

DOI: 10.25140/2411-5215-2022-1(29)-77-87

Diachuk S. F. (2021). Excel 2013-2016: navchalnyi posibnyk. Ternopil: Vydavnytstvo TNTU imeni Ivana Pulia (in Ukrainian).

Published

2025-10-30

How to Cite

Nuzhna, S. (2025). SYSTEMATIZATION OF CONDITIONAL FORMATTING AS A TOOL FOR AUTOMATED VISUAL DATA ANALYSIS. European Science, 1(sge43-01), 21–49. https://doi.org/10.30890/2709-2313.2025-43-01-014