Course Overview
Use names and special functions, create professional charts, perform complex analyses using pivot tables and Microsoft Query queries, and much more: With the help of this book, 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.
- Use names and table ranges
- Use special functions (e.g. IF and VERWEIS)
- Perform time calculations
- Create professional diagrams
- Combine and consolidate data
- Working with Pivot Tables
- Import or export data
- Creating Power Query Queries
Tailored to the learning topics in "Excel 2019 - Advanced course compact", with BuchPlus you receive a comprehensive, digital media package with learning videos, accompanying files, knowledge tests, further exercises, supplementary learning content and quick overviews of the most important commands.
Course Content
- 1 Names
- 2 Using special functions
- 3 Perform time calculations
- 4 Edit diagrams individually
- 5 Working professionally with diagrams
- 6 Combine and consolidate data
- 7 Create Pivot Tables
- 8 Import or export data
- 9 Creating Queries with Power Query
- 10 Special design options
- 11 Table areas
- 12 Set up Excel individually
This text was automatically translated. Please click here to read the original German version.