Microsoft Excel

Overview

Overview

Microsoft Excel is the world’s most popular and powerful spreadsheet software, with 750 million global users. Microsoft CEO has also declared Excel the company’s most important consumer product. Through this online course, you will learn how to create spreadsheets and analyse large sets of data using an array of techniques. You will gain an insight into the dynamic functionality of Excel, from budget planning to creating charts and diagrams, performing complex calculations and creating schedules.

You will learn to use the principle Excel features to:

Create and manage worksheets and workbooks
Create cells and ranges
Create tables
Apply formulas and functions
Create charts and objects

Duration: 16 weeks
Exam: Microsoft Office Specialist Excel 2019 – MO-200. Read more about the Excel 2019 certification.
Support: eTutor Supported

What’s Included

All course content
Practice exercises and quizzes
A practice exam
A certification exam voucher

Course Handbook

Download Course Handbook 2019

Video

Content

Course Topics – 2019

Topic 1

Manage Worksheets and Workbooks

Topic 2

Manage Data Cells and Rages

Topic 3

Manage Tables and Table Data

Topic 4

Perform Operations by using Formulas and Functions

Topic 5

Manage Charts

Requirements

Prerequisites & Requirements

Prerequisites

Students must have previous IT knowledge as the MOS Core courses are intermediate courses. This is not a beginners course.

Learners should have the ICDL course completed.

Is this course for me?

If you have a strong interest in developing highly marketable skills and gaining an insight into the strategic power of spreadsheets, this course is for you.

What are the hardware requirements?

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.

What software will I need?

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

Progression

Employment

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: