Skip to content

Microsoft Office Specialist (MOS) 77-428 Excel 2013 Expert Part Two


Super Skilz

Summary

Price
£89 inc VAT
Study method
Online
Duration
12 months · Self-paced
Qualification
No formal qualification

Overview

Excel 2013 provides tools to allow you to share workbooks, connect to external data, and add Office Apps. You can log into Office using an Office 365 Organizational ID or Microsoft account, allowing you to carry your personalized Office settings with you. You can add online services including SkyDrive and SharePoint storage, as well as Microsoft accounts to access and share your images and videos with social media sites. This course will show you how to link to external data including Access databases and other Excel workbooks. Finally, it will show you how to add Office Apps from the Office Store to extend the functionality of Excel, on demand. This course will help prepare learners for the Microsoft Certification Exam 77-421: Excel 2013 Expert which certifies individuals as Microsoft Office Specialist (MOS): Excel Expert 2013.

Description

Syllabus:

  • Sharing and Linking Data, and Adding Office Apps to Excel 2013
  • Reviewing and Protecting Content in Excel 2013
  • Advanced Formats and Layouts in Excel 2013
  • Advanced Formulas and Functions in Excel 2013
  • Using Financial Functions and What-If Analysis in Excel 2013
  • Using PivotTables, PivotCharts, and Advanced Charts in Excel 2013


How is each course taught?

All courses are online and self-paced, meaning you do it in your own home, in your own time, at your own pace.  Each lesson is pre-recorded allowing you to pause, fast-forward, skip sections, or go back to another lesson if you need to.  The lessons are multi-media based, which means video and audio are used to teach the lessons.  Most lessons are also interactive, prompting the learner to participate.  This might involve answering on-screen questions, participating in tasks, and using simulators as if you were using the real software program.

How long will it take me to complete each course?

As mentioned above, our courses are self-paced.  Some people finish their course faster than others.  If you choose to only do one of the certification courses from this bundle, then it will take you less time than if you do two or three or all of them.  No matter what though, you will always have 12 months to complete your course.

What do I need?                                   

All you need is an internet connection and a PC.  While most of the lessons work on MACs, we recommend you use a PC for the best performance.  Certain parts of the course may not display properly on older MACs.  Once you’ve logged into your course, you may be prompted to down certain free plugins such as Java.  Just follow the on-screen prompts.

Questions and answers

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.