Course Features
- assignment_turned_in Certified by TÜV Rheinland
- access_time Lifetime Access
- trending_up Course Level: Intermediate
- timelapse Learning Extent: 10 hrs. 00 min.
- language Language: english
Course Overview
About this online Course
The tutorial is meant for those who use Microsoft Excel for complex calculations or for analysing data. Gain an in-depth understanding of formulas and functions and learn how conditional formatting or range names make it easy to structure complex calculations. The tutorial also focuses on importing and processing of (data) lists, or tables for analysing data. The tutorial explains how easy and effective it is to analyse data in Excel right from simple (table) filters to complex pivot tables. You also learn how to share workbooks in a team and adequately protect your data in the process.
This course serves as preparation for the corresponding ECDL module.
Target group
Users who are familiar with Microsoft Excel basics and want to gain an in-depth understanding.
Learning content
- Worksheets
- Formulas
- Excel functions
- Working with tables
- Importing data
- Pivot tables
- Working with charts
- Team Workbooks
Learning Contents
Summary of Learning Contents
Excel 365 | 2019 Advanced
-
Excel 365 | 2019 Advancedextension interactive contenttimelapse 10 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.
