Project Description

Overview

Office 2016 and 2019 – Please note that there are two versions of this course, 2016 and 2019.

This is an expert level course, please review the pre-requisites before you enrol.

If you are already competent in Microsoft Excel, this online course will give you the opportunity to upskill considerably and become an expert in the world’s most popular spreadsheet software. You will learn how to create, manage and distribute more complex professional spreadsheets for a range of dynamic situations. You will enhance productivity and deliver winning projects through customising your Excel environment. After completing the course you will be able to confidently craft custom business templates, multiple-axis financial charts, amortisation tables and inventory schedules.

You will learn to use the principle Excel Expert features to:

  • Manage workbook options and settings
  • Apply custom data formats and layouts
  • Create advanced formulas and functions
  • Create advanced charts and tables

What’s Included

  • All course content

  • Practice exercises and quizzes

  • A practice exam

  • A certification exam voucher

Course Handbook

Download Course Handbook 2019
Download Course Handbook 2016

Course Topics – 2019

Topic 1

Manage Workbook Operations and Settings

Topic 2

Manage and Format Data

Topic 3

Create Advanced Formulas and Macros

Topic 4

Manage Advanced Charts and Tables

Course Topics – 2016

Topic 1

Advanced Formatting

Topic 2

Advanced Functions and Formulas

Topic 3

Data Analysis Using Pivot Tables And Business Intelligence

Topic 4

Workbook Management Features

Topic 5

Advanced Charts, Functions and What-If Analysis

Topic 6

Data Filtering, Macros and Forms

Prerequisites & Requirements

The following course is a mandatory prerequisite:

  • Excel Core

If you have an ambition to harness the full functionality of Microsoft Excel and improve your strategic business thinking, this course is for you.

  • All students should have access to a PC or laptop running a supported version of Windows (e.g Windows 10).
  • Mac operating system devices can not be used for this course.
  • Apple/Android devices (Smart Phone/Tablets) are not supported and cannot be used for this course.
  • A broadband connection is essential to stream video content.

You require a web browser to view the content and access web platforms. Microsoft Access requires an Office 365 licence, which eCollege provides for the duration of the course.

Employment

Virtually all organisations use Excel at some level, so a  Microsoft Office Specialist accreditation as an Excel Expert will demonstrate a highly desirable set of skills to potential employers.

If you join virtually any organisation they will be using Excel at some level, so this is a very marketable and transferable skill. After you earn your Microsoft Office Specialist Excel accreditation you will be a valuable asset to current or potential employers.

Academic

All Microsoft Office 365 programs can be seamlessly integrated to form a full suite of powerful skills and tools. ECollege provides the following recommended courses:

  • Microsoft Word
  • Microsoft Word Expert
  • Microsoft PowerPoint
  • Microsoft Access

Course Code: NC 12399 (v2019)

Course Code: NC 11384 (v2016)

Is this course for you?

There are multiple ways to apply for this course, please check out the different options below.

At the moment, Solas has made eCollege courses available to the public. You can apply for the course using the button below.

Apply Now (2019)
Apply Now (2016)

If you are currently unemployed, you will find the contact details for your local Intreo office by using the button below. An Intreo officer will be able to guide you through your application.

Learn More

Skills To Advance aims to equip employees with the skills to progress in their current job, or to take advantage of new job opportunities.

Employees – Learn MOre
Employers – Learn More

Related Courses