MOS Excel 2019 & 365 Expert Online Course

£ 40.53

This home study course for Microsoft Excel 2019 and 365 software is ideal for students wanting to learn more about the advanced features of Microsoft Excel or those wanting to sit the Microsoft Office Specialist (MOS) MO-201 Excel Expert exam.

Gain the Microsoft Excel 2019/365 Expert Qualification

The MOS Excel 2019 & 365 Expert Online Course is designed for students who are interested in gaining a more advanced knowledge of the Excel application and for experienced Excel users who wish to undertake an intensive refresher course. The course follows the Microsoft Office Specialist (MOS) Expert syllabus, and more, and is the ideal study guide for those wishing to gain the industry-recognised Microsoft Office Specialist Expert certification.

Proficiency in Microsoft Office products, and Excel in particular, is increasingly important in today’s competitive business environment and, whether you are currently employed or a job seeker, Microsoft Office Expert certification proves to employers and prospective employers that you have the extensive skills to become an important member of their team.

The Excel 2019 & 365 Expert course teaches all you need to know about the advanced components of the Excel application and is presented in a modern multimedia online format, with the constant support and guidance of your designated course tutor.

The course contains valuable tips on preparing for the MOS Expert examination and includes free access to the GMetrix range of MOS exam practice questions, which have the same format as the MOS exam itself.

Online Course Format

Based on the proven “learn-by-example” principle which, as the name implies, provides real-world examples to illustrate a particular topic or technique, the courses are delivered through the Distance Learning Centre’s highly-acclaimed on-line training portal via a standard web browser, such as Internet Explorer, Firefox, Chrome, Opera, or Safari. You will also be supported by a personal tutor who is available to provide feedback on your work at any time throughout the period of study.

The MOS Excel 2019 & 365 Expert Course Includes the Following Units:
The following topics are covered: Introduction; Managing Workbooks; Preparing Workbooks for Collaboration; Using and Configuring Language Options; Lesson Review & Quiz; and Assignment 1 – Workbook Options & Settings Exercises.
The following topics are covered: Introduction; Fill Cells Based on Existing Data; Formatting & Validating Data; Advanced Conditional Formatting & Filtering; Lesson Review & Quiz; and Assignment 2 – Custom Data Formatting Exercises.
The following topics are covered: Introduction; Performing Logical Operations in Formulas; Lookup Data Using Functions; Using Advanced Date & Time Functions; Performing Data Analysis; Troubleshooting Formulas; Creating & Modifying Macros; Lesson Review & Quiz; and Assignment 3 – Advanced Formula Exercises.
The following topics are covered: Introduction; Creating & Modifying Advanced Charts; Creating & Modifying Pivot Tables; Managing Pivot Tables; Create & Modifying Pivot Charts; Lesson Review & Quiz; Assignment 4 – Advanced Table & Chart Exercises; and The MOS Examination.

GMetrix Test Prep Software

The course also comes with GMetrix exam preparation software. The GMetrix Skills Management System provides everything you need to prepare for the Microsoft Office Specialist (MOS) Certification.

Overview of Test features:

  • Practice tests map to the Microsoft Office Specialist (MOS) exam objectives.
  • All tests are in-application or performance-based simulations to provide the best assessment of real-world experience.
  • All tests have both a testing and a training mode providing step-by-step help on each question.
  • Progress at own pace, save test to resume later, return to skipped questions.
  • Detailed, printable score report highlighting areas requiring further review.

Please Note: You will need a version of Microsoft Office to be able to use the GMetrix software package. 

MOS Exam Voucher (Optional) – £90.00

All students have the option to purchase MOS Exam Vouchers for £90.00 which will cover the cost of the exam at participating exam centres. A voucher would be required for each MOS exam you sit. An additional proctoring fee will need to be paid to the exam centre for each exam.

Please Note: It is the students responsibility to source suitable exam centres. We advise researching exam centres prior to purchasing an exam voucher to make sure a suitable participating exam centre is available. 

Prerequisites

This course covers the advanced features of using Microsoft Excel 2019 or Microsoft Excel 365, so students will be expected to have completed the Excel Essentials Course or have the required knowledge of what is covered in that syllabus .

Please Note: This course covers the PC versions of Microsoft Excel 2019 and Microsoft Excel 365. It will be possible to view the course materials using an Apple Mac although the information within the course will be specific to the PC version of Microsoft Office and will differ slightly from the Mac versions.

Course Duration & Online Support

You can start this course at any time, and you would be registered for a one-year period. You also have access to a personal tutor who can be contacted by email. Your tutor is available to assist with any queries and to mark your assignments.

As the course is self-study, you can complete it as quickly as you like. Support extensions are available if students do not complete the course within the one-year period.

Assessment

You will be assessed on assignments which are detailed in the course materials. These assignments will require you to create work on, and create and edit spreadsheet files. Your work can be sent back to your course tutor by email.

MOS Excel 2019/365 Expert Certification:

MOS CertificationOn successful completion of this course students will receive our Microsoft Excel 2019 and 365 Expert Certificate of Completion with feedback from your tutor, and students can also apply for the Microsoft Office Specialist (MOS) Excel Expert MO-201 exam.

Examinations must be sat at a registered Certiport Testing Centre. You should choose the Program, Version and Exam before adding your location for a list of suitable exam centres.

Exam vouchers (Valid for 12 Months) can be purchased from our website for £90.00. We usually advise buying a voucher when you are ready to sit your test, although you can add this to your order when you purchase your course.

Please Note: Exam Centres will usually charge an additional proctoring fee (Approximately £15.00) for sitting exams.

Additional information

Course Format

Online Course

Self-Study Time

Approximately 80 Hours (Self-Study)

Delivery Time

1-2 Working Days (Email)