Part-Time Education & Training

This course is closed, and is not accepting applications.

<< Back to the course list

Microsoft Office Specialist Certification - Excel (Starts 25th Jan)

This course is CLOSED - no applications are currently being accepted for it.


Course Name: Microsoft Office Specialist - Excel

Course Outline:

This is a Beginner / Intermediate Microsoft Excel course that leads to Microsoft Excel Specialist Certification.

Course Overview:

The course uses a combination of class demonstrations and online resources and testing.

Contents: Creating and Manipulating Data

• Insert data by using AutoFill.

• Ensure data integrity.

• Modify cell contents and formats.

• Change worksheet views.

• Manage worksheets. Formatting Data and Content

• Format worksheets.

• Insert and modify rows and columns.

• Format cells and cell content.

• Format data as a table. Creating and Modifying Formulas

• Reference data in formulas. • Summarize data by using a formula.

• Summarize data by using subtotals.

• Conditionally summarize data by using a formula.

• Look up data by using a formula.

• Use conditional logic in a formula.

• Format or modify text by using formulas.

• Display and print formulas. Presenting Data Visually

• Create and format charts.

• Modify charts.

• Apply conditional formatting.

• Insert and modify illustrations.

• Outline data.

• Sort and filter data. Collaborating on and Securing Data

• Manage changes to workbooks.

• Protect and share workbooks.

• Prepare workbooks for distribution.

• Save workbooks.

• Set print options for printing data, worksheets, and workbooks.


Online Examination  - 100%

Certification: Microsoft Office Certified

Course fee230.00
Thursday 18/01/201819:00 - 22:00
Thursday 25/01/201819:00 - 22:00
Thursday 01/02/201818:00 - 22:00
Thursday 08/02/201818:00 - 22:00
Thursday 22/02/201818:00 - 22:00
Thursday 01/03/201818:00 - 22:00
Thursday 08/03/201818:00 - 22:00
Thursday 15/03/201818:00 - 22:00