Project Description

Overview

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 Topics

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 PC or Laptop running Windows. Apple Macs/Android devices 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

Is this course for you?

Find out how to apply by tapping the button below.

Course Code: NC 11384 (v2016)

Apply Now

Related Courses