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).

Objective and course style:

The course aims at familiarizing students with Microsoft Excel as a 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. 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 an 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 October 25th, 2022.

The course kickoff takes place on October 25th at the Landgrafenhaus, room +3/0210 at 4:00 p.m.

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.