This e-learning course teaches you all the essential features of Microsoft Excel 2019, fully tailored through a practical pre-test. The results of this pre-test are processed into your personal learning path, so your employees only go through the parts they have not yet mastered. After this training, your employees will master Excel at the level that matches their role, from simple tables and formulas to advanced functions and automation with macros. No prior knowledge required. Available immediately after purchase, including a complete online course book. This course is also available as a SCORM package for your LMS.
This e-learning is ideal for employees with varying levels of knowledge, for organisations that want to use a single course for an entire team without everyone having to complete the same parts, and for anyone who wants a tailored, self-paced way to work with Microsoft Excel 2019. No prior knowledge required: the pre-test determines the starting level.
After this e-learning, your employees will master Excel at the level that matches their role: from simple tables, formulas and formatting to charts, pivot tables, advanced calculation functions and automation with macros. Because the course adapts to the pre-test results, they only learn what is actually needed.
You start with a practical pre-test, the result of which is automatically processed into your course so that you get a tailored learning path. After that, you learn directly in the real Excel 2019 environment, so there is no difference between the training software and your everyday work software. Every practical exercise is assessed live, and all solution paths are accepted: menu commands, right-click or keyboard shortcuts. Your answers are analysed in real time and your progress is tracked through detailed reports, so supervisors can see exactly where each employee stands.
Module 1: Excel 2019 Basic. Format: interactive training with 45 instructional videos and 45 practical exercises directly in the real Excel environment, plus 5 theoretical assignments with additional information. Content: getting started with Excel and filling in a workbook, making your first calculations, formatting your data attractively, printing worksheets and managing page setup, working more efficiently, navigating and managing how data is displayed.
Module 2: Excel 2019 Advanced. Format: interactive training with 60 instructional videos and 60 practical exercises directly in the real Excel environment, plus 5 theoretical assignments with additional information. Content: formatting more complex tables, displaying figures in charts, improving chart appearance, making tables more attractive, working with data tables and lists, creating and using pivot tables.
Module 3: Excel 2019 Expert. Format: interactive training with 42 instructional videos and 42 practical exercises directly in the real Excel environment, plus 5 theoretical assignments with additional information. Content: increasing your effectiveness, using advanced calculation functions, discovering lesser-known features, sharing and security, macros and automation.
Module 4: Office 2019 Use Cases. Format: video training, 23 minutes. Content: Excel, Word or PowerPoint with a Microsoft 365 subscription.
Module 5: Excel 2019 Use Cases. Format: video training, 55 minutes. Content: creating a chart for quality control, visitor statistics, an overview of budgets used and required, minimising delivery costs.
Extra: free digital Excel 2019 reference book, valid for 1 year with unlimited access, covering all features of the programme in detail.
A practical pre-test that tailors your learning path, interactive e-learning with practical exercises directly in the real Excel 2019 environment, theoretical assignments with additional information, use case video training, a free digital reference book, progress reports, a certificate of participation after completing at least 70% of the course, 12 months of access after activation, language: Dutch or English. Total study time: 14 hours and 50 minutes. This training is also available as a SCORM package for your LMS, ready to integrate into Moodle, Totara, Cornerstone and all other SCORM-compatible systems. Prices available on request, request a free quote. Want to also master the latest AI features in Excel? Check out our Microsoft 365 Copilot e-learning.
Want to officially demonstrate your employees' skills? OEM is a recognised Certiport exam centre. Prepare optimally with our MOS Excel practice exam and take your certification exam online via Remote Proctoring.
Prefer fixed course content without a pre-test? Check out the complete Excel 2019 Basic, Advanced and Expert, Excel 2019 Basic and Advanced or Excel 2019 Advanced and Expert. For all versions and levels, visit our Microsoft Excel E-Learning category.
Do you have questions about this course? Our AI assistant Sanne is available 24/7 via the blue chat icon at the bottom right of our website. For personal advice, reach us at [email protected].