Where the Experience is Beyond the Academics Photo Gallery

Microsoft Office Suite

Microsoft Office Suite


The Microsoft Office course at CTS College is a comprehensive training program covering essential applications for professional productivity. Participants gain proficiency in Microsoft Word for document creation, Excel for spreadsheet management, PowerPoint for dynamic presentations, Access for database development, Outlook for efficient email communication, and OneNote for organised note-taking. This course provides hands-on experience and practical skills in each module, empowering individuals with a well-rounded understanding of the Microsoft Office suite. Whether for academic, personal or professional use, this course equips participants with the necessary tools to navigate and harness the full potential of Microsoft Office applications in diverse settings.

Note: Students can choose individual modules / applications or do the entire suite of products (at a reduced cost).


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

  • Use the Microsoft Office Suite of Applications i.e. Word, Excel, Powerpoint, Access, Outlook and OneNote


Below are some of the main features of this course:

  • Short duration - each module / application 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 Office
  • 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 6 modules / applications make up this programme:

1: Microsoft Word

This program allows you to create professional documents. In this module, students will learn the following:

Office workspace basics

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

Introduction to Word

  • What is Word
  • How to open a document
  • Changing views
  • Navigating documents
  • How to create documents
  • Using templates
  • Saving documents
  • How to close documents

Creating and editing text

  • Entering text
  • How to select text
  • Moving and copying text
  • Using repeat, undo and redo
  • Using autocorrect
  • Inserting symbols
  • Inserting fields

Formatting text

  • Introduction to formats and styles
  • Applying font formats
  • Text alignment
  • Changing indents and spacing
  • Working with tabs
  • Applying styles
  • Modifying styles
  • Revealing and clearing formats
  • Using the format painter

Designing page layouts

  • Exploring page layout options
  • Changing margins
  • Adding sections and page breaks
  • Creating columns
  • Adding bullets and numbering
  • Applying borders and shading

Mail merge

  • Envelopes
  • Labels
  • Merging letters

Collaborating on documents

  • Adding comments
  • Tracking document changes
  • Reviewing tracked changes
  • E-mailing documents for review
  • Combining reviewed documents
  • Using the document inspector
  • Creating folders

Printing and converting documents

  • Using print preview
  • Printing documents
  • Printing envelopes and labels
  • Saving documents in different formats
  • Saving documents as web pages

Working with graphics

  • Inserting pictures
  • Resizing and moving pictures
  • Inserting shapes
  • Adding text boxes
  • Creating charts
  • Inserting SmartArt


  • Creating ordered and unordered lists
  • Multilevel list


  • Using and formatting columns

Creating and formatting tables

  • Creating a table
  • Converting text to a table
  • Formatting a table
  • Modifying the table layout
  • Using table templates

Refining document content

  • Exploring the research task pane
  • Using the thesaurus
  • How to find and replace text
  • Correcting spelling and grammar
  • Using word count
  • Working with document properties
  • Adding a hyperlink

2: microsoft excel

This is a popular spreadsheet management program developed by Microsoft. In this module, students will learn the following:

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

3: microsoft powerpoint

PowerPoint is software developed by Microsoft to help you create quality presentations. In this module, students will learn the following:

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
  • Getting help

Introduction to PowerPoint

  • What is PowerPoint
  • Opening a presentation
  • Changing views
  • Using grids and guides
  • Saving and closing a presentation
  • Managing files and folders

Adding and formatting text

  • Creating a new presentation
  • Entering text on a slide
  • Changing text formats
  • Using the format painter
  • Formatting bullets
  • Aligning text
  • Working with tabs

Customising presentations

  • Using templates
  • Adding a slide
  • Changing a slide layout
  • Adding a picture
  • Customising templates
  • Using the slide master
  • Adding headers and footers
  • Adding speaker notes
  • Arranging slides

Working with shapes and pictures

  • Introduction to drawing tools
  • Inserting shapes
  • Adding text to shapes
  • Formatting shapes
  • Inserting and formatting picture files
  • Arranging objects
  • Adding an action button

Adding objects and effects

  • Adding a table
  • Adding a chart
  • Adding SmartArt
  • Adding a hyperlink
  • Adding transition effects
  • Adding animation effects
  • Adding a sound clip
  • Adding a video

Useful tools

  • Working in outline view
  • Importing an outline from Word
  • Finding and replacing text
  • Using proofing tools
  • Using autocorrect
  • Printing your presentation

Delivering your presentation

  • Creating a custom show
  • Rehearsing a slide show
  • Collaborating on presentations
  • Packaging a presentation
  • Running a slide show
  • Broadcasting a presentation to the web

4: microsoft access

Microsoft Access is a database management system and is a part of Microsoft Office. In this module, students will learn the following:

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
  • Getting help

Introduction to Access

  • What is an Access database
  • Opening a database file
  • Exploring database objects
  • Creating a database
  • Changing views
  • Printing database objects
  • Saving and closing a database file

Working with tables

  • What is a table
  • Working with datasheets
  • Moving among records
  • Updating records
  • Adding records to a table
  • Selecting rows and columns
  • Finding records
  • Sorting records
  • Filtering records

Designing tables

  • Adding a table to a database
  • Adding fields to a table
  • Adding a lookup field
  • Setting a primary key
  • Saving design changes
  • Importing data
  • Exporting data
  • Performing database maintenance

Creating and running queries

  • What is a query
  • Creating a query
  • Working with queries
  • Saving and running a query
  • Creating calculated fields
  • Understanding query properties
  • Creating multi-table select queries
  • Joining tables
  • Enforcing referential integrity

Using forms

  • What is a form
  • Using the form tool
  • Creating a form with the form wizard
  • Working in design view
  • Changing the form layout
  • Using calculated controls
  • Working with records on a form

Generating reports

  • What is a report
  • What is a report tool
  • Previewing and printing a report
  • Saving a report
  • Designing a report
  • Changing a report layout
  • Understanding controls
  • Using a calculated control
  • Analysing dependencies

Completing the desktop application

  • Designing the navigation form
  • Creating a database password
  • Creating a backup of database

5: microsoft outlook

Microsoft Outlook is an extremely popular e-mail program used by millions of people worldwide. In this module, students will learn the following:

Office workspace basics

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

Introduction to Outlook

  • What is Outlook
  • Using the navigation pane
  • Working with folders
  • Exploring the inbox
  • Reading your e-mail
  • Replying to an e-mail message
  • Forwarding a message
  • Sending a new message
  • Adding an attachment
  • Viewing sent items

Managing messages

  • Flagging messages for follow up
  • Using multiple e-mail accounts
  • Adding a signature
  • Formatting messages
  • Setting message priorities
  • Setting delivery options
  • Using the rules wizard
  • Printing your e-mail
  • Saving messages

Maintaining contacts

  • Adding contacts
  • Viewing contact information
  • Modifying and deleting contacts
  • Creating a contact group
  • Sending a message to a contact
  • Using Outlook to call a contact
  • Printing contact information
  • Exporting contact information
  • Importing contact information

Coordinating calendars

  • Viewing calendar information
  • Scheduling appointments
  • Adding recurring appointments
  • Exploring calendar settings
  • Planning a meeting
  • Scheduling a meeting
  • Responding to meeting requests
  • Printing your calendar

Scheduling tasks

  • Creating tasks
  • Using the task form
  • Viewing tasks
  • Assigning tasks to others
  • Responding to task requests
  • Keeping notes

Organising information

  • Managing folders
  • Copying items among folders
  • Locating items
  • Creating categories
  • Arranging items
  • Controlling junk e-mail
  • Design custom views

6: microsoft onenote

Microsoft OneNote is a digital notebook that is a part of the Microsoft office suite. In this module, students will learn the following:

Introduction to OneNote

  • What is OneNote
  • Using OneNote
  • Getting started with OneNote
  • Exploring the OneNote user interface
  • Working with the ribbon
  • Understanding backstage view
  • Customising the quick access toolbar
  • Getting help

Collecting information

  • Creating and configuring notebooks
  • Creating pages and subpages
  • Taking and saving notes
  • Entering content onto a page
  • Formatting notes
  • Spellchecking notes

Adding and annotating content

  • Adding and organising sections and pages
  • Copying content to notebooks
  • Attaching files
  • Adding screen-clippings to notebooks
  • Adding pictures
  • Introducing penmode
  • Converting handwriting
  • Adding equations
  • Working with audio and video
  • Tagging notes

Formatting and sharing notebooks

  • Sorking with notebook templates
  • Setting default templates to sections
  • Changing backgrounds
  • Printing notebook content
  • Saving and converting notebooks


Course Offering

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

*SPECIAL OFFER: Special Pricing for All 6 Applications: $1500 (Word, Excel, Access, PowerPoint, Outlook, OneNote) Individual Application Price: $350 per application

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

Session Start Date End Date
Access Thursday, January 25, 2024 Thursday, February 15, 2024
PowerPoint Monday, February 19, 2024 Thursday, February 29, 2024
OneNote Monday, March 4, 2024 Monday, March 4, 2024
Outlook Thursday, March 7, 2024 Thursday, March 14, 2024
Word Monday, March 18, 2024 Monday, April 8, 2024
Excel Thursday, April 11, 2024 Monday, April 29, 2024
Access Thursday, May 2, 2024 Monday, May 20, 2024
PowerPoint Thursday, May 23, 2024 Thursday, June 6, 2024
OneNote Monday, June 10, 2024 Monday, June 10, 2024
Outlook Thursday, June 13, 2024 Thursday, June 20, 2024
Word Monday, June 24, 2024 Thursday, July 11, 2024
Excel Monday, July 15, 2024 Monday, August 5, 2024
Access Thursday, August 8, 2024 Monday, August 26, 2024
PowerPoint Thursday, August 29, 2024 Monday, September 9, 2024
OneNote Thursday, September 12, 2024 Thursday, September 12, 2024
Outlook Monday, September 16, 2024 Monday, September 23, 2024
Word Thursday, September 26, 2024 Monday, October 14, 2024
Excel Thursday, October 17, 2024 Thursday, November 7, 2024
Access Thursday, November 7, 2024 Thursday, November 28, 2024
PowerPoint Monday, December 2, 2024 Thursday, December 12, 2024
OneNote Monday, December 16, 2024 Monday, December 16, 2024
Outlook Thursday, December 19, 2024 Monday, December 23, 2024

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


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

  • A practical exam for each module / application


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 amount 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.


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


This course is offered at the affordable price of $350 per module / application or a discounted rate of $1,500 for all 6 modules / applications. 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

Paid at the Administration Office

Made Payable to CTS College

Online Bank Transfer

Paid via Online Banking

Click to view full instructions »

Student Support


At CTS College, we believe in crafting an extraordinary student experience. This is why we have selected Ms. Gail Pettier to facilitate the Web Design 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: Certifications@CTSCollege.com

We are an ACTT recognised institution and partner with international awarding bodies