Microsoft Excel 365 for Advanced Users (E365F)

 

Course Overview

Use names and conditional formatting, work with database functions and the special filter, perform complex analyses using pivot tables and matrices, and much more: With the help of the book "Excel 2019 - Advanced Techniques" 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.

  • Insert name
  • Structure tables
  • Use individual conditional formatting
  • Combine and consolidate data
  • Create and customize complex pivot tables
  • Analyze data (e.g. with special filters, trend analyses, data tables, target value search, solver, scenario manager and matrices) Visualize data professionally with charts and illustrations
  • Import data (e.g. with Power Query) or export data

Tailored to the learning topics in "Excel 2019 - Advanced Techniques", BuchPlus gives you a comprehensive digital media package with learning videos, companion files, knowledge tests, further exercises, additional learning content and quick overviews of the most important commands.

This text was automatically translated. Please click here to read the original German version.

This text was automatically translated. Please click here to read the original German version.

Course Content

  • 1 Names
  • 2 Structure tables
  • 3 Link formatting to conditions
  • 4 Monitor formulas and cell contents
  • 5 Special filters
  • 6 Excel databases
  • 7 Combine and consolidate data
  • 8 Create Pivot Tables
  • 9 Customize Pivot Tables
  • 10 Trend analyses, data tables, target value search
  • 11 Solver
  • 12 scenarios
  • 13 Matrices
  • 14 Different diagram types
  • 15 Working professionally with diagrams
  • 16 Design tables with illustrations
  • 17 Importing or exporting data
  • 18 Creating Queries with Power Query
  • 19 Working in a team

Prices & Delivery methods

Online Training

Duration
2 days

Price
  • 890.— €

Courseware language: German

Classroom Training

Duration
2 days

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

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 Time (CET) Course language: German
Online Training
Classroom option: Hamburg
Time zone: Central European Time (CET) Course language: German
Online Training
Classroom option: Berlin
Time zone: Central European Time (CET) Course language: German
Online Training
Classroom option: Berlin
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
Classroom option: Frankfurt
Time zone: Central European Summer Time (CEST) Course language: German
Online Training
Classroom option: Munich
Time zone: Central European Summer Time (CEST) 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

Hamburg Course language: German
Berlin Course language: German
Berlin Course language: German
Berlin Course language: German
Frankfurt Course language: German
Munich Course language: German

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