Course Introduction Banner

MOS Excel 2016 Essentials & Expert Course Bundle

Course Format:Online Course
Self-Study Time:Approximately 160 Hours (Self-Study)
Delivery Time:1-2 Working Days via Email
4.9
Based on 227 reviews from findcourses.co.uk
Course Fees & Payment Options
1.
Pay in full today:
£225.00
i
Payment in full on checkout by Card or Paypal
2.
3 monthly payments:
£75.00
i
Pay over 3 payments on checkout with Klarna
3.
6 monthly payments:
£27.00
i
1 payment of £90.00 taken now 5 further payments of £27.00 - taken monthly with GoCardless
6 Month Payment Option Details:
1 initial payment of £90.00 followed by 5 monthly payments of £27.00 by Direct Debit
Course Description

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!

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.

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 our on-line training portal via a standard web browser, such as Internet Explorer, Firefox, Chrome, Opera, or Safari. The lesson notes are delivered through slides giving you the required information to work through each lesson and there are student files you will download to work on so you are putting into practice what you are learning. 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 2016 Essentials Course Includes the Following Units:
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; and Assignment 1 - Worksheet & Workbook Exercises.
The following topics are covered: Introduction; Inserting Data; Formatting Data; Ordering & Grouping; Applying Formulas; Lesson Review & Quiz; and Assignment 2 - Cell & Range Exercises.
The following topics are covered: Introduction; Creating Tables; Modifying A Table; Filter & Sort A Table; Pivot Tables & Charts; Lesson Review & Quiz; and Assignment 3 - Table Exercises.
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; and Assignment 4 - Function Exercises.
The following topics are covered: Introduction; Creating A Chart; Formatting A Chart; Working With Objects; Lesson Review & Quiz; Assignment 5 - Charts & Object Exercises; and The MOS Examination Explained.
The MOS Excel 2016 Expert Course Includes the Following Units:
The following topics are covered: Introduction; Managing Workbooks; Restrict Editing & Protect Workbooks; Version Control & Formula Options; Lesson Review & Quiz; and Assignment 1 - Workbook Options & Settings Exercises.
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; and Assignment 2 - Custom Data Formatting Exercises.
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; and Assignment 3 - Advanced Formula Exercises.
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; 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) - £96.00

Learners have the option to purchase MOS Exam Vouchers for £96.00 which will cover the cost of the exam at participating exam centres in UK, Ireland or Australia. If you are sitting MOS exams outside of these Countries then you need to contact the relevant exam provider for your location to arrange the exams or purchase an exam voucher.

Please Note: A voucher would be required for each MOS exam that you sit. An additional proctoring fee will also need to be paid to the exam centre for each exam you arrange.

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 Excel 2016 Essentials and Expert Certification & Examinations

MOS CertificationOn 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 examination through a Certiport Testing Centre.

Candidates from UK, Ireland and Australia would need to arrange their MOS exams through Prodigy Learning who are the Certiport exam solution provider for these locations. Candidates in other locations would need to contact the relevant Certiport Solution Provider for their Country.

Exam vouchers (valid for 12 Months) can be purchased from our website for £96.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 if you prefer.

Please Note: MOS Exam Centres will also charge an additional proctoring fee for arranging exams with them.

Quick Question

Let us know if you have a question about this course and we will get back to you ASAP.

Student Testimonials
Get the TOTUM+ Student Card!
Get the TOTUM+ Student Card!

This course is eligible for the TOTUM+ Student Card.  

Find Out More About TOTUM+

  • Save over £550 a year on everyday shopping
  • Reduce your supermarket bills by £100s
  • Save 25% on takeaway coffee and dining out
  • Get FREE government approved 18+ ID
  • Enjoy 100,000s of discounts in over 90 countries worldwide
(20)
Why Study With Us?
1.
Huge Choice of Courses
We currently offer over 250+ diffeent distance learning courses leading to full Ofqual Regulated Qualifications or Accredited Certificates from National Awarding Bodies.
2.
Customer Reviews
We're a top rated home learning provider on the Find Courses / Independent reviews site, Trustpilot - currently rated 9.6/10 for customer service.
3.
Payment Plans
Choose to pay for your course in full, or spread the cost with monthly instalments. Payment plans are interest-free, with no credit checks.
4.
Quick Delivery
We process all applications quickly and most course materials are available to start within 1 to 3 working days!
5.
Tutor Support
All courses are fully supported and tutors are available to answer any questions, mark your assignments and offer feedback and guidance throughout your course.
6.
Study At Your Pace
Work at your own pace. Our team will support you, but won't chase you for work or apply deadlines for submissions.
Recently Viewed (1)
MOS Excel 2016 Essentials & Expert Course Bundle
MOS Excel 2016 Essentials & Expert Course Bundle
£225.00
From as little as £27.00 per month