Przykład zastosowania tabel przestawnych w arkuszu kalkulacyjnym na zajęciach z zakresu rachunkowości zarządczej

Zdzisław Kes

Abstract

The article describes an example of using pivot tables of MS Excel in the classroom with management accounting. These classes are conducted under the bachelor studies in finance and accounting on Faculty of Management, Computer Science and Finance in The University of Economics in Wroclaw. Information technology in the teaching of that subject is one of the main aspects taken into consideration during the preparation of teaching units for teachers. The described example contains a number of important functions use of pivot tables for management accounting. More than the author drew attention to the problems with the data structure used for sales analysis.
Author Zdzisław Kes (MISaF / IR / KRC)
Zdzisław Kes,,
- Katedra Rachunku Kosztów, Rachunkowości Zarządczej i Controllingu
Journal seriesFolia Pomeranae Universitatis Technologiae Stetinensis. Oeconomica, ISSN 2081-0644, e-ISSN 2300-5386, (B 9 pkt)
Issue year2012
No294 (67)
Pages97-106
Keywords in PolishMS Excel, rachunkowość zarządcza, tabele przestawne
Keywords in Englishmanagement accounting, MS Excel, pivot tables
URL http://www.wydawnictwo.zut.edu.pl/files/magazines/2/34/390.pdf
Languagepl polski
LicenseJournal (articles only); author's original; Uznanie Autorstwa - Użycie Niekomercyjne (CC-BY-NC); after publication
File
Kes_Przyklad_zastosowania_tabel_przestawnych_w_2012.pdf 515,44 KB
Score (nominal)5
Citation count*
Cite
Share Share

Get link to the record


* presented citation count is obtained through Internet information analysis and it is close to the number calculated by the Publish or Perish system.
Back