Course Features
- workspace_premium Certified by TÜV Rheinland
- calendar_month Lifetime Access
- trending_up Course Level: Intermediate
- timelapse Learning Extent: 8 hrs. 00 min.
- language Language: english
Course Overview
About this online Course
The learning program is aimed at users who use MS Excel for demanding calculations or for data evaluation. Deepen your knowledge of formulas and functions and learn how to use conditional formatting or range names to simplify the construction of complex calculations. One focus of the learning program deals with the import and preparation of (data) lists or tables for data analysis. From simple (table) filters to sophisticated pivot tables, you will learn how easy and effective data analysis in Excel can be. You will also learn how to share workbooks in a team and how to protect your data appropriately.
Beyond the general applications of Excel 2016, this e-Learning will teach you how to use sophisticated pivot tables and how to use Excel for effective data analysis.
Target group
Users who are familiar with the basics of MS Excel and want to deepen their knowledge.
Learning content
- Worksheets
- Formulas
- Excel functions
- Working with tables
- Data import
- PivotTables
- Working with diagrams
- Workbooks in a team
Learning Contents
Summary of Learning Contents
Excel 2016 Advanced
-
Excel 2016 Advancedextension interactive contenttimelapse 8 hrs. 00 min.
Ratings
Overall Rating
Reviews
from {{ rating.user.display_name }} am {{ rating.created_at | formatDate }}
Questions & Discuss
Comments and Questions about the course
Do you have any general questions about the course? Would you like to get a more detailed picture of the structure of the course? Whether you want to share your own experiences with the learning community or have questions about a specific content: Feel free to join the discussions with other learners on this course.