Contents
- Display types and options for Excel dashboards.
- Conception of your own presentation.
- Preparation of data for dashboards.
- Use user-defined formatting.
- Use conditional formatting.
- Use Sparklines.
- Use diagrams.
- Use data slices.
- Tips and tricks for using Microsoft Copilot.
Learning environment
Your benefit
With the content from this practical seminar, you will demonstrate professionalism and performance and also increase your personal professional success, because you will learn:
- use Excel dashboards to present figure-based information in a clear and compact way in order to provide information quickly or prepare figure-based decisions,
- use graphic symbols to show a progression or status in a way that can be quickly understood (e.g. speedometer, progress bar or colored indicators),
- also use more complex elements such as diagrams or tables to display KPIs, business figures, project progress, etc,
- To present figures and data quickly and in a graphically appealing way, because time is always short for decision makers .
Methods
experts, practical tasks and exercises. Please use a notebook/PC with the Microsoft Office program (version 2016/2019/2021/O365) for Windows installed.
We recommend working with two screens in order to participate optimally in the training.
Recommended for
Anyone who works with Microsoft Excel 2016/2019/2021/O365 or the corresponding Microsoft Office versions for Windows and wants to impress with professional Excel dashboards.
Knowledge of Excel, especially with formulas and functions, is a prerequisite.
Further recommendations for "Microsoft Excel: Working and presenting successfully with dashboards"
Seminar evaluation for "Microsoft Excel: Working and presenting successfully with dashboards"







Start dates and details

Friday, 07.11.2025
09:00 am - 5:00 pm

Wednesday, 22.04.2026
09:00 am - 5:00 pm