We are happy to advise you!
+49 40 253346-10     Contact

Microsoft Excel 2019 for Advanced Users (E19F)


Course Overview

Use names and special functions, create professional charts, perform complex analyses using pivot tables and Microsoft Query queries, and much more: With the help of this book, you will learn how to analyze and visualize your data quickly and professionally. The advanced Excel techniques required for this are explained in an easy-to-understand manner using concrete practical examples with many visualizations.

  • Use names and table ranges
  • Use special functions (e.g. IF and VERWEIS)
  • Perform time calculations
  • Create professional diagrams
  • Combine and consolidate data
  • Working with Pivot Tables
  • Import or export data
  • Creating Power Query Queries

Tailored to the learning topics in "Excel 2019 - Advanced course compact", with BuchPlus you receive a comprehensive, digital media package with learning videos, accompanying files, knowledge tests, further exercises, supplementary learning content and quick overviews of the most important commands.

Note: This text was automatically translated and may contain errors.

Please click here to read the original German version.

Course Content

  • 1 Names
  • 2 Using special functions
  • 3 Perform time calculations
  • 4 Edit diagrams individually
  • 5 Working professionally with diagrams
  • 6 Combine and consolidate data
  • 7 Create Pivot Tables
  • 8 Import or export data
  • 9 Creating Queries with Power Query
  • 10 Special design options
  • 11 Table areas
  • 12 Set up Excel individually
Online Training

Duration 2 days

Price (excl. tax)
  • 890.— €

Courseware language: German

Classroom Training

Duration 2 days

Price (excl. tax)
  • Germany: 890.— €
  • Switzerland: CHF 1,130.—
incl. catering

Courseware language: German



This class will become guaranteed to run with one more student registration.
Instructor-led Online Training:   Course conducted online in a virtual classroom.
Time zone: Central European Summer Time (CEST)   ±1 hour
Online Training Time zone: Central European Summer Time (CEST)
Online Training Time zone: Central European Summer Time (CEST)
Online Training Time zone: Central European Time (CET)
X Contact Contact