Microsoft Excel 365 Compact (E365K)

 

Course Overview

Learn with this compact course quickly and without ballast, how you can easily perform calculations with Excel and create meaningful tables and charts. Supported by easy-to-understand, practical examples and tips, we show you how to work cleverly and goal-oriented with Excel.

Already on the first pages you will learn all the basic aspects of Excel with the help of an easy-to-follow example, e.g. entering, calculating and formatting data, creating descriptive diagrams and saving and printing tables. Thus, after the first chapter, you will not only have understood the basics of working with Excel, but also experienced them in practice.

After this quick sense of achievement and the basic overview of the possibilities of Excel, you will gradually learn all Excel features that can be of importance in later practice - from the use of formulas and functions to sorting and filtering. In this way, you can easily expand your Excel skills step by step according to your personal requirements. In addition, "Excel 2019 - Basic course compact" also provides you with valuable services as a quick reference book time and again.

  • Basics of table editing
  • Format cells
  • Working with formulas and functions
  • Create diagrams
  • Manage and print workbooks
  • Sort and filter data

Tailored to the learning topics in "Excel 2019 - Basic course compact", with BuchPlus you receive a comprehensive, digital media package with learning videos, accompanying 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 training includes:

Course Content

Microsoft Excel 365 for beginners
  • 1 Get to know Excel
  • 2 Basic techniques
  • 3 Working with formulas
  • 4 Format cells
  • 5 Fill, Copy and Move
  • 6 Edit table view and structure
  • 7 Working with simple functions
  • 8 Create and design diagrams
  • 9 Print tables with individual settings
  • 10 Use workbooks effectively
  • 11 Sort and filter data
Microsoft Excel 365 for advanced users
  • 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
3 days

Price
  • 1,290.— €

Courseware language: German

Classroom Training

Duration
3 days

Price
  • Germany: 1,290.— €
  • Switzerland: CHF 1,650.—

Courseware language: German

Schedule

This computer icon in the schedule indicates that this date/time will be conducted as Instructor-Led Online Training.
This is a FLEX course, which is delivered both virtually and in the classroom. All FLEX courses are also Instructor-led Online Trainings (ILO).

German

Time zone: Central European Summer Time (CEST)   ±1 hour

Online Training Time zone: Central European Time (CET) Course language: German
Online Training Time zone: Central European Time (CET) Course language: German
Online Training
Classroom option: Frankfurt
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
This is a FLEX course, which is delivered both virtually and in the classroom. All FLEX courses are also Instructor-led Online Trainings (ILO).

Germany

Frankfurt Course language: German
Berlin Course language: German

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