Certificate in MS 2016 - Level 3

4.5( 4 REVIEWS )
1770 STUDENTS
Overview Certificate in MS 2016 Level 3 – Do you need to get to grips with Microsoft Office? Maybe you …

Overview

Certificate in MS 2016 Level 3 – Do you need to get to grips with Microsoft Office? Maybe you just need certification of your skills? Perhaps you want a career in admin?

Whatever your situation is we’ve got you covered. This course covers the whole Microsoft suite, so whether you’re a beginner, or have some experience, you’ll soon have a wealth of knowledge and skills. Having a recognised qualification on your CV is extremely useful and shows potential employers that you can use Microsoft to the highest standards. Learn Microsoft Office 2016 and boost your confidence. Discover new features in the applications and become more effective and productive in the workplace. Learn to accomplish office tasks quickly and efficiently. This course will get you up to speed on Microsoft applications, and you will be able to master the improved features and functions. Getting certified in this course will give you the opportunity to work across a range of sectors in multiple positions.

Key components (software) you will study in this course:

  • Microsoft Office Word 2016
  • Microsoft Office Excel 2016
  • Microsoft Office PowerPoint 2016
  • Microsoft Office Access 2016
  • Microsoft Outlook 2016

Learning with Study 365 has many advantages. The course material is delivered straight to you and can be adapted to fit in with your lifestyle. It is created by experts within the industry, meaning you are receiving accurate information, which is up-to-date and easy to understand.

This course is comprised of professionally narrated e-Learning modules, interactive quizzes, tests, and exams. All delivered through a system that you will have access to 24 hours a day, 7 days a week for 365 days (12 months). An effective support service and study materials will build your confidence to secure your qualification.

  • Who is it for?
  • Course Description:
  • Method of Assessment:
  • Certification:
  • Entry Requirements:
  • Career Path:

This course is designed for those who wish to develop their skills using Microsoft Office applications. This qualification is helpful for any office job, such as Admin Assistant, Administrator, or Office Manager.

This course is comprehensive and covers the modules listed below under the curriculum.

Microsoft Office Word

Working with long text documents, paragraphs, tab stops, page setup, tables, columns, styles, illustrations, templates and proofreading documents.

Microsoft Office Excel

Creating cell data, formatting cells and worksheets, managing worksheets and workbooks, Formulas and Functions (basic and more complex, including absolute cell referencing), charts, conditional formatting, sorting and filtering data, data protection.

Microsoft Office Power-Point

Managing the PowerPoint environment, using templates and themes, creating and formatting slides and sections, applying transitions and animations and timings, insert video and sounds, using pointer options, creating custom slide shows and a photo album, working with slide masters.

Microsoft Office Access

Understanding table creation and design. Finding, editing, sorting and filtering data to highlight key information. Building table relationships and enforcing referential integrity to keep data “clean”. A basic introduction to functions and using the formula creator. Using aggregate functions and totals to simplify calculations.

Microsoft Office Outlook

Working with email effectively; managing appointments, meetings, contacts, and to do lists; and finally linking and synchronisation.

At the end of the course, learners will take an online multiple choice question assessment test. The online test is marked straightaway, so you will know immediately if you have passed the course.

Successful candidates will be awarded a Certificate in MS 2016 - Level 3. These are printed on high grade paper embossed with official Study365 or ABC awards. It is delivered right to your place in a hard back envelope to keep it in pristine condition.

Option 1 -ABC Awards

Successful learners will receive an Endorsed ABC Awards Accredited Certificate issued by ABC Awards and a Learner Unit Summary (which lists the components the learner has completed as part of the course) for only £49.

Option 2 -CPD Certificate

Successful learners will receive an Endorsed CPD Accredited Certificate for only £29.

Learners must be age 16 or over and should have a basic understanding of the English Language, numeracy, literacy, and ICT.

You can use this certification to demonstrate your understanding of Microsoft Office 2016 to potential organisations and gain the desired job role. You will be eligible for a raise or incentives put forth by the organisation. Given below are job titles you can land, along with the average UK salary per annum according to https://www.payscale.com/

  • Administrative Assistant - £17,677 per annum
  • Administrator - £18,172 per annum
  • Office Manager - £25,018 per annum

PLEASE NOTE:

We do not provide software with this course, you will need to have the MS Office Package on your computer or have access to a computer which has MS Office on it.

Helpful Link for Software Downloading:

MS  Office (30Days Trial )

https://products.office.com/en-gb/try

 

 

Course Curriculum

1: MICROSOFT WORD 2016
Introduction to Microsoft Word 00:01:00
First Step to MS Word 00:31:00
Text Editing & Formatting 00:44:00
Formatting Paragraph and Pages 00:48:00
Creating Styles, Themes, Number and Bullets 00:39:00
Columns & Tables 01:33:00
Macros and Proofing 00:33:00
Sharing and Reviewing Documents 00:27:00
Modify Word Document 00:15:00
Exercise Files: Microsoft Word 2016
2: MICROSOFT EXCEL 2016
Getting Started with Microsoft Excel 00:42:00
Data Entering 00:24:00
Creating Formulas and Functions 00:41:00
Formatting 01:02:00
IF, VLOOKUP, and Power Functions, Security & Sharing 00:51:00
Data Management, Data Analysis Tools 01:20:00
PivotTables & Macros 01:21:00
Exercise Files: Microsoft Excel 2016
3: MICROSOFT POWERPOINT 2016
Getting Started with Microsoft PowerPoint 00:10:00
Working with Presentations & Slides 00:37:00
Adding Pictures & Contents to Slides 00:46:00
Adding Shapes, Diagrams, Charts, Video, Audio, and Animation to Slides 00:39:00
Preparing & Delivering the Presentation 00:26:00
Reusing and Sharing Presentations 00:20:00
Exercise Files: Microsoft PowerPoint 2016
4: MICROSOFT OUTLOOK 2016
Getting Started with Outlook 00:08:00
Adding and Connecting Accounts, Reading & Organizing Mails 01:02:00
Creating and Sending Mail, Creating and Working with People 00:44:00
Working with Delegates & Calendars 00:40:00
Creating Tasks and Notes, Working with Outlook Data 00:13:00
5: MICROSOFT ACCESS 2016
Introduction to MS Access 00:35:00
Creating Tables & Setting up Properties 01:04:00
Queries 01:32:00
Creating Forms & Reports 02:13:00
Working with Macros, Integrating Access with Office Suite 00:34:00
Database Management 00:28:00
Exercise Files- Microsoft Access 2016
Mock Exam
Mock Exam: Certificate in MS 2016 – Level 3 00:30:00
Final Exam
Final Exam: Certificate in MS 2016 – Level 3 00:30:00

Students feedback

4.5

Average rating (4)
4.5
5 Star
4 Star
3 Star
2 Star
1 Star
    F C

    Faith Cooke

    November 23, 2019
    Great programme

    As someone who wanted to acquire more skills in MS Office 2016, taking this course has been the first step to achieve this. I gained a wealth of knowledge on how to be productive in the workplace. This is a great course particularly if you are planning to enter the workforce. I learned to accomplish daily tasks efficiently.

    E G

    Ellie Gardner

    November 19, 2019
    Insightful

    The course is insightful and will get you up to speed on Microsoft applications. I had taken an earlier version of MS Office but wanted to learn more advanced features and functions. This course has been my guide book when it comes to apply my new-found skills in everything I do.

    N E

    Nora Elliott

    October 22, 2019
    Convenient and easy

    One reason I decided to sign up for this course is the convenience that came with it. I work long hours, however, I also wanted to qualify in this course. I was offered convenience which helped me work while still studying. It was a great balance.

    M M

    Megan Mason

    October 11, 2019
    Good quality

    The course maintained a good quality that even I found surprising. The content was highly detailed and gave me insight into the subject matter. I absolutely enjoyed learning at Study365, and hope to take more courses with them in the future.

WhatsApp chat