This e-learning course teaches you all the essential features of Microsoft Excel 2019, from basic to advanced and expert level. After this training, your employees will fully master Excel, from simple tables and formulas through charts and pivot tables to advanced functions and automation with macros. No prior knowledge of Excel 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 basic, 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. No prior knowledge of Excel required.
After this course, your employees will fully master Excel, from simple tables and formulas through charts and pivot tables to advanced functions and automation with macros.
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 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.
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: 14 hours and 50 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.
Also check out our other Excel 2019 training courses: Excel 2019 Basic and Advanced and 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].
