MOS Excel 2019 and 365 Expert

• Introduction
• Managing workbooks
• Preparing workbooks for collaboration
• Using and configuring language options
• Lesson review and quiz
• Assignment 1 – workbook options & settings exercises

• Introduction
• Fill cells based on existing data
• Formatting and validating data
• Advanced conditional formatting and filtering
• Lesson review and quiz
• Assignment 2 – custom data formatting exercises

• Introduction
• Performing logical operations in formulas
• Lookup data using functions
• Using advanced date and time functions
• Performing data analysis
• Troubleshooting formulas
• Creating and modifying macros
• Lesson review and quiz
• Assignment 3 – advanced formula exercises

• Introduction
• Creating and modifying advanced charts
• Creating and modifying pivot tables
• Managing pivot tables
• Create and modifying pivot charts
• Lesson review and quiz
• Assignment 4 – advanced table and chart exercises
• The MOS examination

You must have Microsoft Excel 2019 in order to complete this course. The course covers the use of either Microsoft Excel 2019 or 365 which is a pc version of the software.

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 which will differ from Mac versions.

You will have up to 1 year to complete your course, which allows you to study in as much or as little time as you like. The course will take approximately 80 hours of study time but you don’t have to stick to this.

Your course will be studied online, through an online training portal so you have access to your course materials all in one place. You will have access to your personal tutor support throughout your course through email, so help is available at any point.

GMetrix Skills Management System is also included in your course, which will allow you to practice for your exam effectively.

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 your own pace, save the test to resume later, and return to skipped questions.
• Detailed, printable score report highlighting areas requiring further review.

Approximately 80 hours.

For your assignments, you will need to edit and create various Excel files to present your understanding of the course. You will need to submit your assignments online to your tutor. These will be marked and returned to you with feedback.

This course prepares you for the official Microsoft Office Specialist (MOS) Excel Associate MO-201 exam. If you want to take the exam to receive the full official qualification, you will need to book and pay for this separately. They must be sat at a registered Certiport Testing Centre.

On successful completion of this course, students will receive a Certificate of Completion with feedback from their tutor. Students can also apply for the Microsoft Office Specialist (MOS) Excel Expert MO-201 exam.

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