Microsoft's specialist and expert qualifications
Excel 2013
MOS and MOSE Training Package
- Contact UsView Certifications
- For any enquires associated with this course please contact us:
310 341 3145 or 603 676 8262
Would you like us to send you information on this certification and be informed of any future updates and retirements?
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.
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
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.
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.
- ↘ Take on a new adventure with the Excel 2013 Packages interactive video demos
- ↘ Contact us about our Excel 2013 Package student placement service
Promotions. Gain access to the Excel 2013 Package and Microsoft course library for 10 days.
If your aim is employment/career advancements through IT training, see how you can achieve this together with your tutor.
90.00%
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.
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
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
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
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
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
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
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
- Yes! We pride ourselves on our customer service. You can either email us or call us on these contact details:
- 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
- Please email support@openittraining.com with the following details:
- 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...
School leavers
A fun and enjoyable way to build a fresh career
Teachers & IT professionals
A prestigious qualification which will distinguish you from the crowd of 21st century geeks
Anyone else...
Looking to start a healthy, rewarding & lucrative career in I.T
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.
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