Home › Certifications › I.T. Certifications › Microsoft Excel

Microsoft Excel

Overview

The Microsoft Excel course at CTS College is a practical, skills-focused programme that transforms you into a spreadsheet power user. You'll master essential formulas, data analysis tools, pivot tables, and dynamic charts while learning time-saving automation techniques. Designed for professionals across industries, this hands-on training equips you with the skills to organise, analyse, and visualise data efficiently — turning raw numbers into actionable business insights.

Note: Students can choose to do the entire suite of Microsoft Office applications (6 in total) at a disounted rate.

Benefits

Upon completion of this programme, students would be able to:

Use Microsoft Excel

Features

Below are some of the main features of this course:

Short duration -can be completed in only 3 weeks with 2 classes per week
Competitive rates with flexible payment plans
Experienced lecturer with excellent student support
Online classes which are also recorded for further review
Support group via WhatsApp with the lecturer, programme manager and students

Target Audience

This course is perfect for:

Persons interested in learning Microsoft Excel
Office Assistants
Secretaries
Business Owners and Entrepreneurs

Entry Requirements

In order to enrol for this programme, students are expected to be computer literate.

Course Content

The following would be covered in this course:

Office workspace basics

Basic window elements
Exploring Office backstage
Working with the ribbon
Customising the quick access toolbar
Working with keytips
Using the status bar

Introduction to Excel

What is Excel
Getting to know the Excel window
Moving the cell selector
Opening a workbook
Navigating a workbook
Selecting cells
Creating workbooks
Saving and closing a workbook

Entering and editing data

Entering text, numbers and dates
Editing data
Using autocomplete and autofill
Copying data
Moving and clearing data
Using undo and redo
Finding and replacing data

Introduction to formulas and functions

What are formulas and functions
Entering formulas
Entering functions
Using the insert function tool
Using autosum
Copying and moving formulas

Working with functions

Using functions
Testing conditions with if
Using date and time functions
Using linked values in formulas
Copying formula values
Controlling automatic calculations
Conditional formatting
Vlookup and Hlookup
Pivot tables and charts

Formatting data

Introduction to formatting
Applying number formats
Applying font formats
Changing cell alignment
Applying cell styles
Copying formats
Clearing formats
Finding and replacing formats

Formatting worksheets

Inserting and deleting rows and columns
Inserting and deleting cells
Adjusting column and row sizes
Hiding worksheet components
Inserting and deleting worksheets
Copying and moving worksheets
Customising sheet tabs
Adding a worksheet background

Adding charts and graphics

Creating a chart
Enhancing a chart
Modifying chart data
Changing chart types
Drawing shapes
Inserting pictures
Creating SmartArt

Viewing and printing workbooks

Changing view options
Splitting and freezing a worksheet
Sorting and filtering data
Customising the page layout
Adding headers and footers
Modifying page breaks
Previewing and printing the worksheet

Managing workbooks

Arranging multiple workbooks
Adding hyperlinks
Working with comments
Saving workbooks

Schedule

Course Offering

Day	Time	Duration	Contact Hours	Cost	Lecturer
Monday, Thursday	05:30 pm to 08:30 pm	3 Weeks	18 hours Hours	$350.00	Ms. Gail Pettier

Session - Monday, Thursday (05:30 pm to 08:30 pm)

Session	Start Date	End Date
2025 - Microsoft Excel - Online Classes	Thursday, May 8, 2025	Monday, May 26, 2025
2025 - Microsoft Excel - Online Classes	Monday, August 11, 2025	Thursday, August 28, 2025
2025 - Microsoft Excel - Online Classes	Thursday, November 13, 2025	Monday, December 1, 2025

Delivery Mode

Online Classes

This course will be delivered via live online classes. Students will be provided with a link to join the class as well as other relevant instructions at least one day before the start of each class. These classes are also recorded - therefore students have the option to review the course content as often as they like.

Additional Info

Assessment

Students would be required to complete the following assessment(s) for this course:

A practical exam

Certification

In order to receive the CTS College certificate of completion or participation for this course, students must attend a minimum of 75% of classes and pay any outstanding fees. Where applicable, students who do not meet the necessary assessment requirements, but attended the required number of classes would receive a CTS College certificate of participation.

Certificates would be provided in digital format which would allow students to access, print and share their certificates 24/7 on demand. For more information on our digital certificates please click here.

Note: Certificates would be provided for each module completed.

Resources

CTS College will provide all handouts in digital format for this programme.

Interactive Course Calendar

Explore our comprehensive Interactive Course Calendar, with a list of all our courses and their costs and delivery modes offered throughout the year.

View Calendar »

Fees & Payment

Cost

This course is offered at the affordable price of $350 or a discounted rate of $1,500 for all 6 Microsoft Office applications (Access, Excel, OneNote, Outlook, Powerpoint and Word). In order to start the course, students must pay a minimum of 50% before the first class.

Payment Plans

Students can be given a payment plan where the initial downpayment is made, with an arrangement for the remaining balance to be paid over the duration of the course. Please feel free to contact us to discuss a payment plan customised for you.

Payment Methods

The following table shows the details for the 4 convenient ways to pay the CTS College fees for this programme:

Payment Method	Details
Linx	Paid at the Administration Office
Credit Card	Paid at the Administration Office
Cheque	Paid at the Administration Office Made Payable to CTS College
Online Bank Transfer	Paid via Online Banking Click to view full instructions »

Student Support

Facilitator

At CTS College, we believe in crafting an extraordinary student experience. This is why we have selected Ms. Gail Pettier to facilitate the Microsoft Excel course. Ms. Pettier not only imparts knowledge, but creates a learning experience where students feel valued and appreciated. She is also committed to shaping a transformative learning journey and creating an educational adventure that goes beyond the ordinary.

Gail Pettier, a Software Training Specialist, currently serves as a Software/Technology Consultant at CTS College. In addition to her role at the college, she freelances as a Graphic/Web Designer and Writer, showcasing her versatility in the tech and creative domains. Recognised as an effective team player, Gail is celebrated for her creativity, flexibility, sense of humor, pride and unwavering company loyalty. Her skills encompass time management, interpersonal relationships, teamwork and a strong commitment to moral and ethical standards.

Gail's aspirations include fostering a friendly and casual work environment, leading a talented team and tackling cutting-edge technical challenges. She aims to focus on building social platforms tailored for leaders in both educational and corporate environments, demonstrating her dedication to innovation and excellence.

Programme Management

The programme management team is responsible for the management of this course. If you would like further information or clarification on this programme please contact:

Mr. Matthew Christian
Programme Manager
Phone: (868) 720-2939 / (868) 740-9095

E-mail: Certificationshidden@CTSCollege.com