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

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.

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

Please click hier to read the original German version.

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

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
Online Training

Duration 2 days

Price (excl. tax)
  • 790.— €

Courseware language: German

Classroom Training

Duration 2 days

Price (excl. tax)
  • Germany: 790.— €
incl. catering

Courseware language: German

 

Schedule

Instructor-led Online Training:   Course conducted online in a virtual classroom.
English
Time zone: Central European Time (CET)   ±1 hour
Online Training Time zone: Central European Time (CET)
Online Training Time zone: Central European Time (CET)
Online Training Time zone: Central European Summer Time (CEST)
Online Training Time zone: Central European Summer Time (CEST)
Online Training Time zone: Central European Summer Time (CEST)
Online Training Time zone: Central European Summer Time (CEST)