Contents
- Use important laws of perception for the concise design of tables and diagrams.
- Create and configure standard diagrams with just a few mouse clicks.
- Highlight important data in tables and charts with conditional formatting.
- Minimize the effort involved in designing diagrams with color designs and diagram templates.
- Use table and cell format templates for the consistent design of tables.
Please note:
The module is part of the webinar series "Excel snacks in controlling" and cannot be booked individually. Select a total of four "Excel snacks" and improve your Excel knowledge in a targeted manner.
Learning environment
Once you have registered, you will find useful information, downloads and extra services relating to this training course in your online learning environment.
Your benefit
- You will receive a brief and concise overview of the topic and compact knowledge of important design rules for the presentation of quantitative data.
- You will learn how to systematically build the tabular basis in order to create diagrams with just a few mouse clicks or keyboard shortcuts.
- You will learn how to design tables and charts efficiently using colour designs and templates and how to standardize the visualization in your reports.
- You will learn how to use conditional formatting in tables to highlight table contents or filter table contents.
- The webinar will take place live and you will have the opportunity to ask your questions and benefit from the discussions in the group.
Methods
Live online webinar with presentation, discussion of sample solutions, tips and tricks, question and answer session.
Recommended for
The webinar is suitable for controllers who have a sound knowledge of Excel and would like to expand their Excel knowledge in a targeted and customized manner.
Start dates and details

Monday, 02.06.2025
4:00 pm - 5:30 pm

Wednesday, 17.09.2025
4:00 pm - 5:30 pm