Microsoft Office Specialist (MOS) Excel 2019 & 365 Associate & Expert Course Bundle
Microsoft Excel is one of the most important software packages used in businesses and adding the industry-recognised Microsoft Office Specialist certification to your CV demonstrates that you have gained the necessary expertise to use Microsoft applications to a high standard, and shows you have the skills companies are looking for.
The MOS Excel 2019 & 365 Associate and Expert Course Bundle is designed for anyone who wants to learn the Microsoft Excel 2019 and 365 software from a beginners level all the way to the Expert level and covers everything that is included in the Microsoft Office Specialist Associate and Expert exams. These courses can be used by anyone wanting to sit the MOS exams or those who need to learn more about the Microsoft Excel software package.
The MOS Excel 2019 & 365 Associate and Expert Course Includes:
- 12 month access to the course materials;
- Tutor support by a personal course tutor;
- Free GMetrix Test Prep software;
- A Certificate of Completion;
- The option to purchase MOS Exam Vouchers for £90.00 to cover the cost of a MOS Exams.
uNITS
The MOS Excel 2019 & 365 Associate Course Includes the Following Units:
Unit 1: Managing Worksheets and Workbooks
The following topics are covered:
- Introduction;
- The Excel Application;
- Managing Worksheets & Workbooks;
- Navigating Worksheets & Workbooks;
- Formatting Worksheets & Workbooks;
- Customisation Option & Views;
- Configuring Content For Collaboration;
- Lesson Review & Quiz;
- Assignment 1 – Worksheet & Workbook Exercises.
Unit 2: Managing Data Cells and Ranges
The following topics are covered:
- Introduction;
- Manipulating Data in Worksheets;
- Formatting Cells & Ranges;
- Summarising Data Visually;
- Applying Formulas;
- Lesson Review & Quiz;
- Assignment 2 – Data Cell & Range Exercises.
Unit 3: Managing Tables and Table Data
The following topics are covered:
- Introduction;
- Creating & Formatting Tables;
- Modifying Tables;
- Filtering & Sorting Table Data;
- Introducing Pivot Tables & Charts;
- Lesson Review & Quiz;
- Assignment 3 – Table Exercises.
Unit 4: Perform Operations Using Functions
The following topics are covered:
- Introduction;
- Creating & Formatting Tables;
- Modifying Tables;
- Filtering & Sorting Table Data;
- Introducing Pivot Tables & Charts;
- Lesson Review & Quiz;
- Assignment 3 – Table Exercises.
Unit 5: Managing Charts and Objects
The following topics are covered:
- Introduction;
- Creating & Modifying Charts;
- Formatting Charts;
- Working With Objects;
- Lesson Review & Quiz;
- Assignment 5 – Charts & Object Exercises;
- The MOS Examination Explained.
The MOS Excel 2019 & 365 Expert Course Includes the Following Units:
Unit 1: Manage Workbook Options & Settings
The following topics are covered:
- Introduction;
- Managing Workbooks;
- Preparing Workbooks for Collaboration;
- Using and Configuring Language Options;
- Lesson Review & Quiz;
- Assignment 1 – Workbook Options & Settings Exercises.
Unit 2: Managing & Formatting Data
The following topics are covered:
- Introduction;
- Fill Cells Based on Existing Data;
- Formatting & Validating Data;
- Advanced Conditional Formatting & Filtering;
- Lesson Review & Quiz;
- Assignment 2 – Custom Data Formatting Exercises.
Unit 3: Creating Advanced Formulas & Macros
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;
- Assignment 3 – Advanced Formula Exercises.
Unit 4: Managing Advanced Charts & Tables
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;
- The MOS Examination.
Key Information
Cost
Course Format
Self-study Time
Delivery Time
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.
Prerequisites
There are no particular entry requirements as the course is set out for beginners although students will require their own version of Microsoft Excel 2019 or Microsoft Excel 365 to complete the course.
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 for the Awarding Body.
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 Office 2019/365 Certification
On successful completion of these courses students will receive our Microsoft Excel 2019 and 365 Associate and Expert Certificates of Completion with feedback from your tutor, and students can also apply for the Microsoft Office Specialist (MOS) Excel Associate MO-200 and Microsoft Office Specialist (MOS) Excel Expert MO-201 exams.
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 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.
