Main Content

Management Accounting with Excel

[Course language: English]

The Management Accounting Research Group is offering a practical introduction to Microsoft Excel in a Management Accounting setting.
The course is open for bachelor- and master students. 

Grading:

The course grade will be based on student term paper. As part of the AMA-IV module 3 ECTS can be credited (graded). Besides that, it is creditable as “Schlüsselqualifikation” (ungraded).

Please note:
Students enrolled in the Master in "Quantitative Accounting and Finance" and are the subject to the "old" examination regulation can credit the course as “Schlüsselqualifikation” only.

Objective and course style:

The course aims at familiarizing students with Microsoft Excel as a very useful tool for management accounting applications. After a detailed overview of basic Excel functions as well as its fundamental formulas, students will learn to apply them to real world management accounting problems. The practical application is centered on a young, but running company, with three years of operating track record. Students will learn to model a basic profit & loss statement, cash flow statement and balance sheet for the business. Furthermore, for future planning, univariate regression analysis and further advanced techniques are implemented. The results of these forecasts are then used to prepare a reporting summary for the executive.

Registration and Schedule:

For registration please follow the following procedure: Send your CV and an up-to-date transcript of records to Andrew Reek () by November 1st, 2021.

Please note:
The number of participants is limited to 25 – first come first serve principle!
Excel files used in the class can be downloaded as the course progresses from ILIAS.
Students are required to install Excel 2013 on the laptop.
The course will take place online over Zoom.
The course syllabus can be found here.