Background Image

Microsoft's specialist and expert qualifications

Excel 2013

MOS and MOSE Training Package

Would you like us to send you information on this certification and be informed of any future updates and retirements?

Name*

Email*

Phone*

Course Information

Certification summary

Want to excel amongst others in the workplace with becoming a Microsoft Specialist and Microsoft Expert in spreadsheet software? Do you feel you wish to be the "go-to person" that can solve and assist in any spreadsheet related query? If this sounds like the true certification you're looking for, please read on.

Exam Information

Exams summary

All the following exams are covered within this package:

77-420 - Microsoft Office Excel 2013 Specialist
77-427 - Microsoft Office Excel 2013 Expert Part I
77-428 - Microsoft Office Excel 2013 Expert Part II

A closer look...

Microsoft Excel 2013 Specialist...
Our Microsoft Office Specialist (MOS) certification in Excel 2013 will equip you with the knowledge of using the latest technologies currently available in a spreadsheet application and will make you understand the fundamentals of the powerful tools available at your disposal. This specialist course is a fantastic opportunity to gain the necessary knowledge and understanding of the most popular used spreadsheet program available in the world. By taking this course, you will become confident in the fundamentals of what this program has to offer and how to demonstrate these newly adopted I.T. skills within a working environment.

As a certified candidate, you will be able to create and manage entire worksheets and workbooks, identify and change cells and cell ranges, produce tabular data and manipulate them by using filtering methods, identify formulas and functions by applying logic and formatting for your data and build beautiful and professional charts and objects to compliment the data that you've produced.

Microsoft Excel 2013 Expert...
This package doesn't stop here though; you will continue to learn and build on the fundamental skills you have learnt and developed as an office specialist and will undertake more advanced procedures and tools that was introduced in the specialist course. This certification is the market leader in Microsoft Office Qualifications and will ensure your knowledge, skills and abilities of Excel 2013 is productively used to a high degree of proficiency.

The course allows you to further demonstrate your knowledge where upon you will perform advanced skills and techniques such as creating pivot tables and using database functions. The Expert Syllabus is divided into two exams, Excel Expert Part One and Excel Expert Part Two. The first module covers, in depth how to manage and share workbooks, how to apply custom formats and layouts, how to create advanced formulas and how to create advanced charts and tables. The second module includes similar topics covered in the previous but measures a variety of different skills.

This package includes three exams from the specialist level to the expert level of Excel 2013.

Career & Job Opportunities

Our MOS and MOSE training package for Excel 2013 is an internationally recognised Microsoft Office qualification. It's the only performance-based certification that validates the skills needed to get the most out of Excel 2013. The MOS (Microsoft Office Specialist) has an average wage of $33,000pa in the US* (as of the start of 2015) and will increase significantly as you become certified as a MOSE (Microsoft Office Specialist Expert) which has an average wage of $40,000pa in the US* (also as of the start of 2015).

Below are some of the lucrative careers available associated with this certification:


  • Accountant
  • Bookkeeper
  • Secretary
  • Office Administrator
  • Data Analyst
  • Sales Coordinator
  • Logistics Personnel
  • Operations Analyst
  • Quality Assurer

*Source: PayScale Research 2015

Free MOS Microsoft Office Specialist training

Start the MOS & MOSE Training Package with a trial

We are offering a trial of this course for free with no purchase necessary, just sign up below to instantly receive your login details.

Name

Email

Phone

Address

Comment

jobs for the MOS Microsoft Office Specialist

We will work with you to ensure that you can find work in IT after completing your Excel 2013 course

We aim to get you in an IT job role on completion of your Excel 2013 Package. If you have no qualification or background in IT, we will provide you with the necessary training for the experience required. For existing Excel 2013 specialists, we can upgrade your qualifications and improve your career prospects. Do not allow your lack of experience or self-confidence deny you from a career in I.T - it is a lot easier (and enjoyable too) than most people think, once you learn the basics.

90.00%

of MOS & MOSE Package students are being offered a salary of more than $33,000pa in the US.

The exams

The MOS and MOSE Excel 2013 Training Package is the latest generation in Microsoft and Office Skills technology and as such there is no current retirement plan for its exams. Below is a breakdown of the exams for this certification and how they are made up.

More Exam Information

Microsoft Office Excel 2013 Specialist (MOS)
77-420

This course is set out in the following modules:

- Create and manage worksheets and workbooks
- Create cells and ranges
- Create tables
- Apply formulas and functions
- Create charts and objects

X

Microsoft Office Excel 2013 Specialist (MOS)

This exam measures your ability to accomplish the technical tasks listed: Create and manage worksheets and workbooks, Create cells and ranges, Create tables, Apply formulas and functions, Create charts and objects. Here are the percentages that make up the final mark for this exam using these technical tasks:

  • Create and manage worksheets and workbooks (20%)
    • Create worksheets and workbooks
    • Navigate through through worksheets and workbooks
    • Format worksheets and workbooks
    • Customize options and views for worksheets and workbooks
    • Configure worksheets and workbooks to print or save
  • Create cells and ranges (20%)
    • Insert data in cells and ranges
    • Format cells and ranges
    • Order and group cells and ranges
  • Create tables (20%)
    • Create a table
    • Modify a table
    • Filter and sort a table
  • Apply formulas and functions (20%)
    • Utilise cell ranges and references in formulas and functions
    • Summarise data with functions
    • Utilise conditional logic in functions
    • Format and modify text with functions
  • Create charts and objects (20%)
    • Create a chart
    • Format a chart
    • Insert and format an object

Try this course online, login via providing some basic student details below

Name*

Email*

Phone*

More Exam Information

Microsoft Office Excel 2013 Expert (MOSE) Part I
77-427

This course is set out in the following modules:

- Manage and Share Workbooks
- Apply Custom Formats and Layouts
- Create Advanced Formulas
- Create Advanced Charts and Tables

X

Microsoft Office Excel 2013 Specialist (MOSE) Part I

This exam measures your ability to accomplish the technical tasks listed: Manage and Share Workbooks, Apply Custom Formats and Layouts, Create Advanced Formulas, Create Advanced Charts and Tables. Here are the percentages that make up the final mark for this exam:

  • Manage and Share Workbooks (25%)
    • Manage Workbook Changes
  • Apply Custom Formats and Layouts (25%)
    • Apply Advanced Conditional Formatting and Filtering
    • Prepare a Workbook for Internationalization and Accessibility
  • Create Advanced Formulas (25%)
    • Look Up Data with Functions
    • Apply Advanced Date and Time Functions
  • Create Advanced Charts and Tables (25%)
    • Create Advanced Chart Elements
    • Create and Manage PivotTables

Try this course online, login via providing some basic student details below

Name*

Email*

Phone*

More Exam Information

Microsoft Office Excel 2013 Expert (MOSE) Part II
77-428

This course is set out in the following modules:

- Manage and Share Workbooks
- Apply Custom Formats and Layouts
- Create Advanced Formulas
- Create Advanced Charts and Tables

X

Microsoft Office Excel 2013 Specialist (MOSE) Part II

This exam measures your ability to accomplish the technical tasks listed: Manage and Share Workbooks, Apply Custom Formats and Layouts, Create Advanced Formulas, Create Advanced Charts and Tables. Here are the percentages that make up the final mark for this exam using these technical tasks:

  • Manage and Share Workbooks (25%)
    • Manage Multiple Workbooks
    • Prepare a Workbook for Review
  • Apply Custom Formats and Layouts (25%)
    • Apply Custom Data Formats
    • Apply Custom Styles and Templates
  • Create Advanced Formulas (25%)
    • Apply Functions in Formulas
    • Create Scenarios
  • Create Advanced Charts and Tables (25%)
    • Create and Manage Pivot Charts

Try this course online, login via providing some basic student details below

Name*

Email*

Phone*

Shopping Cart

Buy the Excel 2013 learning package at $500.

Includes all three courses shown above.

FAQ

Frequently asked questions...


  • What are the requirements to study this course?
    • You will need a PC with access to the internet
    • You will not need any version of Microsoft Excel – We have practical exercises built into this interactive training course

  • Is this course available in any other languages other than English?
    • Sorry at the moment our course line is all in English

  • How long does this course take to complete?
    • There are three training courses in this Excel package which will take approximately 100 hours study time to complete

  • How much time do I have to complete my training?
    • You will have a full 2 years (24 Months) to access to the training course from the first time you log on

  • If I have a problem is there anyone to help me?
    • Yes! We pride ourselves on our customer service. You can either email us or call us on these contact details:
      • Phone: 603-676-8262
      • Email: support@openittraining.com

  • I have still not received my course, what can I do?
    • Please email support@openittraining.com with the following details:
      • Full name
      • Email address
      • Phone number
      • Groupon voucher code

  • I have a Mac will this course work?
    • Yes of course, all our courses work on iPad, Mac, tablets, PC’s and even Smart phones

This course is suitable for...

Training for a fresh career

School leavers

A fun and enjoyable way to build a fresh career

Training for teachers and IT professionals

Teachers & IT professionals

A prestigious qualification which will distinguish you from the crowd of 21st century geeks

Training for anyone looking to start a new career

Anyone else...

Looking to start a healthy, rewarding & lucrative career in I.T

Is this course right for you?

But is this course right for you?

Will it provide you with the skills that you need, or the career you'd like to explore? If you are not 100% sure that it's correct for you then we highly recommend that you experience our trial courses and assessments to get an accurate insight to the Excel 2013 MOS and Excel 2013 MOSE certification. You can sign up for this below or use it to ask our lecturers some questions. You can also call us on 310 341 3145 or 603 676 8262 and speak to one of our course advisers and they will help you choose the perfect certification tailored to your needs.

Name*

Email*

Phone*

More Information

Request more info on the Excel 2013 MOS Specialist & MOSE Expert Training Package

Exam tips and syllabus

Get the Excel 2013 MOS & MOSE exam syllabus aswell as helpful tips

What our students say

See what our students have to say about the Excel 2013 MOS and MOSE Training Package