Where the Experience is Beyond the Academics Photo Gallery

Microsoft Office Suite

Microsoft Office Suite

Course Overview

Microsoft Office has become a leading platform to drive productivity at home and in the workplace. Office has made carrying out many computer based tasks easier for all of us. From managing emails in Outlook to building spreadsheets in Excel, to creating letters or completing assignments and other documents in Microsoft Word to creating amazing presentations using PowerPoint or developing a database solution using Microsoft Access, Microsoft Office has become the most popular day to day tool used in most organisations.

Students can choose individual modules or do the entire suite of products (at a very special price).

WHAT WILL BE COVERED?

Microsoft Word
This program allows you to create high quality, professional-looking documents using the finest document formatting tools. In this unit, students will learn how to create, edit, save, share, and access documents online from any internet browser.

Microsoft Excel
This is a popular spreadsheet management program developed by Microsoft. This powerful program allows you to analyze, manage and share data in more ways than ever before. With the analysis tools, you can track and highlight important data trends and share data.

Microsoft PowerPoint
PowerPoint is software developed by Microsoft to help you create quality presentations. PowerPoint is used for business and academic applications as a fast and effective way to present information and ideas.

Microsoft Access
Microsoft Access is a database management system and is a part of Microsoft Office. Learn the features of the latest version of this powerful program that allows users to store and track large amounts of data, and analyze the data for various applications.

Microsoft Outlook
Microsoft Outlook is an extremely popular e-mail program used by millions of people worldwide. This e- mail program promises greater e-mail organization, search, communication and social networking features.

OneNote
Microsoft OneNote is a digital notebook that is a part of the Microsoft Office Suite. OneNote creates a single place to store all of your notes and information. It provides the flexibility to gather and organize text, pictures, audio and video recordings, and more, in one location on your computer.

Course Description

This course includes a broad series of lessons and activities that offer a variety of modalities for ultimate student engagement and content retention. Each unit contains a series of lessons that include introduction of content, virtual demonstration of that content, and repeated opportunity to practice that content, along with a quizzes and an exam per module.

Course Objectives

Microsoft Word

Office Workspace Basics
• Basic Window Elements
• Exploring Office Backstage
• Working with the Ribbon
• Customizing 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
• Pictures, Inserting
• Inserting Pictures
• Resizing and Moving Pictures
• Inserting Shapes
• Adding Text Boxes
• Creating Charts
• Inserting SmartArt

Lists
• Creating Ordered and Unordered Lists
• Multilevel List

Columns
• 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

Microsoft Excel

Office Workspace Basics
• Basic Window Elements
• Exploring Office Backstage
• Working with the Ribbon
• Customizing 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
• Customizing 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
• Customizing 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

Microsoft Powerpoint

Office Workspace Basics
• Basic Window Elements
• Exploring Office Backstage
• Working with the Ribbon
• Customizing 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

Customizing Presentations
• Using Templates
• Adding a Slide
• Changing a Slide Layout
• Adding a Picture
• Customizing 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

Microsoft Access

Office Workspace Basics
• Basic Window Elements
• Exploring Office Backstage
• Working with the Ribbon
• Customizing 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
• Analyzing Dependencies

Completing the Desktop Application
• Designing the Navigation Form
• Creating a Database Password
• Creating a Backup of Database

Microsoft Outlook

Office Workspace Basics
• Basic Window Elements
• Exploring Office Backstage
• Working with the Ribbon
• Customizing 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

Organizing Information
• Managing Folders
• Copying Items among Folders
• Locating Items
• Creating Categories
• Arranging Items
• Controlling Junk E-mail
• Design Custom Views

Microsoft OneNote

Introduction to OneNote
• What is OneNote?
• Using OneNote
• Getting Started with OneNote
• Exploring the OneNote User Interface
• Working with the Ribbon
• Understanding Backstage View
• Customizing 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 Organizing 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
• Working with Notebook Templates
• Setting Default Templates to Sections
• Changing Backgrounds
• Printing Notebook Content
• Saving and Converting Notebooks

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 6 applications (Word, Excel, Access, PowerPoint, Outlook, OneNote).

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

Session Start Date End Date
Access Monday, April 19, 2021 Thursday, May 6, 2021
PowerPoint Monday, May 10, 2021 Monday, May 24, 2021
OneNote Thursday, May 27, 2021 Thursday, May 27, 2021
Outlook Monday, June 7, 2021 Monday, June 14, 2021
Word Thursday, June 17, 2021 Monday, July 5, 2021
Excel Thursday, July 8, 2021 Monday, July 26, 2021
Access Thursday, July 29, 2021 Thursday, August 19, 2021
PowerPoint Monday, August 23, 2021 Thursday, September 2, 2021
OneNote Monday, September 6, 2021 Monday, September 6, 2021
Outlook Thursday, September 9, 2021 Thursday, September 16, 2021
Word Monday, September 20, 2021 Thursday, October 7, 2021
Excel Monday, October 11, 2021 Thursday, October 28, 2021
Access Monday, November 1, 2021 Thursday, November 18, 2021
PowerPoint Monday, November 22, 2021 Thursday, December 2, 2021
OneNote Monday, December 6, 2021 Monday, December 6, 2021
Outlook Thursday, December 9, 2021 Thursday, December 16, 2021

Student Support

Programme Manager

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

Mr. Matthew Christian
Phone: 720-2939
E-mail: mchristian@ctscollege.com

Additional Information

Exam(s)

Students are required to complete a project or practical exam upon completion of the module. 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.

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

Affiliates