MOS Excel 2016 Course

General

Program Description

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.

Last updated February 2018

About the School

Distance Learning Courses Limited (t/a Distance Learning Centre) is a leading provider of distance learning/home study/Open Learning courses and a respected course developer. As well as developing our... Read More