Microsoft Office Suite

Overview

These modules are aimed at the work user who needs to demonstrate an in depth knowledge of these applications in the course of their job role.

Microsoft Word

This module will provide you with the ability to use the advanced features of word processing applications to enhance your work, improve productivity and save time. By successfully completing this module you will acquire a skill set over to save time in the creation, production, review and distribution of documents.

On completion of this module the candidate will be able to:

• Apply advanced text, paragraph, column and table formatting. Convert text to a table and vice versa.
• Work with referencing features like footnotes, endnotes and captions. Create tables of contents, indexes and cross-references.
• Enhance productivity by using fields, forms and templates.
• Apply advanced mail merge techniques and work with automation features.
• Use linking and embedding features to integrate data.
• Collaborate on and review documents. Work with master documents and subdocuments. Apply document security features.
• Work with watermarks, sections, and headers and footers in a document.

Microsoft Excel

Successful completion of this module will enable you to master the more advanced functions of spreadsheet applications, enabling you to produce more sophisticated  reports, and to perform complex mathematical and statistical calculations. These skills will save you considerable amounts of time and will improve your productivity.

On completion of this module the candidate will be able to:

• Apply advanced formatting options such as conditional formatting and customised number formatting and handle worksheets. 
• Use functions such as those associated with logical, statistical, financial and mathematical operations.
• Create charts and apply advanced chart formatting features.
• Work with tables and lists to analyse, filter and sort data. Create and use scenarios.
• Validate and audit spreadsheet data.
• Enhance productivity by working with named cell ranges, macros and templates. 
• Use linking, embedding and importing features to integrate data.
• Collaborate on and review spreadsheets. Apply spreadsheet security features.

Microsoft Access

The skills gained through this module will enable you to maximise advanced database functions, in order to manage and analyse high volumes of data. This will enable you to efficiently produce the quantity and quality of information that business today demands.

On completion of this module the candidate will be able to:

• Understand key concepts of database development and usage. 
• Create a relational database using advanced table creation features and complex relationships between tables.
• Design and use queries to create a table, update, delete and append data. Refine queries using wildcards, parameters and calculations.
• Use controls and subforms to enhance forms and improve functionality.
• Create report controls to perform calculations. Create subreports and enhance report presentation.
• Enhance productivity by working with macros and use linking and importing features to integrate data.

Microsoft PowerPoint

This module covers advanced presentation features that will allow you to use the presentation application to its full potential, and to plan and design more effective presentations that have greater impact and that will better engage and involve an audience.

On completion of this module the candidate will be able to:

• Understand target audience and venue considerations in presentation planning.
• Create and modify templates and format slide backgrounds.
• Enhance a presentation using built-in drawing and image tools.
• Apply advanced chart formatting features and create and edit diagrams.
• Insert movies and sound and apply built-in animation features. 
• Use linking, embedding, importing and exporting features to integrate data.
• Work with custom slide shows, apply slide show settings, and control a slide show.

Microsoft Outlook

This module introduces the 2019 interface and gets students up and running quickly working with messages, calendars, and contacts in Outlook.

On completion of this module the candidate will be able to:

• Learn about the new features in Outlook.
• Learn about the Ribbon, Tabs, Groups, and Commands.
• Explore the Backstage View.
• Set up accounts and work with messages.
• Work with calendars and contacts.
• Learn to work with tasks and notes.
• Learn to work with signatures and themes.
• Manage your inbox including filtering, creating search folders, and archiving.
• Work with multiple accounts.

Course Schedule

Course Offering

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

*SPECIAL OFFER: $350 per application.. 3 week / module - $1500 Special Price for all 5 applications (Word, Excel, Access, PowerPoint, Outlook).

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

Session	Start Date	End Date
Word	Thursday, November 26, 2020	Monday, December 14, 2020
Excel	Thursday, January 7, 2021	Monday, January 25, 2021
Access	Thursday, January 28, 2021	Monday, February 15, 2021
Power Point	Thursday, February 18, 2021	Monday, March 1, 2021
Outlook	Thursday, March 4, 2021	Monday, March 15, 2021
Word	Thursday, March 18, 2021	Thursday, April 8, 2021
Excel	Monday, April 12, 2021	Thursday, April 29, 2021
Access	Monday, May 3, 2021	Monday, May 24, 2021
Power Point	Thursday, May 27, 2021	Monday, June 14, 2021
Outlook	Thursday, June 17, 2021	Monday, June 28, 2021
Word	Thursday, July 1, 2021	Monday, July 19, 2021
Excel	Thursday, July 22, 2021	Thursday, August 12, 2021
Access	Monday, August 16, 2021	Thursday, September 2, 2021
Power Point	Monday, September 6, 2021	Thursday, September 16, 2021
Outlook	Monday, September 20, 2021	Thursday, September 30, 2021
Word	Monday, October 4, 2021	Thursday, October 21, 2021
Excel	Monday, October 25, 2021	Thursday, November 11, 2021
Access	Monday, November 15, 2021	Thursday, December 2, 2021

Additional Information

Exam(s)

Students are required to complete a project or practical exam upon completion of the course. Students will receive a certificate of completion.

Book(s)

No books Required. CTS will provide all handouts for the programme.

Prerequisites

Candidates are expected to be computer literate having completed a Computer Literacy programme or attain a similar level of expertise.

Tuition Cost

The cost of the programme is TTD $1,500.00 for all 5 modules or $350.00 per module.