Introduction

MOS: Microsoft Excel 2016 (77-727)

Microsoft Office Specialist (MOS) certification provides industry-leading assessments of skills and knowledge, giving students and professionals real-world exercises to appraise their understanding of Microsoft Office.

Who Should Enrol

This certification is for individuals who want to learn the skills to get the most out of Microsoft Excel 2016

Course Design

This MOS Training course helps you prepare for Microsoft Office Excel 2016 Exam 77-727 and builds a fundamental understanding of Excel 2016 and the ability to complete tasks independently. Participants learn to create and edit a workbook with multiple sheets and use graphic elements to represent data visually including professional-looking budgets, financial statements, performance charts, and data-entry logs.

Course Content

This course will cover the following modules:

  • Working with Microsoft Excel 2016
  • Using Office Backstage
  • Using Basic Formulas
  • Using Functions
  • Formatting Cells and Ranges
  • Formatting Worksheets
  • Managing Worksheets
  • Working with Data and Macros
  • Using Advanced Formulas
  • Securing and Sharing Workbooks
  • Creating Charts
  • Adding Pictures and Shapes to a Worksheet

Certification

To obtain an Internationally Recognised Microsoft Certification, participants will be required to complete the assessment process which consists of a 50 min online practical exam per course. This exam needs to be taken at a Certiport Testing Centre. Please see the Examination Process video for more information.

Assessment

Contact

FPD School of Information Technology
+24 87 821 1109
itschool@foundation.co.za




Enquire Now