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
Access	Thursday, November 28, 2019	Monday, December 16, 2019
Power Point	Monday, January 6, 2020	Thursday, January 16, 2020
Word	Monday, February 3, 2020	Thursday, February 20, 2020
Excel	Thursday, February 27, 2020	Monday, March 16, 2020
Access	Thursday, March 19, 2020	Thursday, April 9, 2020
Power Point	Thursday, April 16, 2020	Monday, April 27, 2020
Outlook	Thursday, April 30, 2020	Monday, May 11, 2020
Word	Thursday, May 14, 2020	Thursday, June 4, 2020
Excel	Monday, June 8, 2020	Monday, June 29, 2020
Access	Thursday, July 2, 2020	Monday, July 20, 2020
Power Point	Thursday, July 23, 2020	Monday, August 3, 2020
Outlook	Thursday, August 6, 2020	Monday, August 17, 2020
Word	Thursday, August 20, 2020	Thursday, September 10, 2020
Excel	Monday, September 14, 2020	Monday, October 5, 2020
Access	Thursday, October 8, 2020	Monday, October 26, 2020
Power Point	Monday, October 26, 2020	Thursday, November 5, 2020
Outlook	Monday, November 9, 2020	Thursday, November 19, 2020
Word	Monday, November 23, 2020	Monday, December 7, 2020
Excel	Thursday, December 10, 2020	Thursday, December 17, 2020
Outlook	Monday, January 20, 2020	Thursday, January 30, 2020

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.