LAMBDA FUNCTION IN EXCEL IN RESPONSE TO CHALLENGES OF
NONPROGRAMMERS IN MODERN CORPORATE PRACTICE

D 2023

LAMBDA FUNCTION IN EXCEL IN RESPONSE TO CHALLENGES OF NONPROGRAMMERS IN MODERN CORPORATE PRACTICE

LASÁK, Pavel a Maria KRÁLOVÁ

Základní údaje

Originální název

LAMBDA FUNCTION IN EXCEL IN RESPONSE TO CHALLENGES OF NONPROGRAMMERS IN MODERN CORPORATE PRACTICE

Autoři

LASÁK, Pavel (203 Česká republika, domácí) a Maria KRÁLOVÁ (203 Česká republika, domácí)

Vydání

Valencia, Spain, INTED2023 Proceedings, od s. 931-937, 7 s. 2023

Nakladatel

17th International Technology, Education and Development Conference

Další údaje

Jazyk

angličtina

Typ výsledku

Stať ve sborníku

Obor

10201 Computer sciences, information science, bioinformatics

Stát vydavatele

Španělsko

Utajení

není předmětem státního či obchodního tajemství

Forma vydání

elektronická verze "online"

Odkazy

URL

Kód RIV

RIV/00216224:14560/23:00130647

Organizační jednotka

Ekonomicko-správní fakulta

ISBN

978-84-09-49026-4

ISSN

DOI

http://dx.doi.org/10.21125/inted.2023.0288

Klíčová slova anglicky

LAMBDA function; User Defined Functions; Business Analytics

Příznaky

Mezinárodní význam, Recenzováno

Změněno: 30. 1. 2024 18:50, doc. Mgr. Maria Králová, Ph.D.

Anotace

V originále

Increasing number of companies are becoming aware of competitive advantage of business intelligence implementation in business processes and decision-making. However, due to a shortage of data scientists and experts in business analytics in the labour market, small and medium companies face difficulties developing their analytical departments. Very often, the employees who are not programmers, though skilled in Excel, are asked to focus on analytical data-related tasks. Then the need to develop customized functions for efficient routine data processing becomes necessary. Within Excel, the VBA (Visual Basic for Application) programming language can be used to program customized functions. However, there are three difficulties to cope with. First, VBA expects macros allowed in excel, which is even in Microsoft's default setting blocked. Second, many companies and institutions block macros from running for security reasons. Finally, developing and testing own function may be time-consuming and challenging for nonprogrammers. Using the LAMBDA function is an elegant way to develop new customized functions quickly and effectively without any programming experience. The article describes utilizing the LAMBDA function to create and test a new function. Last but not least, it will be presented how to insert this function into a defined name so that the result will be a standard function that, at first glance, is unrecognizable from a standard Microsoft function or a function created via VBA. In a learning process, there are other advantages. Understanding of the role of parameters and easy debugging in the workbook sheet is easily accessible for nonprogrammers and, in addition, allows a smooth transition to VBA. Practical examples of the development of own functions will be provided to demonstrate the utilization of the LAMBDA function. The examples will cover a broader range of applications, from, e.g., mimicking LPAD and RPAD functions known from SQL to computational routines. The Lambda function represents an easily accessible tool for nonprogrammers allowing its fast implementation in modern corporate business analytics practice.

Citovat

LASÁK, Pavel a Maria KRÁLOVÁ. LAMBDA FUNCTION IN EXCEL IN RESPONSE TO CHALLENGES OF NONPROGRAMMERS IN MODERN CORPORATE PRACTICE. Online. In INTED2023 Proceedings. Valencia, Spain: 17th International Technology, Education and Development Conference, 2023, s. 931-937. ISBN 978-84-09-49026-4. Dostupné z: https://dx.doi.org/10.21125/inted.2023.0288.

@inproceedings{2278038,
   author = {Lasák, Pavel and Králová, Maria},
   address = {Valencia, Spain},
   booktitle = {INTED2023 Proceedings},
   doi = {http://dx.doi.org/10.21125/inted.2023.0288},
   keywords = {LAMBDA function; User Defined Functions; Business Analytics},
   howpublished = {elektronická verze "online"},
   language = {eng},
   location = {Valencia, Spain},
   isbn = {978-84-09-49026-4},
   pages = {931-937},
   publisher = {17th International Technology, Education and Development Conference},
   title = {LAMBDA FUNCTION IN EXCEL IN RESPONSE TO CHALLENGES OF NONPROGRAMMERS IN MODERN CORPORATE PRACTICE},
   url = {https://library.iated.org/view/LASAK2023LAM},
   year = {2023}
}

TY  - JOUR
ID  - 2278038
AU  - Lasák, Pavel - Králová, Maria
PY  - 2023
TI  - LAMBDA FUNCTION IN EXCEL IN RESPONSE TO CHALLENGES OF NONPROGRAMMERS IN MODERN CORPORATE PRACTICE
PB  - 17th International Technology, Education and Development Conference
CY  - Valencia, Spain
SN  - 9788409490264
KW  - LAMBDA function
KW  - User Defined Functions
KW  - Business Analytics
UR  - https://library.iated.org/view/LASAK2023LAM
N2  - Increasing number of companies are becoming aware of competitive advantage of business intelligence implementation in business processes and decision-making. However, due to a shortage of data scientists and experts in business analytics in the labour market, small and medium companies face difficulties developing their analytical departments. Very often, the employees who are not programmers, though skilled in Excel, are asked to focus on analytical data-related tasks. Then the need to develop customized functions for efficient routine data processing becomes necessary. Within Excel, the VBA (Visual Basic for Application) programming language can be used to program customized functions. However, there are three difficulties to cope with. First, VBA expects macros allowed in excel, which is even in Microsoft's default setting blocked. Second, many companies and institutions block macros from running for security reasons. Finally, developing and testing own function may be time-consuming and challenging for nonprogrammers. Using the LAMBDA function is an elegant way to develop new customized functions quickly and effectively without any programming experience. The article describes utilizing the LAMBDA function to create and test a new function. Last but not least, it will be presented how to insert this function into a defined name so that the result will be a standard function that, at first glance, is unrecognizable from a standard Microsoft function or a function created via VBA. In a learning process, there are other advantages. Understanding of the role of parameters and easy debugging in the workbook sheet is easily accessible for nonprogrammers and, in addition, allows a smooth transition to VBA. Practical examples of the development of own functions will be provided to demonstrate the utilization of the LAMBDA function. The examples will cover a broader range of applications, from, e.g., mimicking LPAD and RPAD functions known from SQL to computational routines. The Lambda function represents an easily accessible tool for nonprogrammers allowing its fast implementation in modern corporate business analytics practice.
ER  -

LASÁK, Pavel a Maria KRÁLOVÁ. LAMBDA FUNCTION IN EXCEL IN RESPONSE TO CHALLENGES OF NONPROGRAMMERS IN MODERN CORPORATE PRACTICE. Online. In \textit{INTED2023 Proceedings}. Valencia, Spain: 17th International Technology, Education and Development Conference, 2023, s.~931-937. ISBN~978-84-09-49026-4. Dostupné z: https://dx.doi.org/10.21125/inted.2023.0288.

Podrobný výpis o publikaci