Microsoft Office 2016 Essentials - CPD & IAO Accredited

COURSE CURRICULUM

Module : 1

Identify the Components of the Word Interface
Create a Word Document
Help
Navigate and Select Text
Modify Text
Find and Replace Text
Apply Character Formatting
Align Text Using Tabs
Display Text as List Items
Control Paragraph Layout
Apply Borders and Shading
Apply Styles
Manage Formatting
Insert a Table
Modify a Table
Format a Table
Convert Text to a Table
Sort a List
Renumber a List
Customize a List
Insert Symbols and Special Characters
Add Images to a Document
Apply a Page Border and Color
Add a Watermark
Add Headers and Footers
Control Page Layout
Check Spelling and Grammar
Other Proofing Tools
Check Accessibility
Customize the Word Interface
Additional Save Options
Manage Additional File Types
Activities – Microsoft Word 2016 for Beginners
Module : 2
Identify the Elements of the Excel Interface
Activity – Identify the Elements of the Excel Interface
Create a Basic Worksheet
Activity – Create a Basic Worksheet
Use the Help System
Activity – Use the Help System
Create Formulas in a Worksheet
Activity – Create Formulas in a Worksheet
Insert Functions in a Worksheet
Activity – Insert Functions in a Worksheet
Reuse Formulas
Activity – Reuse Formulas
Manipulate Data
Activity – Manipulate Data
Insert, Manipulate, and Delete Cells, Columns, and Rows
Activity – Insert, Manipulate, and Delete Cells, Columns, and Rows
Search For and Replace Data
Activity – Search For and Replace Data
Spell Check a Worksheet
Activity – Spell Check a Worksheet
Modify Fonts
Activity – Modify Fonts
Add Borders and Colors to Cells
Activity – Add Borders and Colors to Cells
Apply Number Formats
Activity – Apply Number Formats
Align Cell Contents
Activity – Align Cell Contents
Apply Cell Styles
Activity – Apply Cell Styles
Define the Basic Page Layout for a Workbook
Activity – Define the Basic Page Layout for a Workbook
Refine the Page Layout and Apply Print Options
Activity – Refine the Page Layout and Apply Print Options
Format Worksheet Tabs
Activity – Format Worksheet Tabs
Manage Worksheets
Activity – Manage Worksheets
Manage the View of Worksheets and Workbooks
Activity – Manage the View of Worksheets and Workbooks
Customize General and Language Options
Activity – Customize General and Language Options
Customize Formula Options
Activity – Customize Formula Options
Customize Proofing and Save Options
Activity – Customize Proofing and Save Options
Customize the Ribbon and Quick Access Toolbar
Activity – Customize the Ribbon and Quick Access Toolbar
Customize the Functionality of Excel by Enabling Add-Ins
Activity – Customize the Functionality of Excel by Enabling Add-Ins
Customize Advanced and Trust Center Options
Activity – Customize Advanced and Trust Center Options
Activities – Microsoft Excel 2016 for Beginners

Module : 3

Navigate the PowerPoint Environment
ACTIVITY – NAVIGATING THE POWERPOINT 2016 USER INTERFACE
Create and Save a PowerPoint Presentation
ACTIVITY – CREATING AND SAVING A POWERPOINT PRESENTATION
Use Help
ACTIVITY – USING POWERPOINT HELP
Select a Presentation Type
ACTIVITY – SELECTING A PRESENTATION TYPE
Build a Presentation
ACTIVITY – BUILDING A PRESENTATION
Lay Out a Presentation
ACTIVITY – LAYING OUT A PRESENTATION
Edit Text
ACTIVITY – EDITING TEXT
View and Navigate a Presentation
ACTIVITY – VIEWING A PRESENTATION
Format Characters
ACTIVITY – FORMATTING CHARACTERS
Format Paragraphs
ACTIVITY – FORMATTING PARAGRAPHS
Format Text Boxes
ACTIVITY – FORMATTING TEXT BOXES
Insert Images
ACTIVITY – INSERTING IMAGES
Insert Shapes
ACTIVITY – INSERTING SHAPES
Insert WordArt
ACTIVITY – INSERT WORDART
Edit Objects
ACTIVITY – EDITING OBJECTS
Format Objects
ACTIVITY – FORMATTING OBJECTS
Group Objects
ACTIVITY – GROUPING OBJECTS
Arrange Objects
ACTIVITY – ARRANGING OBJECTS
Animate Objects
ACTIVITY – ANIMATING OBJECTS
Create a Table
ACTIVITY – CREATING A TABLE
Format a Table
ACTIVITY – FORMATTING A TABLE
Insert a Table from Other Microsoft Office Applications
ACTIVITY – INSERTING A TABLE FROM MICROSOFT EXCEL
Create a Chart
ACTIVITY – CREATING A CHART
Format a Chart
ACTIVITY – FORMATTING A CHART
Manipulate a Chart
ACTIVITY – MANIPULATING A CHART
Insert a Chart from Microsoft Excel
ACTIVITY – INSERTING A CHART FROM MICROSOFT EXCEL
Review Your Presentation
ACTIVITY – REVIEWING YOUR PRESENTATION
Apply Transitions
ACTIVITY – APPLYING TRANSITIONS
Print Your Presentation
ACTIVITY – PRINTING YOUR PRESENTATION
Deliver Your Presentation
ACTIVITY – DELIVERING YOUR PRESENTATION
Activities – Microsoft PowerPoint 2016 for Beginners

Module : 4

Navigate the Outlook Interface
ACTIVITY – NAVIGATING THE OUTLOOK INTERFACE
Perform Basic E-mail Functions
ACTIVITY – PERFORMING BASIC E-MAIL FUNCTIONS
Use Outlook Help
ACTIVITY – GETTING HELP IN MICROSOFT OUTLOOK 2016
Create an E-mail Message
ACTIVITY – CREATING AN E-MAIL MESSAGE
Check Spelling and Grammar
ACTIVITY – CHECK SPELLING AND GRAMMAR
Format Message Content
ACTIVITY – FORMAT MESSAGE CONTENT
Attach Files and Items
ACTIVITY – ATTACHING A FILE TO A MESSAGE
Enhance an E-mail Message
ACTIVITY – ENHANCING AN E-MAIL MESSAGE
Manage Automatic Message Content
ACTIVITY – MANAGING AUTOMATIC MESSAGE CONTENT
Customize Reading Options
ACTIVITY – CUSTOMIZING READING OPTIONS
Work with Attachments
ACTIVITY – WORKING WITH ATTACHMENTS
Manage Your Message Responses
ACTIVITY – MANAGING YOUR MESSAGE RESPONSES
Manage Messages Using Tags, Flags, and Other Commands
ACTIVITY – MANAGING MESSAGES USING TAGS, FLAGS AND OTHER COMMANDS
Organize Messages Using Folders
ACTIVITY – ORGANIZING MESSAGES USING FOLDERS
View the Calendar
ACTIVITY – CUSTOMIZING YOUR CALENDAR VIEW
Manage Appointments
ACTIVITY – MANAGING APPOINTMENTS
Manage Meetings
ACTIVITY – CREATING AND MANAGING MEETINGS
Print Your Calendar
ACTIVITY – PRINTING YOUR CALENDAR
Create and Update Contacts
ACTIVITY – CREATING AND UPDATING CONTACTS
View and Organize Contacts
ACTIVITY – VIEW AND ORGANIZE CONTACTS
Create Tasks
ACTIVITY – CREATING TASKS
Manage Tasks
ACTIVITY – MANAGING TASKS
Manage Notes
ACTIVITY – CREATING AND MANAGING NOTES
Customize the Outlook Interface
ACTIVITY – CUSTOMIZING THE OUTLOOK INTERFACE
Create and Manage Quick Steps
ACTIVITY – CREATING AND MANAGING QUICK STEPS
Activities – Microsoft Outlook 2016 for Beginners

Module : 5

Orientation to Microsoft Access
Create a Simple Access Database
Get Help in Microsoft Access
Modify Table Data
Working With Records
Sort and Filter Records
Create Lookups
Join Data from Different Tables in a Query
Sort and Filter Data in a Query
Perform Calculations in a Query
Create Parameter Queries
Create Action Queries
Create Find Duplicate and Find Unmatched Queries
Summarize Data
Create a Report
Add Controls to a Report
Enhance the Appearance of a Report
The Access Options Dialog Box
Create a Table
Modify a Table and Fields
Create Table Relationships
Create Query Joins
Join Tables That Have No Common Fields
Relate Data within a Table
Work with Subdatasheets
Create Subqueries
Data Normalization
Create a Junction Table
Import Data into Access
Export Data to Text File Formats
Export Access Data to Excel
Create a Mail Merge
Organize Report Information
Format Reports
Include Charts in a Report
Add a Calculated Field to a Report
Add a Subreport to an Existing Report
Create a Mailing Label Report
Publish a Report as PDF
Activities – Microsoft Access 2016 for Beginners