Microsoft Excel & Excel Expert 2016 Bundle - E-learning

These Internationally Recognised Certifications are for individuals who want to learn the skills to get the most out of Microsoft Excel 2016.

This MOS Training course helps you prepare for the Microsoft Office Excel 2016 & Excel 2016 Expert Exams 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.

The expert course builds an advanced understanding of Excel, by teaching you how to create, manage, and distribute professional spreadsheets for a variety of specialized purposes.

The Excel 2016 course will cover the following modules:

1. Working with Microsoft Excel 2016
2. Using Office Backstage
3. Using Basic Formulas
4. Using Functions
5. Formatting Cells and Ranges
6. Formatting Worksheets
7. Managing Worksheets
8. Working with Data and Macros

The Excel 2016 Expert course will cover the following modules:

1. Managing and Protecting Workbooks
2. Applying Custom Formatting and Layouts
3. Using Advanced Functions and Analysing Data
4. Working with Advanced Charts and PivotTables

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.

None

E-Learning - Self Study

The following is included with the Course: (Digital Textbooks, Lecture Slides, Practice Exercises & Solutions, Study Guide, Instructional Videos and Exam Vouchers)