MOS Excel 2016 Course

Distance Learning Centre

Programme Description

MOS Excel 2016 Course

Distance Learning Centre

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.

This school offers programs in:
  • English
Distance Learning Centre

Last updated March 21, 2017
Duration & Price
This course is Online
Start Date
Start date
Open Enrolment
Duration
Duration
100 
Part time
Price
Price
175 GBP
Information
Deadline
Locations
United Kingdom - UK Online
Start date: Open Enrolment
Application deadline Request Info
End date Request Info
Dates
Open Enrolment
United Kingdom - UK Online
Application deadline Request Info
End date Request Info