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.
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
German
Germany
This text was automatically translated. Please click here to read the original German version.
This training includes: