MasterPhDLawBachelorMBAHealthcareCoursesOnline
Keystone logo
Distance Learning Centre MOS Excel 2016 Course
Distance Learning Centre

MOS Excel 2016 Course

UK Online, United Kingdom

100 Hours

English

Part time

Request application deadline

Request earliest startdate

GBP 175 / per course

Distance Learning

Scholarships

Explore scholarship opportunities to help fund your studies
Read more

Introduction

The MOS Excel 2016 Course (Desktop / Office 365) covers Microsoft Office Specialist exam objectives to help students prepare for the Excel 2016 77-727 Core Data Analysis, Manipulation, and Presentation Exam and the Excel 2016 Expert 77-728 Interpreting Data for Insights Exam.

Microsoft Excel is the industry standard for Spreadsheets and helps companies and individuals to calculate, analyse, revise, update, and present your data in a professional way and this course will show students how to accomplish their tasks in much less time, than if you used traditional pen-and-paper methods or non-specialised software. This course aims to provide you with a foundation for Excel knowledge and skills, which you will build upon this to eventually become an expert in data manipulation.

The course Includes:

Microsoft Excel 2016 - Course Book 1

Upon successful completion of this book, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyse the data that is critical to the success of your organisation.

Students will learn to:

  • Get started with Microsoft Office Excel 2016.
  • Perform calculations.
  • Modify a worksheet.
  • Format a worksheet.
  • Print workbooks.
  • Manage workbooks.

Microsoft Excel 2016 - Course Book 2

Upon successful completion of this book, you will be able to leverage the power of data analysis and presentation in order to make informed, intelligent organisational decisions.

Students will learn to:

  • Work with functions.
  • Work with lists.
  • Analyse data.
  • Visualize data with charts.
  • Use PivotTables and PivotCharts.

Microsoft Excel 2016 - Course Book 3

Upon successful completion of this book, you will be able to perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality.

Students will learn to:

  • Work with multiple worksheets and workbooks.
  • Use Lookup functions and formula auditing.
  • Share and protect workbooks.
  • Automate workbook functionality.
  • Create sparklines and map data.
  • Forecast data.

Student Files

Associated course files are emailed to students. These files are to be used as you work through the course books putting into practice what you are studying.

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.

MOS Exams

On completion of this course, students can apply for the Microsoft Office Specialist Excel 2016 77-727 Exam and the Microsoft Office Specialist Excel 2016 Expert 77-728 Exam.

About the School

Questions

Similar Courses

  • Advanced Diploma in Software Engineering Technology - Artificial Intelligence (Optional Co-op) (Online)
    • Online Canada
    • Toronto, Canada
  • Advanced Diploma in Software Engineering Technology (Optional Co-op) (Online)
    • Online Canada
    • Toronto, Canada
  • Graduate Certificate in Mobile Applications Development (Online)
    • Online Canada
    • Toronto, Canada