engleski

Methodological Framework Of Learning Financial Modeling Within Excel Spreadsheet Interface

Spreadsheet is considered to be a tool for understanding and learning financial modelling. In understanding and learning the financial models there has been suggested methodological frame for usage of spreadsheets, based on the method of visualization. The possibilities to configure and organize groups of address areas in connection to the powerful financial functions has automatized complex financial formula and largely created assumptions for making the problems and creation of financial models simpler. The visualization model is actually considering the context of learning how to create financial functions and form complex financial models on more simple way and comprehensible to the user. Basic assumption of this study refers to the fact that by systematical and methodological approach of learning spreadsheets in financial modelling the usability of spreadsheets potential could be significantly increased. The objective is to orient usability focused on simpler spreadsheet financial calculations towards more complex financial models.

Financial modelling ; spreadsheets ; Visual basic ; end user function ; framework

nije evidentirano