About this paper

Appears in:
Pages: 7562-7571
Publication year: 2018
ISBN: 978-84-697-9480-7
ISSN: 2340-1079
doi: 10.21125/inted.2018.1789

Conference name: 12th International Technology, Education and Development Conference
Dates: 5-7 March, 2018
Location: Valencia, Spain

MS EXCEL IN MANAGEMENT ACCOUNTANTS EDUCATION. EXAMPLES OF THE GOAL SEEKING TOOL APPLICATION

A. Januszewski

UTP University of Science and Technology (POLAND)
Ms Excel spreadsheet plays an important role for managerial accountants and it is necessary tool for traditional responsibilities such as planning, budgeting, forecasting as well as newer decision-making responsibilities. The importance of spreadsheet is appreciated by employers, who treat spreadsheet skills as a necessary condition for new hires. That is proved by many scientific research results. In the last years such research was conducted e.g. by Ragland and Ramachandran [2014], who prepared the list of 14 Ms Excel functions and tools, a profound knowledge of how to use them is greatly desired by employers. The list encompasses such tools as pivot tables, scenario manager and solver, however it does not include a goal-seeking tool, which, according to many years of the author’s experience, is not only very user-friendly but also very useful for management accounting problem-solving.

The aim of the article is to present the use of a goal-seeking tool in management accounting education with examples from “management accounting” of management syllabi at the Faculty of Management, the UTP University of Science and Technology in Bydgoszcz, Poland.

The first part of the article provides the research results referring to the Ms Excel importance for management accounting education. Then, topics in “Management accounting” course in laboratory classes as well as educational effects in terms of knowledge, skills and social competencies are given. In the last and the most important part of the article two examples of using the goal-seeking tool are presented. The first example concerns the use of that tool in profit planning whereas the second one deals with break-even point analysis.

According to the author, the goal-seeking tool application examples demonstrated in the article explain the tool concept and how the tool can be easily adopted to the specific condition in a lot of enterprises.
@InProceedings{JANUSZEWSKI2018MSE,
author = {Januszewski, A.},
title = {MS EXCEL IN MANAGEMENT ACCOUNTANTS EDUCATION. EXAMPLES OF THE GOAL SEEKING TOOL APPLICATION},
series = {12th International Technology, Education and Development Conference},
booktitle = {INTED2018 Proceedings},
isbn = {978-84-697-9480-7},
issn = {2340-1079},
doi = {10.21125/inted.2018.1789},
url = {http://dx.doi.org/10.21125/inted.2018.1789},
publisher = {IATED},
location = {Valencia, Spain},
month = {5-7 March, 2018},
year = {2018},
pages = {7562-7571}}
TY - CONF
AU - A. Januszewski
TI - MS EXCEL IN MANAGEMENT ACCOUNTANTS EDUCATION. EXAMPLES OF THE GOAL SEEKING TOOL APPLICATION
SN - 978-84-697-9480-7/2340-1079
DO - 10.21125/inted.2018.1789
PY - 2018
Y1 - 5-7 March, 2018
CI - Valencia, Spain
JO - 12th International Technology, Education and Development Conference
JA - INTED2018 Proceedings
SP - 7562
EP - 7571
ER -
A. Januszewski (2018) MS EXCEL IN MANAGEMENT ACCOUNTANTS EDUCATION. EXAMPLES OF THE GOAL SEEKING TOOL APPLICATION, INTED2018 Proceedings, pp. 7562-7571.
User:
Pass: