Main Content
Controlling (Management Accounting) with Excel
[Course language: English]
The Management Accounting Research Group offers a practical introduction to Microsoft Excel in a management accounting setting.
The course is open for bachelor- and master students.
Grading:
This workshop serves as the grades component of the module "Controlling mit Excel und Unternehmensbewertung in der Praxis". Therefore, it must be grouped together with the workshop "Planspiel Unternehmensbewertung" of the Finance and Banking research group of Professor Nietert for a 6 ECTS elective credit.
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.
Schedule:
Kickoff Time: Tuesday, 20th October 2:00-4:00 p.m. | Location: PC Pool - 00047 (Schulungsraum WiWi-Pavillon, 047) (Universitätsstraße 25, Pavillon (U | 06))
Course schedule will be disclosed in the kickoff session. Please check MARVIN and the semester calendar for special dates when the university is closed and no teaching events are held.
Please note:
The number of participants is limited to 30 – first come first serve principle! Please register in MARVIN!
Excel files used in the class can be downloaded as the course progresses from ILIAS.