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.
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
German
Germany
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.