Excel Workshop with Martin Bien (Frankfurt am Main/Hesse)
Working with spreadsheets isn't everyone's cup of tea. Yet in the day-to-day production work of the independent performing arts scene, everyone involved inevitably finds themselves facing the dreaded numbers – either at the very beginning of a project or, at the latest, once the performances are over. From the funding application to the final financial report, from the initial idea to the exhausted days after the performances: every unique, publicly funded artistic project ultimately ends up taking on a very generic form – the spreadsheet.
With his three-part Excel workshop, Martin Bien invites participants to an anti-aggression training session and takes a seat at the table – the budgeting table, that is.
Dinner will be served — at the table!
10:00–11:00 a.m. | Starter: Getting to know each other
Filtering, sorting, formatting, adding things up – sounds great, but how do I actually do it?
In this first session, we will familiarise ourselves with the interface of a spreadsheet programme (in this case, Google Sheets), which we will be using throughout the workshop. We will try out some basic functions for displaying, calculating and budgeting data.
11:15 a.m.–2:15 p.m. | Main course: Diving in (including a 30-minute digestion break)
I have an artistic project I want to realise – but how do I turn it into a cost and financing plan? And how can I keep track of my funding budget throughout the rehearsal period?
In this session, Martin will introduce selected basic functions and demonstrate how to set up a budget monitoring system in just a few steps. This will allow you to keep track of exactly how much funding you have left at any given time. The system also provides relevant data for preparing the financial reports required for the final accounting.
The Google Sheets functions covered in this part of the workshop include SUMIF/SUMIFS, IF/IFS, VLOOKUP and nested formulas.
2:30–3:00 p.m. | Dessert: Sharing and exchanging ideas
I have a particular way of working with Excel, but I keep running into the same problem. How can I solve it?
This is where Excel wishes come true! Together with Martin and the other participants, you will have access to a wealth of practical Excel knowledge. Bring along a specific problem or challenge related to budget monitoring in the independent performing arts, and together we will find suitable solutions to make your everyday spreadsheet work a little more enjoyable.
Bon appétit!
Important information for participants
What to bring: Please bring your laptop and charger, as well as any questions you may have about working with Excel.
Wi-Fi: To work together during the workshop, your laptop must be able to connect to the Wi-Fi network at Tanz- und Theaterbüro München.
Language: The workshop will be conducted in spoken German. Contributions in spoken English are always very welcome.
Working tool: We will use Google Sheets during the workshop to enable participants to work simultaneously in a shared document. You do not need your own Google account. No sensitive data will be shared in Google Sheets; we will work with fictional sample data.
Materials: Martin will provide each participant with templates that can be individually adapted to their own needs and used freely after the workshop. The templates can also easily be exported as Excel files.
Working together: The workshop is primarily designed to be interactive. Martin will introduce his approach, which participants can then try out themselves using the provided templates. Questions are welcome at any point during the workshop. Martin hopes that participants will support one another and share their experiences and knowledge of working with spreadsheets, drawing on their different levels of Excel experience.
Registration: If you realise after registering that you are unable to attend the workshop after all, please let us know as soon as possible so that your place can be offered to someone on the waiting list.
About Martin Bien | he/him | www.martinbien.de
Martin Bien is a producer in the independent performing arts and a member of produktionsbande, a Germany-based network for professionals working in this field.
He currently heads the Funding Administration department at World Design Capital Frankfurt RheinMain 2026. From the funding body's perspective, he oversees more than 350 funded projects, supporting them throughout the entire process – from the initial funding application and the conclusion of funding agreements to the final financial report.
He completed vocational training as an office administrator and studied Applied Theatre Studies in Giessen. In his work, he is particularly interested in the often-overlooked intersection of administration and communication.
19 February 2027 | 10:00 a.m.–3:00 p.m.
Location: Tanz- und Theaterbüro München office – unfortunately, not wheelchair accessible.
Language: Spoken German.
.png)