This e-learning course teaches you the advanced features of Microsoft Excel 365, 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 is required. Available immediately after purchase. This course is also available as a SCORM package for your LMS.
This e-learning is ideal for employees who already master the basics and want to extend their knowledge to advanced and expert level, for organisations that want to upskill their teams in a structured way, and for anyone who wants to work more efficiently with the latest version of the programme. Basic knowledge is required.
After this e-learning, your employees will master pivot tables, advanced charts, lookup functions, dynamic array functions and macros for automation, and work more effectively and securely with large amounts of data.
You learn directly in the real programme environment, so there is no difference between the training software and your everyday work software. Every practical exercise in this course 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 1: Advanced. Format: interactive training with 60 instructional videos and 60 practical exercises directly in the real 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 2: Expert. Format: interactive training with 42 instructional videos and 42 practical exercises directly in the real 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 3: Excel 365 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 365 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: 9 hours and 30 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.
Want to brush up on the basics first? Check out Excel 365 Basic and Advanced or the complete Excel 365 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].
