Main Content

Management Accounting with Excel (Winter 2018/19)

[Course language: English]

The Management Accounting Research Group is offering a practical introduction to Microsoft Excel in a Management Accounting setting.

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 Monte Carlo Simulation are implemented. The results of these forecasts are then used to prepare a reporting summary for the executive.

The course is open for bachelor- and master students. 

Registration and Schedule:

Please note: Participation is only possible with a printed script, which is available for 50 €

For registration please follow the following procedure:

1.      Send your CV and an up-to-date transcript of records to Johannes Beyenbach ( not later than 22nd of October, 2018

2.      After the acceptance: Pay the fee (50 €) for the printed script till 5th of November (instructions will be send with your acceptance)

The course will take place on 16th of November (voluntary) and 21st-23rd of November 2018. The course can be credited as "key skills" ("Schlüsselqualifikationen").
For a detailed time schedule and venues please see the syllabus here.