Excel Advanced (web course)
|Office-Version:||MS Office 2016 MS Office 2019|
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.
Users who are familiar with Microsoft Excel basics and want to gain an in-depth understanding.
8 hours (45 lessons)
Microsoft Excel basics
Course contents Excel Advanced
- Course recommendation
- Excel functions
- Working with tables
- Importing data
- Pivot tables
- Working with charts
- Workbooks in a team
Activating your online course(s) on the e-learning platform
After purchasing this online course, you will receive an e-mail providing you with a voucher code and a link to redeem it. You will then receive your login details to the e-learning platform, where your course will be available to you for 12 months after your first login. You must validate your code within 24 months.
- MS Windows 7 or higher
- Apple Mac OS X 10.6 or higher
- Internet Explorer version 9.0 or higher
- Mozilla Firefox version 10.0 or higher
- Google Chrome version 19 or higher
- Safari version 5.1 or higher
- PDF reader (optional)