MOS Excel 2019 and 365 Associate

• Introduction
• The Excel application
• Managing worksheets and workbooks
• Navigating worksheets and workbooks
• Formatting worksheets and workbooks
• Customisation option and views
• Configuring content for collaboration
• Lesson review and quiz
• Assignment 1 – worksheet and workbook exercises

• Introduction
• Manipulating data in worksheets
• Formatting cells and ranges
• Summarising data visually
• Applying formulas
• Lesson review and quiz
• Assignment 2 – data cell and range exercises

• Introduction
• Creating and formatting tables
• Modifying tables
• Filtering and sorting table data
• Introducing pivot tables and charts
• Lesson review and quiz
• Assignment 3 – table exercises

• Introduction
• Inserting references
• Calculating and transforming data
• Using conditional logic In functions
• Formatting and modifying text with functions
• Introducing maths functions
• Introducing date and time functions
• Lesson review and quiz
• Assignment 4 – function exercises

• Introduction
• Creating and modifying charts
• Formatting charts
• Working with objects
• Lesson review and quiz
• Assignment 5 – charts and object exercises
• The MOS examination explained

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.

You will have up to 1 year to complete your course. The course study time should take approximately 80 hours, so 1 year will allow flexible learning. You can complete your course in as little or as much time as you like.

Your course will be studied online, so you have access to your course materials through an online training portal. 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.

Your assignments will involve you working on, editing and creating 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.

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.

You will receive a certificate of completion with feedback from your tutor. You will also be exam ready, so you’ll be able to apply to sit the Microsoft Office Specialist Excel Associate 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 you have the necessary skills to become an important member of their team.