This e-learning course teaches you all the essential features of Microsoft Excel 2019, at advanced and expert level. After this training, your employees will master pivot tables, advanced charts, lookup functions such as VLOOKUP and XLOOKUP, dynamic array functions and macros for automation. Basic knowledge of Excel is required. Available immediately after purchase. This course is also available as a SCORM package for your LMS.
Ideal for employees who want to expand their Excel knowledge at advanced and expert level, for organisations that want to upskill their teams in Excel in a structured way, and for anyone who wants to work more efficiently with Microsoft Excel 2019. Basic knowledge of Excel is required, for example built up via the Excel 2019 Basic course.
After this course, your employees will master pivot tables, advanced charts, lookup functions such as VLOOKUP and XLOOKUP, dynamic array functions and macros for automation.
You learn directly in the real Microsoft 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. After each exercise you receive direct feedback and a solution video for further insight.
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.
Interactive e-learning with practical exercises directly in the real Excel 2019 environment, theoretical assignments with additional information, use case video training, an online reference book, a certificate of participation after completing at least 70% of the course, 12 months of access after activation, language: English. Total study time: 6 hours and 15 minutes. This course 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' Excel 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.
Want to brush up on the basics first? Check out Excel 2019 Basic and Advanced or the complete Excel 2019 Basic, Advanced and Expert training. 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].
