Professional training – Microsoft 365 and Office

Excel Charts and Dashboards

Excel Charts and Dashboards in 6 focused hours: Chart types and selection, Combination charts and Sparklines – practical, with exercises and templates for your daily work.

Duration
6 hours, one session
Level
Intermediate
Format
Online or on-site
Language
German or English
Certificate
Certificate of attendance

Overview

“Excel Charts and Dashboards” is a compact live course in the field of Microsoft 365 and Office. It centres on Chart types and selection, Combination charts and Sparklines – explained with realistic examples and deepened in exercises you can transfer straight to your daily work.

Microsoft 365 is part of almost every office routine, yet most employees use only a fraction of what it offers. Our Office courses focus on the features that save time: from Excel formulas and pivot analyses to professional documents, collaboration in Teams, SharePoint and Planner, and automation with Power Automate. Excel Charts and Dashboards is a one-day workshop with short explanations and plenty of exercises on practical tasks. You receive exercise files, keyboard shortcuts and templates for immediate use in your daily work.

The course is delivered live – either online in a virtual classroom or on-site in our training rooms in Munich, Salzburg, Berlin, Augsburg, Hanover, Bremen, Stuttgart and Kaiserslautern. We can also run it exclusively for your team.

Focus areas of the course

Chart types and selectionCombination chartsSparklinesSlicersDynamic dashboardsDesign and readability

Who is this course for?

  • Administrative staff and assistants
  • Controllers, project managers and team leads
  • Business users in all departments
  • IT owners and Microsoft 365 administrators

What you will be able to do

  • You know the key topics of Excel Charts and Dashboards – Chart types and selection, Combination charts, Sparklines, Slicers, Dynamic dashboards and Design and readability – and can apply them in practice.
  • You work noticeably faster and more reliably with Excel Charts and Dashboards.
  • You use features deliberately for recurring tasks.
  • You design results professionally and consistently.
  • You share and collaborate in a data-protection-compliant way.

Course outline

Module 1 Getting started and interface of Excel Charts and Dashboards
  • Where Excel Charts and Dashboards fits in Microsoft 365
  • Interface, ribbon and quick access toolbar
  • Navigating efficiently with keyboard shortcuts
  • Exercise files and practical examples
Module 2 Focus areas: Excel Charts and Dashboards
  • Chart types and selection
  • Combination charts
  • Sparklines
  • Slicers
  • Dynamic dashboards
  • Design and readability
Module 3 Core features of Excel Charts and Dashboards
  • The most important functions step by step
  • Working in a structured and low-error way
  • Formatting, templates and standards
  • Avoiding common pitfalls
Module 4 Hands-on exercises with Excel Charts and Dashboards
  • Guided exercises on everyday office tasks
  • Bringing and solving your own work examples
  • Time-saving workflows and automation
  • Questions and solutions in the group
Module 5 Collaboration, security and transfer
  • Sharing, permissions and co-authoring
  • Data protection and safe file handling
  • Integration with other Microsoft 365 services
  • Checklist for your daily work
Module 6 Transfer to your daily work
  • Exercise based on a realistic case
  • Typical mistakes and how to avoid them
  • Checklist and templates to take away
  • Open questions, outlook and resources for further learning

Prerequisites

Depending on the level, basic PC skills are enough. Advanced courses assume confident use of the basic functions. Basic knowledge of the topic is helpful.

Technical requirements

Your own laptop with internet access; Microsoft 365 access or a training environment is provided in advance.

Dates & locations

For every location we suggest a date roughly four weeks ahead. Your preferred date is always possible.

  • Munich Thu, 10 December 2026 6 hrs Request
  • Salzburg Wed, 16 December 2026 6 hrs Request
  • Berlin Wed, 16 December 2026 6 hrs Request
  • Augsburg Tue, 15 December 2026 6 hrs Request
  • Hanover Thu, 10 December 2026 6 hrs Request
  • Bremen Wed, 16 December 2026 6 hrs Request
  • Stuttgart Wed, 16 December 2026 6 hrs Request
  • Kaiserslautern Mon, 14 December 2026 6 hrs Request
  • Online Fri, 11 December 2026 6 hrs Request

Frequently asked questions

Which version of Microsoft 365 is required for Excel Charts and Dashboards?

We follow the version your company uses and point out differences between the desktop and web versions. Features that are only available in certain licenses are marked as such. Tell us about your environment in advance so we can prepare the content accordingly.

Can we work with our own files in Excel Charts and Dashboards?

Yes, gladly. For in-house sessions we include your templates, spreadsheets or processes, provided they contain no confidential content or are anonymized. Alternatively we use practical exercise files that cover all the learning content.

How much does “Excel Charts and Dashboards” cost?

The course costs a flat €949 plus VAT per participant – whether online or on-site. This includes 6 hours of live training with a trainer, course materials, a lab environment and a certificate of attendance.

Can I suggest my own date?

Yes. For every location we suggest a date roughly four weeks ahead. In the request form you can always describe your preferred date or period in free text – we check availability and get back to you within one working day.

Is the course online or on-site?

Both are possible: live online in a virtual classroom or on-site in Munich, Salzburg, Berlin, Augsburg, Hanover, Bremen, Stuttgart and Kaiserslautern. We can also run the course exclusively for your team.

Can the course be tailored to our team?

Yes. Tailor-made courses cost approx. €4,500 more, depending on the topic and by arrangement. We agree content, examples and exercises with you in advance.

More courses in Microsoft 365 and Office

All 29 courses in Microsoft 365 and Office