Microsoft Office Specialist (MOS) Excel 2016 Essentials & Expert Course Bundle
With this course bundle you will receive seven courses covering all Microsoft This course will allow students to start at a beginners level and will provide you with the skills to use this popular spreadsheet software package to an advanced level.
The MOS Excel 2016 Essentials & Expert Course Bundle allows students to purchase our MOS Excel 2016 Essentials and MOS Excel 2016 Expert courses together, for a combined price of £225.00, making a saving of £75.00!
uNITS
The MOS Excel 2016 Essentials Course Includes the Following Units:
Unit 1: Worksheets & Workbooks
The following topics are covered:
- Introduction;
- The Excel 2016 Application;
- Managing Worksheets & Workbooks;
- Navigating Worksheets & Workbooks;
- Formatting Worksheets & Workbooks;
- Customisation Options;
- Configuration Options;
- Lesson Review & Quiz;
- Assignment 1 – Worksheet & Workbook Exercises.
Unit 2: Managing Cells & Ranges
The following topics are covered:
- Introduction;
- Inserting Data;
- Formatting Data;
- Ordering & Grouping;
- Applying Formulas;
- Lesson Review & Quiz;
- Assignment 2 – Cell & Range Exercises.
Unit 3: Managing Tables
The following topics are covered:
- Introduction;
- Creating Tables;
- Modifying A Table;
- Filter & Sort A Table;
- Pivot Tables & Charts;
- Lesson Review & Quiz;
- Assignment 3 – Table Exercises.
Unit 4: Excel Functions
The following topics are covered:
- Introduction;
- Summarise Data With Functions;
- Use Conditional Logic In Functions;
- Format & Modify Text With Functions;
- Useful Maths Functions;
- Date & Time Functions;
- Lesson Review & Quiz;
- Assignment 4 – Function Exercises.
Unit 5: Inserting Charts & Objects
The following topics are covered:
- Introduction;
- Creating A Chart;
- Formatting A Chart;
- Working With Objects;
- Lesson Review & Quiz;
- Assignment 5 – Charts & Object Exercises;
- The MOS Examination Explained.
The MOS Excel 2016 Expert Course Includes the Following Units:
Unit 1: Manage Workbook Options & Settings
The following topics are covered:
- Introduction;
- Managing Workbooks;
- Restrict Editing & Protect Workbooks;
- Version Control & Formula Options;
- Lesson Review & Quiz;
- Assignment 1 – Workbook Options & Settings Exercises.
Unit 2: Apply Custom Data Formats & Layouts
The following topics are covered:
- Introduction;
- Applying Custom Data Formats & Validation;
- Advanced Conditional Formatting & Filtering;
- Creating & Modifying Custom Workbook Elements;
- Preparing A Workbook For Internationalisation;
- Lesson Review & Quiz;
- Assignment 2 – Custom Data Formatting Exercises.
Unit 3: Creating Advanced Formulas
The following topics are covered:
- Introduction;
- Applying Functions in Formulas;
- Lookup Data Using Functions;
- Applying Advanced Date & Time Functions;
- Importing & Analysing External Data;
- Business Intelligence Features;
- Troubleshooting Formulas;
- Defining Named Ranges & Objects;
- Lesson Review & Quiz;
- Assignment 3 – Advanced Formula Exercises.
Unit 4: Creating Advanced Charts & Tables
The following topics are covered:
- Introduction;
- Creating Advanced Charts;
- Creating Pivot Tables;
- Managing Pivot Tables;
- Create & Managing 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 2016 to complete the course.
Please Note: The course covers the use of Microsoft Excel 2016, 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.
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, create and edit spreadsheet files. Your work can be sent back to your course tutor by email.
MOS Office 2016 Certification
On successful completion of this course students will receive our Excel 2016 Essentials and Expert Certificate of Completion with feedback from your tutor, and students can also apply for the Microsoft Office Specialist Excel 2016 Essentials 77-727 Exam, and the Microsoft Office Specialist Excel 2016 Expert 77-728 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 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.
