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.

This text was automatically translated. 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

Prices & Delivery methods

Online Training

Duration
2 days

Price
  • 890.— €

Courseware language: German

Classroom Training

Duration
2 days

Price
  • Germany: 890.— €
  • Switzerland: CHF 1,130.—

Courseware language: German

Schedule

Instructor-led Online Training:   Course conducted online in a virtual classroom.
FLEX Classroom Training (hybrid course):   Course participation either on-site in the classroom or online from the workplace or from home.

German

Time zone: Central European Time (CET)   ±1 hour

Online Training Time zone: Central European Summer Time (CEST) Course language: German
Online Training
Classroom option: Berlin
Time zone: Central European Summer Time (CEST) Course language: German
Online Training Time zone: Central European Summer Time (CEST) Course language: German
Online Training Time zone: Central European Summer Time (CEST) Course language: German
Online Training
Classroom option: Frankfurt
Time zone: Central European Summer Time (CEST) Course language: German
Online Training Time zone: Central European Time (CET) Course language: German
FLEX Classroom Training (hybrid course):   Course participation either on-site in the classroom or online from the workplace or from home.

Germany

Berlin Course language: German
Frankfurt Course language: German

If you can't find a suitable date, don't forget to check our world-wide FLEX training schedule.