Ultimate Word 2016 Essentials Online Bundle, 10 Certificate Courses

The Most Comprehensive Microsoft Word Bundle

Ultimate Word 2016 Essentials Online Bundle, 10 Certificate Courses

NOW ONLY

£337

Save £1909 (85%)
OFF RRP £2246
Get Info Pack

 Learn Everything you Need to Know About Microsoft Word - 10 Courses in this Bundle

  1. Word 2016 Essentials

  2. Word 2016 Expert

  3. Word 365 Essentials

  4. Excel 2016 Advanced

  5. Excel 2016 and VBA Online

  6. Excel 2016 Essentials

  7. Excel 2016 Expert

  8. Word 2016 Part 1

  9. Word 2016 Part 2

  10. Word 2016 Part 3

1. Word 2016 Essentials: Learn the fundamental understanding of the Microsoft Word

You will gain a fundamental understanding of the Microsoft Word environment and the ability to complete tasks independently. They will demonstrate the correct application of the principle features of Word 2016 by creating and editing documents for a variety of purposes and situations. Document examples include professional looking reports, multi-column newsletters, resumes, and business correspondence.

Key Learning Objectives

  • Create and manage documents
  • Format text, paragraphs, and sections
  • Create tables and lists
  • Create and manage references
  • Insert and format graphic elements

2. Word 2016 Expert: Learn to proficiently use the advanced features of Microsoft Word for document content management and advanced formatting

You will learn to proficiently use the advanced features of Microsoft Word for document content management and advanced formatting - critical skills for those in roles such as editors, project managers, business information workers, and educators. You will create and manage professional multi-page documents for a variety of specialized purposes and situations. You will customize their Word 2016 environments to meet project needs, and to enhance productivity. Examples of expert-level documents include a business plan, a research paper, a specialized brochure, and a mass mailing. 

Key Learning Objectives

  • Control Pagination
  • Work with styles
  • Perform advanced editing and formatting
  • Create and manage indexes
  • Create and manage references
  • Manage forms and fields
  • Create mail merge and labels
  • Create and modify building blocks and content controls
  • Work with Macros
  • Create custom style sets, themes and templates
  • Prepare a document for internationalization and accessibility
  • Work with templates
  • Use version control
  • Manage document reviews and changes

3. Word 365 Essentials: Learn to use Office 365 Word

Office 365 Word Web App Essentials course, you can access your documents anywhere, and make some basic changes without using a computer where your desktop Office applications are installed.

With Office 365 Word you will learn how to edit, share, and publish Word files using the Office 365 interface. The Office 365 experience is designed to render your documents to look exactly like they would when printed, from nearly anywhere in the world. This tool provides its users the freedom to work from anywhere.

Key Learning Objectives

  • Open and close documents in reading or editing view
  • Understand the Office 365 web interface, including the home page, the team site, and the shared documents list
  • Understand the Word 365 browser interface
  • Upload a document to the Shared Documents library 
  • Open a document in Reading View or Editing View
  • Page through documents
  • Zoom to a different view
  • Open the pop out
  • Open in Editing View
  • Type, select, and edit text
  • Understand the Word web app interface
  • Use cut, copy, and paste
  • Undo and redo tasks
  • Format fonts and paragraphs with a variety of features
  • Use bullets and numbering
  • Insert and work with tables
  • Insert links
  • Insert and work with pictures
  • Insert clip art

4. Excel 2016 Advanced: Advance your Excel skills with our Excel 2016 Advanced Online Certificate Course

In this course, students will learn how to use range names in formulas and functions, as well as how to use specialized functions.

Key Learning Objectives

  • Creating advanced formulas
  • Analyzing data with logical and lookup functions
  • Organizing worksheet data with Tables
  • Visualizing data with Charts
  • Analyzing data with PivotTables, Slicers, and PivotCharts
  • Inserting graphics
  • Enhancing workbooks

5. Excel 2016 and VBA Online: Become an expert in Microsoft Excel with our Excel 2016 and VBA Online Certificate Course

Give students the chance to expand on the knowledge they gained in Excel 2016 Essentials Course by introducing them to Microsoft Excel 2016 and VBA course.

Microsoft Office Excel 2016 and VBA continues in-depth training for Excel 2016. This course gives students the skills they need to harness Visual Basic for Applications, or VBA, to automate many tasks they encounter while using Excel 2016.

Key Learning Objectives

  • Developing Macros
  • Formatting Worksheets Using Macros
  • Creating an Interactive Worksheet
  • Working with Multiple Worksheets
  • Performing Calculations

6. Excel 2016 Essentials: Learn to Gain an advanced level of understanding for the Microsoft Excel environment

Gain an advanced level of understanding for the Microsoft Excel environment, and the ability to guide others to the proper use of the program's full features - critical skills for those in roles such as accountants, financial analysts, and commercial bankers. You will create, manage, and distribute professional spreadsheets for a variety of specialized purposes and situations. They will customize their Excel 2016 environments to meet project needs and increase productivity. Expert workbook examples include custom business templates, multi-axis financial charts, amortization tables, and inventory schedules. 

Key Learning Objectives

  • Create worksheets and workbooks
  • Navigate in worksheets and workbooks
  • Format worksheets and workbooks
  • Change views and configurations
  • Print and distribute worksheets and workbooks
  • Manage data cells and ranges
  • Create tables, charts and objects
  • Perform operations with formulas and functions

7. Excel 2016 Expert: Learn to create, manage, and distribute professional spreadsheets

Gain an advanced level of understanding for the Microsoft Excel environment, and the ability to guide others to the proper use of the program's full features - critical skills for those in roles such as accountants, financial analysts, and commercial bankers. You will create, manage, and distribute professional spreadsheets for a variety of specialized purposes and situations. They will customize their Excel 2016 environments to meet project needs and increase productivity. Expert workbook examples include custom business templates, multi-axis financial charts, amortization tables, and inventory schedules.

Key Learning Objectives

  • Save a workbook as a template, with colors, fonts, cell styles and themes
  • Reference data using structured references or data in another workbook
  • Protect a workbook from further editing
  • Prepare a workbook for internationalization
  • Apply custom data formats and validation
  • Apply advanced conditional formatting and filtering
  • Use form controls
  • Work with macros

8. Word 2016 Part 1: Learn to create a basic document

To begin this course, you will learn about the parts of the Microsoft Word 2016 interface, how to create a basic document, and how to find help in Microsoft Word.

Key Learning Objectives

  • Getting started with Word
  • Editing a document
  • Formatting text and paragraphs
  • Adding tables
  • Managing lists
  • Inserting graphic objects
  • Controlling page appearance
  • Proofing a document
  • Customizing the Word environment

9. Word 2016 Part 2: Learn to create, modify, and manage templates

Keep the learning going with the second course in our Microsoft Word 2016 series – Microsoft Word 2016 Part Two. This course is designed to help users who are familiar with Word’s basic features to take their skills to the next level.

Key Learning Objectives

  • Working with objects (including tables, charts, images, text boxes, shapes, and SmartArt)
  • Using document management tools such as Building Blocks, templates, and custom themes
  • An introduction to expert-level tools, such as macros and mail merge

10. Word 2016 Part 3: Learn to create, and manipulate forms

In this course, students will learn how to create, and manipulate forms. Techniques for saving and exporting form data are also covered.

Key Learning Objectives

  • Sharing a document, working with comments, reviewing a document
  • Adding cross-references, bookmarks and hyperlinks
  • Inserting blank and cover pages, tables of contents, indexes, and managing outlines
  • Setting editing restrictions
  • Creating and manipulating forms
  • Creating and comparing document versions, and merging document version

Receive Lifetime Access to Course Materials, so you can review at any time.

For comprehensive information on units of study click the units of study tab above.

This is an incredible opportunity to invest in yourself and your future, sharpen your training skills and learn what it takes to create your own success with Courses For Success Today!

Course Fast Facts:

  1. All courses are easy to follow and understand
  2. Only 6 to 8 hours of study is required per course
  3. Unlimited lifetime access to course materials
  4. Study as many courses as you want
  5. Delivered 100% on-line and accessible 24/7 from any computer or smartphone
  6. You can study from home or at work, at your own pace, in your own time
  7. Certificates

Course Delivery

Courses are accessed online via our learning management system by any device including PC, MAC, tablet or Smart Phone.

Recognition & Accreditation

The courses offered by Courses For Success are unique as they are taught in a step-by-step process enabling students to complete them quickly and easily, so that you can obtain your qualification sooner. All students who complete the course receive a certificate of completion. CoursesForSuccess is committed to high completion rates and therefore 100% student satisfaction.

Receive Lifetime Access to Course Materials, so you can review it at any time.

The Ultimate Word 2016 Essentials 10 Course Bundle includes the following courses, below is a summary of each course: 

Course 1 - Word 2016 Essentials Online Certificate Course

 Module One: Getting Started

  • Course Objectives

Module Two: Create and Manage Documents

  • Creating a Document
  • Introduce the Ribbon
  • Open the New Screen
  • Create a Blank Document
  • Create a Document from a Template
  • Open a PDF for Editing
  • Insert Text from a File
  • Navigating Through a Document
  • Search for Text
  • Navigate to Page
  • Use the Go To Dialog Box
  • Formatting a Document, Part One
  • Change Margins
  • Change Page Orientation
  • Change Page Size
  • Use the Page Setup Dialog Box
  • Insert Headers and Footers
  • Insert Page Numbers
  • Formatting a Document, Part Two
  • Apply Document Themes
  • Apply Document Style Sheets
  • Add a Watermark
  • Change Page Background Color
  • Use the Page Borders Dialog Box
  • Customizing Options and Views for Documents
  • Change Document View
  • Zoom
  • Add a Tool to the Quick Access Toolbar
  • Split View Window
  • Add Document Properties
  • Show or Hide Formatting Symbols
  • Printing and Saving Documents
  • Print
  • Save in Another File Format
  • Inspect a Document for Hidden Properties and Personal Information
  • Inspect a Document for Accessibility Issues
  • Inspect a Document for Compatibility Issues

Module Three: Format Text, Paragraphs, and Sections

  • Inserting and Selecting Text and Paragraphs
  • Select Text with the Mouse or Keyboard
  • Insert Special Characters
  • Editing Text
  • Cut and Paste Text
  • Copy and Paste using Keyboard Shortcuts
  • Change Text Automatically Using AutoCorrect
  • Replace Text
  • Formatting Text
  • Apply Font Face and Size
  • Use the Font Context Lis
  • Use the Format Painter
  • Highlight Text
  • Formatting Paragraphs
  • Change Line Spacing
  • Change Paragraph Spacing
  • Use Indents and Tabs
  • Clear Formatting
  • Using Styles and WordArt
  • Apply Built-in Styles
  • Change Text to WordArt
  • Breaking Up Text
  • Insert a Page Break
  • Insert a Section Break
  • Change Page Setup Options for a Section
  • Create Multiple Column Layout
  • Insert a Column Break

Module Four: Create Lists and Tables

  • Using Bulleted Lists
  • Create a Bulleted List
  • Define a Custom Bullet Character
  • Using Numbered Lists
  • Create a Numbered List
  • Control List Numbering
  • Change List Levels
  • Define a Custom Number Format
  • Creating a Table
  • Insert a Table
  • Convert Text to Table
  • Convert Tables to Text
  • Apply Table Styles
  • Modifying a Table
  • Resize a Table
  • Resize a Table’s Rows or Columns
  • Repeat Row Headers
  • Sort Table Data
  • Merge Cells
  • Split Cells
  • Split a Table
  • Set Cell Margins and Spacing

Module Five: Insert and Format Graphic Elements

  • Insert Graphic Elements
  • Insert Shapes
  • Insert Pictures
  • Insert a Full-Size Screenshot
  • Insert a Screen Clipping
  • Insert a Text Box
  • Formatting Graphic Elements
  • Select a Graphical Element
  • Format a Shape
  • Set the Text Wrapping
  • Set Positioning
  • Add Alternative Text
  • Enhancing Pictures
  • Apply a Picture Style
  • Apply Picture Effects
  • Apply Artistic Effects
  • Remove the Background from a Picture
  • Using SmartArt
  • Insert SmartArt
  • Add Text to SmartArt
  • Customize SmartArt
  • Add Shape to SmartArt

Module Six: Create and Manage References

  • Create Bookmarks and Links
  • Insert a Bookmark
  • Insert a Hyperlink
  • Creating Common Front Matter
  • Insert a Standard Table of Contents
  • Update a Table of Contents
  • Insert a Cover Page
  • Using Captions, Footnotes and Endnotes
  • Add a Figure or Table Caption
  • Modify Caption Properties
  • Add a Footnote
  • Add an Endnote
  • Modify Footnote and Endnote Properties
  • Creating and Managing Reference Markers
  • Create Bibliography Citation Sources
  • Modify Bibliography Citation Sources
  • Insert Citations for Bibliographies

Module Seven: Wrapping Up

  • Words from the Wise
  • Lessons Learned

Course 2 - Word 2016 Expert Online Certificate Course

 Module One: Getting Started

  • Course Objectives

Module Two: Design Advanced Documents

  • Control Pagination
  • Create a Two-Page Layout
  • Change Header and Footer Space
  • Change Vertical Page Alignment
  • Set Paragraph Pagination Options
  • Work with Styles
  • Modify Existing Styles
  • Resolve Style Conflicts by Using Paste Options
  • Create Paragraph and Character Styles
  • Perform Advanced Editing and Formatting
  • Find Using Formatting
  • Replace Formatting
  • Find and Replace Using Special Characters
  • Find and Replace Text by Using Wildcards
  • Link Text Boxes

Module Three: Create Advanced References

  • Create and Manage Indexes
  • Mark Index Entries
  • Create Indexes
  • Update Indexes
  • Create and Manage References
  • Customize a Table of Contents
  • Insert and Modify Captions
  • Create and Modify a Table of Figures
  • Manage Forms and Fields
  • Add Custom Fields
  • Modify Field Properties
  • Create Mail Merge and Labels
  • Manage Recipient Lists
  • Insert Merged Fields
  • Preview Merge Results
  • Perform Mail Merge

Module Four: Create Custom Word Elements

  • Create and Modify Building Blocks and Content Controls
  • Create Quick Parts
  • Manage Building Blocks
  • Insert and Configure Content Controls
  • Work with Macros
  • Record a Macro
  • Run a Macro
  • Assign a Macro to a Button or Shortcut Key
  • Enable Macros
  • Create Custom Style Sets and Templates
  • Create Custom Color Sets
  • Create Custom Font Sets
  • Create Custom Themes
  • Create Custom Style Sets
  • Manage Multiple Options for +Body and +Heading Fonts
  • Prepare a Document for Internationalization and Accessibility
  • Configure Language Options in Documents
  • Add Alt Text to Document Elements

Module Five: Manage Document Options and Settings

  • Work with Templates
  • Modify Existing Templates
  • Manage Template and Document Elements
  • Customize the Ribbon
  • Change the Application Default Font
  • Use Version Control
  • Restrict Editing
  • Mark a Document as Final
  • Protect a Document with a Password
  • Manage Document Versions
  • Manage Document Reviews and Changes
  • Track Changes
  • Manage Tracked Changes
  • Lock or Unlock Tracking
  • Add Comments
  • Manage Comments
  • Compare and Combine Multiple Documents

Module Six: Wrapping Up

  • Words from the Wise
  • Review of Parking Lot
  • Completion of Action Plans and Evaluations

Course 3 - Word 365 Essentials Online Certificate Course

 Module One: Getting Started

By the end of this course, you will be able to:

  • Open and close documents in reading or editing view
  • Understand the Office 365 web interface, including the home page, the team site, and the shared documents list
  • Understand the Word 365 browser interface
  • Upload a document to the Shared Documents library 
  • Open a document in Reading View or Editing View
  • Page through documents
  • Zoom to a different view
  • Open the pop out
  • Open in Editing View
  • Type, select, and edit text
  • Understand the Word web app interface
  • Use cut, copy, and paste
  • Undo and redo tasks
  • Format fonts and paragraphs with a variety of features
  • Use bullets and numbering
  • Insert and work with tables
  • Insert links
  • Insert and work with pictures
  • Insert clip art

Module Two: Welcome to Office 365 Web Apps

  • The Home Page
  • The Team Site
  • Shared Documents
  • Uploading a Document

Module Three: Viewing Web App Documents (I)

  • Opening a Document
  • Overview of the Reading View
  • Paging Through Documents
  • Printing From the Reading View
  • Finding Text in Your Document
  • Closing Documents

Module Four: Viewing Web App Documents (II)

  • Zooming in your Document
  • Using the Pop Out
  • Editing in Browser
  • About Converting Documents
  • Opening in Word

Module Five: Editing in the Browser

  • A New File
  • Saving Files
  • The Word Web App Interface
  • Typing Text
  • Selecting Text with the Mouse or Keyboard
  • Editing and Deleting Text

Module Six: Basic Editing Tasks

  • Using Cut, Copy, and Paste
  • Using Undo and Redo
  • Checking Your Spelling
  • Setting the Proofing Language
  • Printing from the Editing View
  • Accessing the Reading View

Module Seven: Font Formatting

  • Understanding Levels of Formatting
  • Changing Font Face and Size
  • Changing the Font Color
  • Adding Font Enhancements
  • Highlighting Text

Module Eight: Formatting Paragraphs

  • Setting the Alignment
  • Using Indents and Tabs
  • Adding Bullets and Numbering
  • Text Direction

Module Nine: Working with Styles

  • About Styles
  • Quick Styles versus the Style Gallery
  • Applying a Style
  • Clearing Formatting

Module Ten: The Insert Tools (I)

  • Inserting a Table
  • Adding Text to a Table
  • Inserting Links

Module Eleven: The Insert Tools (II)

  • Inserting Pictures
  • Inserting Clip Art
  • Working with Pictures

Module Twelve: Wrapping Up
Words from the Wise

Course 4 - Excel 2016 Advanced Online Certificate Course

 Lesson 1: Creating Advanced Formulas

  • TOPIC A: Apply Range Names
  • Range Names
  • Adding Range Names Using the Name Box
  • Adding Range Names Using the New Name Dialog Box
  • Editing a Range Name and Deleting a Range Name
  • Using Range Names in Formulas
  • Activity 1-1
  • TOPIC B: Use Specialized Functions
  • Function Categories
  • The Excel Function Reference
  • Function Syntax
  • Function Entry Dialog Boxes
  • Using Nested Functions
  • Automatic Workbook Calculations
  • Showing and Hiding Formulas
  • Enabling Iterative Calculations
  • Activity 1-2
  • Summary
  • Review Questions

Lesson 2: Analyzing Data with Logical and Lookup Functions

  • TOPIC A: Use Text Functions
  • Text Functions
  • The LEFT and RIGHT Functions
  • The MID Function
  • The LEN Function
  • The TRIM Function
  • The UPPER, LOWER, and PROPER Functions
  • The CONCATENATE Function
  • The TRANSPOSE Function
  • Activity 2-1
  • TOPIC B: Use Logical Functions
  • Logical Functions
  • Logical Operators
  • The AND Function
  • The OR Function
  • The IF Function
  • Activity 2-2
  • TOPIC C: Use Lookup Functions
  • Lookup Functions
  • The LOOKUP Function
  • The VLOOKUP Function
  • The HLOOKUP Function
  • Activity 2-3
  • TOPIC D: Use Date Functions
  • The TODAY Function
  • The NOW Function
  • Serializing Dates and Times with Functions
  • Activity 2-4
  • TOPIC E: Use Financial Functions
  • The IPMT Function
  • The PPMT Function
  • The NPV Function
  • The FV Function
  • Activity 2-5
  • Summary
  • Review Questions

Lesson 3: Organizing Worksheet Data with Tables

  • TOPIC A: Create and Modify Tables
  • Tables
  • Table Components
  • The Create Table Dialog Box
  • The Table Tools – Design Contextual Tab
  • Styles and Quick Style Sets
  • Customizing Row Display
  • Table Modification Options
  • Activity 3-1
  • TOPIC B: Sort and Filter Data
  • The Difference Between Sorting and Filtering
  • Sorting Data
  • Advanced Filtering
  • Filter Operators
  • Removing Duplicate Values
  • Activity 3-2
  • TOPIC C: Use Subtotal and Database Functions to Calculate Data
  • SUBTOTAL Functions
  • The Subtotal Dialog Box
  • Summary Functions in Tables
  • Database Functions
  • Activity 3-3
  • Summary
  • Review Questions

Lesson 4: Visualizing Data with Charts

  • TOPIC A: Create Charts
  • Charts
  • Chart Types
  • Chart Insertion Methods
  • Resizing and Moving the Chart
  • Adding Additional Data
  • Switching Between Rows and Columns
  • Activity 4-1
  • TOPIC B: Modify and Format Charts
  • The Difference Between Modifying and Formatting
  • Chart Elements
  • Minimize Extraneous Chart Elements
  • The Chart Tools Contextual Tabs
  • Formatting the Chart with a Style
  • Adding a Legend to the Chart
  • Activity 4-2
  • TOPIC C: Create a Trendline
  • Trendlines
  • Types of Trendlines
  • Adding a Trendline
  • The Format Trendline Task Pane
  • Activity 4-3
  • TOPIC D: Create Advanced Charts
  • Dual Axis Charts
  • Creating Custom Chart Templates
  • Viewing Chart Animations
  • Activity 4-4
  • Summary
  • Review Questions

Lesson 5: Analyzing Data with PivotTables, Slicers, and PivotCharts

  • TOPIC A: Create a PivotTable
  • PivotTables
  • Start with Questions, End with Structure
  • The Create PivotTable Dialog Box
  • The PivotTable Fields Pane
  • Summarize Data in a PivotTable
  • The “Show Values As” Functionality of a PivotTable
  • External Data
  • PowerPivot
  • PowerPivot Functions
  • Activity 5-1
  • TOPIC B: Filter Data by Using Slicers
  • Slicers
  • The Insert Slicers Dialog Box
  • Activity 5-2
  • TOPIC C: Analyze Data with PivotCharts
  • PivotCharts
  • Creating PivotCharts
  • Applying a Style to a PivotChart
  • Activity 5-3
  • Summary
  • Review Questions

Lesson 6: Inserting Graphics

  • TOPIC A: Insert and Modify Graphic Objects
  • Graphical Objects
  • Inserting Shapes
  • Inserting WordArt
  • Inserting Text Boxes
  • Inserting Images
  • The Picture Tools – Format Contextual Tab
  • The Drawing Tools – Format Contextual Tab
  • The SmartArt Tools Contextual Tabs
  • Activity 6-1
  • TOPIC B: Layer and Group Graphic Objects
  • Layering Objects
  • Grouping Objects
  • Positioning Objects
  • Activity 6-2
  • TOPIC C: Incorporate SmartArt
  • About SmartArt
  • The Choose a SmartArt Graphic Dialog Box
  • About the Text Pane
  • Activity 6-3
  • Summary
  • Review Questions

Lesson 7: Enhancing Workbooks

  • TOPIC A: Customize Workbooks
  • Comments
  • Hyperlinks
  • Watermarks
  • Background Pictures
  • Activity 7-1
  • TOPIC B: Manage Themes
  • About Themes
  • Customizing Themes
  • Activity 7-2
  • TOPIC C: Create and Use Templates
  • Templates
  • Template Types
  • Creating a Template
  • Modifying a Template
  • Activity 7-3
  • TOPIC D: Protect Files
  • Recovering Lost Data
  • The Changes Group
  • Worksheet and Workbook Protection
  • The Protect Worksheet Option
  • The Protect Workbook Option
  • Activity 7-4
  • TOPIC E: Preparing a Workbook for Multiple Audiences
  • Displaying Data in Multiple International Formats
  • Utilize International Symbols
  • Modifying Worksheets Using the Accessibility Checker
  • Managing Fonts
  • Activity 7-5
  • Summary
  • Review Questions

Course 5 - Excel 2016 and VBA Online Certificate Course

 Lesson 1:?Developing Macros

  • Visual Basic for Applications
  • Object-Oriented Programming
  • Macros
  • Macro Options
  • The Macro Recorder
  • Personal Macro Workbooks
  • How to Create a Macro Using the Macro Recorder
  • Activity 1-1
  • The Visual Basic Editor
  • Projects
  • Modules
  • The Modules Folder
  • Objects
  • Properties
  • Methods
  • VBA Comments
  • How to Edit a Macro
  • Activity 1-2
  • The Debugging Process
  • Debugging Tools
  • How to Debug a Macro
  • Activity 1-3
  • How to Customize the Quick Access Toolbar and Hotkeys
  • Activity 1-4
  • Digital Certificates
  • Digital Signatures
  • Macro Security Settings
  • How to Set Macro Security
  • Activity 1-5
  • Summary
  • Review Questions

Lesson 2:?Formatting Worksheets Using Macros

  • The Selection Property
  • The ActiveSheet Property
  • The Name Property
  • The Value Property
  • Concatenation
  • How to Insert Text
  • Activity 2-1
  • How to Format Text
  • Activity 2-2
  • The Range Object
  • The Select Method
  • The CurrentRegion Property
  • How to Sort Data
  • Activity 2-3
  • Data Types
  • Variables
  • Variable Naming Rules
  • Operators
  • The Assignment Operator
  • Arithmetic Operators
  • Comparison Operators
  • Logical Operators
  • The For Next Loop
  • Do Loops
  • The Worksheets Object
  • The Count Property
  • The Offset Property
  • The Copy Method
  • The Paste Method
  • How to Duplicate Data
  • Activity 2-4
  • The Columns Property
  • The AutoFit Method
  • The Address Property
  • The Call Statement
  • The Font Property
  • The End Property
  • How to Generate a Report
  • Activity 2-5
  • Summary
  • Review Questions

Lesson 3:?Creating an Interactive Worksheet

  • Message Boxes
  • Input Boxes
  • Activity 3-1
  • The InputBox Function
  • Constants
  • The MsgBox Function
  • The Code Continuation Character
  • The vbCrLf Constant
  • Decision Structures
  • The Select Case Statement
  • The If Then Structure
  • The Else Clause
  • How to Capture User Input
  • Activity 3-2
  • Summary
  • Review Questions

Lesson 4:?Working with Multiple Worksheets

  • The Add Method
  • The Copy Method
  • The Delete Method
  • How to Insert, Copy, and Delete Worksheets
  • Activity 4-1
  • Expressions
  • The DateSerial Function
  • The Format Function
  • How to Rename Worksheets
  • Activity 4-2
  • The Move Method
  • How to Modify the Order of Worksheets
  • Activity 4-3
  • The PrintPreview Method
  • The PrintOut Method
  • How to Print Worksheets
  • Activity 4-4
  • Summary
  • Review Questions

Lesson 5:?Performing Calculations

  • User-Defined Functions
  • Types of Functions
  • Arguments
  • How to Create User-Defined Functions
  • Activity 5-1
  • Declared Range Objects
  • The Set Statement
  • Range Object Cell Addressing
  • The Rows Property
  • The Formula Property
  • The Columns Property
  • Address Property Cell Reference Settings
  • How to Automate SUM Functions
  • Activity 5-2
  • Summary
  • Review Questions

Course 6 - Excel 2016 Essentials Online Certificate Course

 Module One: Getting Started

  • Course Objectives

Module Two: Create and Manage Worksheets and Workbooks

  • Create Worksheets and Workbooks
  • Create a Workbook
  • Open a Comma Separated Values File
  • Add a Worksheet to An Existing Workbook
  • Navigate in Workbooks and Worksheets
  • Search for Data
  • Navigate to a Named Cell
  • Insert and Remove Hyperlinks
  • Hide or Unhide Columns and Rows
  • Hide or Unhide Sheets
  • Modify Worksheets
  • Insert and Delete Table Rows and Columns
  • Adjust Row Height and Column Width
  • Insert Headers and Footers
  • Change Worksheet Tab Color
  • Rename Worksheet
  • Format Workbooks
  • Copy and Move Worksheets
  • Modify Page Setup
  • Change Workbook Themes
  • Customize Options and Views for Worksheets and Workbooks
  • Add a Tool to the Quick Access Toolbar
  • Zoom
  • Change Workbook Views
  • Change Window Views
  • Modify Document Properties
  • Show or Hide Formulas
  • Configure Worksheets and Workbooks for Distribution
  • Print
  • Set a Print Area
  • Save in Another File Format
  • Repeat Columns or Rows Across Multiple Pages
  • Inspect a Workbook for Hidden Properties and Personal Information
  • Inspect a Workbook for Accessibility Issues
  • Inspect a Workbook for Compatibility Issues

Module Three: Manage Data Cells and Ranges

  • Insert Data in Cells and Ranges
  • Replace Data
  • Cut, Copy and Paste Data
  • Paste Data Using Paste Options
  • Fill Cells using Autofill
  • Insert and Delete Cells
  • Format Cells and Ranges
  • Merge Cells
  • Align and Indent Cell Contents
  • Wrap Text Within Cells
  • Apply Number Formats
  • Apply Cell Formats
  • Apply Cell Styles
  • Apply Conditional Formatting
  • Format Cells using the Format Painter
  • Summarize and Organize Data
  • Insert Sparklines
  • Grouping Data
  • Adding Subtotals
  • Outline Data
  • Viewing Grouped and Outlined Data

Module Four: Create Tables

  • Create and Manage Tables
  • Create an Excel Table from a Cell Range
  • Add or Remove Table Rows and Columns
  • Convert a Table to a Cell Range
  • Manage Table Styles and Options
  • Apply Styles to Tables
  • Configure Table Style Options
  • Insert Total Rows
  • Filter and Sort a Table
  • Filter Records
  • Clear Filters
  • Use a Number Filter or Text Filter
  • Change Sort Order
  • Sort Data by Multiple Columns
  • Remove Duplicate Records

Module Five: Perform Operations with Formulas and Functions

  • Building Formulas
  • Understand Math Basics of Excel
  • Build a Formula
  • Edit a Formula
  • Copy a Formula
  • Understand Relative vs. Absolute References
  • Perform Basic Functions
  • Understand Formulas vs. Functions
  • Calculate Using Status Bar
  • Perform Basic Functions
  • AutoComplete a Function
  • Create Functions using Formulas Tab
  • Perform Conditional Functions
  • Perform the IF Function
  • Perform the SUMIF Function
  • Perform the AVERAGEIF Function
  • Perform the COUNTIF Function
  • Format and Modify Text Using Functions
  • Format Text Using UPPER, LOWER, and PROPER Functions
  • Format Text Using the CONCAT Function
  • Format Text Using LEFT, RIGHT and MID Functions

Module Six: Use Quick Analysis, Charts and Objects

  • Analyze Data with Quick Analysis
  • Format with Quick Analysis
  • Create Charts with Quick Analysis
  • Calculate Totals with Quick Analysis
  • Create Charts
  • Use Recommended Charts
  • Create a New Chart
  • Add Additional Data Series
  • Switch Between Rows and Columns in Source Data
  • Format Charts
  • Resize Charts
  • Add and Modify Chart Elements
  • Apply Chart Styles and Layouts
  • Move Charts to a Chart Sheet
  • Add Data to Chart on a Chart Sheet
  • Insert and Format Objects
  • Insert Shapes
  • Insert Text Boxes
  • Format Shapes and Text Boxes
  • Insert Pictures
  • Add Alternative Text

Module Seven: Wrapping Up

  • Words from the Wise
  • Completion of Action Plans and Evaluations

Course 7 - Excel 2016 Expert Online Certificate Course

 Module One: Getting Started

  • Course Objectives

Module Two: Manage Workbook Options and Settings

  • Manage Workbooks
  • Save a Workbook as a Template
  • Reference Data in Another Workbook
  • Reference Data by Using Structured References
  • Display Hidden Ribbon Tabs
  • Manage Workbook Review
  • Mark a Workbook as Final
  • Protect a Workbook with a Password
  • Protect a Worksheet to Restrict Editing
  • Protect Workbook Structure
  • Manage Workbook Versions
  • Setting Calculation Options

Module Three: Apply Custom Data Formats and Layouts

  • Prepare a Workbook for Internationalization
  • Apply International Currency Formats
  • Apply Locale to Date or Time Formats
  • Apply Custom Data Formats and Validation
  • Create Custom Number Formats
  • Populate Cells by Using Advanced Fill Series Options
  • Configure Data Validation
  • Apply Advanced Conditional Formatting and Filtering
  • Create Custom Conditional Formatting Rules
  • Create Conditional Formatting Rules that Use Formulas
  • Manage Conditional Formatting Rules
  • Create and Modify Custom Workbook Elements
  • Create Custom Color Formats
  • Create Custom Font Sets
  • Create and Modify Cell Styles
  • Create and Modify Custom Themes
  • Manage Multiple Options for Theme Fonts
  • Insert and Configure Form Controls
  • Work with Macros
  • Enable Macros
  • Record a Macro
  • Run a Macro
  • Edit a Macro
  • Copy Macros from One Workbook to Another

Module Four: Create Advanced Formulas

  • Define Named Ranges and Objects
  • Name Cells
  • Use Named Cells in a Formula
  • Manage Named Ranges and Objects
  • Apply Functions in Formulas
  • Perform the AND Function and the OR Function
  • Perform NOT Function
  • Perform Logical Operations by Using Nested Functions
  • Perform SUMIFS, AVERAGEIFS, and COUNTIFS Functions
  • Look Up Data by Using Functions
  • Look Up Data by Using the VLOOKUP Function
  • Look Up Data by Using the HLOOKUP Function
  • Look Up Data by using the MATCH Function
  • Look Up Data by Using the INDEX Function
  • Apply Advanced Time and Date Functions
  • Serialize Numbers by Using Date and Time Functions
  • Reference the Date and Time Using the NOW and TODAY functions
  • Perform Data Analysis and Business Intelligence
  • Import, Transform, Combine, Display, and Connect to Data
  • Consolidate Data
  • Perform What-If Analysis by Using Goal Seek
  • Perform What-If Analysis by Using Scenario Manager
  • Troubleshoot Formulas
  • Trace Precedence and Dependence
  • Monitor Cells and Formulas using the Watch Window
  • Validate Formulas by Using Error Checking Rules
  • Evaluate Formulas

Module Five: Create Advanced Charts and Tables

  • Create Advanced Charts
  • Add Trendlines to Charts
  • Create Dual-Axis Charts
  • Save a Chart as a Template
  • Create and Manage PivotTables
  • Create Slicers
  • Create PivotTables
  • Modify Field Selections and Options
  • Group PivotTable Data
  • Reference Data in a PivotTable by Using the GETPIVOTDATA Function
  • Add Calculated Fields
  • Format Data
  • Create and Manage PivotCharts
  • Create PivotCharts
  • Drill Down into PivotChart Details
  • Apply Styles to PivotCharts
  • Manipulate Options in Existing PivotCharts

Module Six: Wrapping Up

  • Words from the Wise

Course 8 - Word 2016 Part 1 Online Certificate Course

 Lesson 1: Getting Started with Word

TOPIC A: Identify the Components of the Word Interface

  • Microsoft Office Word 2016
  • Word Documents
  • The Word Application Window
  • The Ribbon
  • The Backstage View
  • Task Panes
  • Galleries
  • Document Views
  • Window Views
  • Zoom Options
  • Activity 1-1

TOPIC B: Create a Word Document

  • Creating a Blank Document
  • Default Typing Options
  • Formatting Marks
  • Save Options
  • Sharing a Document
  • Preview and Print Options
  • Activity 1-2

TOPIC C: Help

  • Using Tell Me
  • Accessing Advanced Help Options
  • Activity 1-3
  • Summary
  • Review Questions

Lesson 2: Editing a Document

TOPIC A: Navigate and Select Text

  • Scroll Bars
  • Keyboard Navigation
  • Text Selection
  • Activity 2-1

TOPIC B: Modify Text

  • Text Editing Options
  • The Clipboard Task Pane
  • Paste Options
  • Live Preview
  • The Undo Command
  • The Redo Command
  • Activity 2-2

TOPIC C: Find and Replace Text

  • The Navigation Pane
  • The Find and Replace Dialog Box
  • Find Options
  • Find and Replace with Wildcards
  • Activity 2-3
  • Summary
  • Review Questions

Lesson 3: Formatting Text and Paragraphs

TOPIC A: Apply Character Formatting

  • Fonts
  • The Mini Toolbar
  • Font Options
  • Text Highlighting Options
  • The Format Painter
  • Activity 3-1

TOPIC B: Align Text Using Tabs

  • Tabs
  • Rulers
  • Tab Stops on a Ruler
  • The Tabs Dialog Box
  • Activity 3-2

TOPIC C: Display Text as List Items

  • Lists
  • Bulleted Lists
  • Numbered Lists
  • Activity 3-3

TOPIC D: Control Paragraph Layout

  • Margins
  • Paragraph Alignment Options
  • Indents
  • Indent Markers
  • Indentation Options
  • Spacing Options
  • Hyphenation
  • Activity 3-4

TOPIC E: Apply Borders and Shading

  • Borders
  • Types of Borders
  • Shading
  • The Borders and Shading Dialog Box
  • Activity 3-5

TOPIC F: Apply Styles

  • Word Styles
  • Style Sets
  • The Styles Task Pane
  • Applying Styles
  • Activity 3-6

TOPIC G: Manage Formatting

  • The Reveal Formatting Task Pane
  • Clear Formatting Options
  • Find and Replace Text Formatting Options
  • Activity 3-7
  • Summary
  • Review Questions

Lesson 4: Adding Tables

TOPIC A: Insert a Table

  • Tables
  • Using Tables to Control Page Layout
  • Table Creation Options
  • Quick Tables
  • Inserting Word Data
  • Table Navigation Methods
  • Activity 4-1

TOPIC B: Modify a Table

  • Table Selection Methods
  • The Table Tools – Layout Contextual Tab
  • The Table Properties Dialog Box
  • Inserting and Deleting Rows and Columns
  • Moving and Resizing Rows and Columns
  • Customizing Cell Margins
  • Setting Table Titles
  • Activity 4-2

TOPIC C: Format a Table

  • Table Styles
  • Table Fonts
  • The Table Tools – Design Contextual Tab
  • Activity 4-3

TOPIC D: Convert Text to a Table

  • The Convert Text to Table Dialog Box
  • The Convert Table to Text Dialog Box
  • Activity 4-4
  • Summary
  • Review Questions

Lesson 5: Managing Lists

TOPIC A: Sort a List

  • Sort Types
  • Sort Fields
  • Sorting Text
  • Activity 5-1

TOPIC B: Renumber a List

  • Renumbering Options
  • Activity 5-2
  • TOPIC C: Customize a List
  • Multilevel Lists
  • Increasing and Decreasing List Levels
  • List Styles
  • The Multilevel List Gallery
  • List Appearance Customization Options
  • List Appearance Formatting Options
  • Activity 5-3
  • Summary
  • Review Questions

Lesson 6: Inserting Graphic Objects

TOPIC A: Insert Symbols and Special Characters

  • Symbols
  • Special Characters
  • Activity 6-1

TOPIC B: Add Images to a Document

  • Illustrations
  • Local Pictures
  • Online Pictures
  • The Picture Tools – Format Contextual Tab
  • Activity 6-2
  • Summary
  • Review Questions

Lesson 7: Controlling Page Appearance

TOPIC A: Apply a Page Border and Color

  • Page Borders
  • Border Options
  • Page Color Options
  • Activity 7-1

TOPIC B: Add a Watermark

  • Watermarks
  • The Printed Watermark Dialog Box
  • Activity 7-2

TOPIC C: Add Headers and Footers

  • Inserting Page Numbers
  • Headers and Footers
  • The Header & Footer Tools – Design Tab
  • Activity 7-3

TOPIC D: Control Page Layout

  • Margin Options
  • Page Orientation
  • Vertical Alignment Options
  • The Paper Size Option
  • Page Breaks
  • The Page Setup Dialog Box
  • Activity 7-4
  • Summary
  • Review Questions

Lesson 8: Proofing a Document

TOPIC A: Check Spelling and Grammar

  • Spelling and Grammar Check Options
  • The Dictionary
  • The Insights Pane
  • The Readability Statistics Dialog Box
  • The Word Count Dialog Box
  • Activity 8-1

TOPIC B: Other Proofing Tools

  • The Thesaurus
  • The Thesaurus Task Pane
  • The Translation Feature
  • The Research Options Dialog Box
  • Activity 8-2

TOPIC C: Check Accessibility

  • Accessibility
  • Section 508
  • Accessibility Checker
  • Adding Alternative Text to Objects
  • Activity 8-3
  • Summary
  • Review Questions

Lesson 9: Customizing the Word Environment

TOPIC A: Customize the Word Interface

  • The Word Options Dialog Box
  • Customizing the Ribbon
  • Customizing the Quick Access Toolbar
  • The AutoCorrect Dialog Box
  • The AutoCorrect Tab
  • Activity 9-1

TOPIC B: Additional Save Options

  • Word 2016 File Formats
  • Compatibility Checker
  • AutoSave
  • AutoRecover
  • Recovering an Unsaved Document
  • Activity 9-2

TOPIC C: Manage Additional File Types

  • Opening Non-Native Files in Microsoft Word
  • Importing Files
  • Opening and Editing PDF Documents
  • Appending Text to a Document
  • Linking to Other Documents
  • Activity 9-3
  • Summary

Course 9 - Word 2016 Part 2 Online Certificate Course

 Lesson 1: Working with Tables and Charts

TOPIC A: Sort Table Data

  • Sorting Tables
  • Activity 1-1

TOPIC B: Control Cell Layout

  • Cell Merging
  • Cell Splitting
  • Cell Alignment
  • Text Direction
  • Activity 1-2

TOPIC C: Perform Calculations in a Table

  • Formulas in Word
  • Functions in Word
  • Equations
  • Activity 1-3

TOPIC D: Create a Chart

  • Charts
  • Chart Components
  • Types of Charts
  • Creating a Chart
  • The Chart Tools Tabs
  • Chart Quick Analysis Buttons
  • Changing the Chart Type
  • Editing Chart Data
  • Saving a Chart as a Template
  • The Caption Dialog Box
  • Activity 1-4
  • Summary
  • Review Questions

Lesson 2: Customizing Formats Using Styles and Themes

TOPIC A: Create and Modify Text Styles

  • Types of Text Styles
  • Applying Styles
  • Character Spacing
  • Custom Styles
  • The Create New Style from Formatting Dialog Box
  • Style Modification Options
  • Assigning Keyboard Shortcuts to Styles
  • Activity 2-1

TOPIC B: Create Custom List or Table Styles

  • Tools for List Styles
  • Tools for Table Styles
  • Activity 2-2

TOPIC C: Apply and Customize Document Themes

  • Applying Document Themes
  • Changing the Style Set
  • Creating Custom Style Sets
  • The Document Formatting Group
  • Creating Custom Color Schemes
  • Creating Custom Font Schemes
  • Saving Custom Themes
  • Activity 2-3
  • Summary
  • Review Questions

Lesson 3: Using Images in a Document

TOPIC A: Resize an Image

  • Resizing Options
  • Cropping Images
  • Activity 3-1

TOPIC B: Adjust Image Appearance

  • The Adjust Group
  • Corrections Options
  • Color Options
  • Artistic Effects Options
  • Compression Tools
  • The Background Removal Tool
  • Applying Picture Styles
  • Activity 3-2

TOPIC C: Integrate Pictures and Text

  • Text Wrapping Styles
  • Picture Positioning Options
  • Rotating Images
  • Adding Captions
  • Activity 3-3

TOPIC D: Insert and Format Screenshots

  • The Screenshot Tool
  • Activity 3-4
  • TOPIC E: Insert Video
  • Video Links
  • Inserting a Video
  • Playing a Video
  • Activity 3-5
  • Summary
  • Review Questions

Lesson 4: Creating Custom Graphic Elements

TOPIC A: Create Text Boxes and Pull Quotes

  • Types of Text Boxes
  • Inserting a Text Box with the Text Box Gallery
  • Drawing a Text Box
  • The Drawing Tools – Format Contextual Tab
  • Applying Text Box Styles
  • Formatting Text Boxes
  • Applying Shadow and 3-D Effects
  • Changing Text Direction
  • Saving the Selection to the Text Box Gallery
  • Arranging Text Boxes
  • Activity 4-1

TOPIC B: Draw Shapes

  • Shapes in Word
  • Types of Shapes
  • The Drawing Canvas
  • Text Wrapping Styles
  • Adding Text to a Shape
  • Modifying Text in a Shape
  • Adding Captions
  • Setting Shape Styles
  • Resizing Options
  • Positioning Options
  • Activity 4-2

TOPIC C: Add WordArt and Other Text Effects

  • WordArt
  • Drop Caps
  • Activity 4-3

TOPIC D: Create Complex Illustrations with SmartArt

  • SmartArt Graphics
  • The Choose a SmartArt Graphic Dialog Box
  • Adding Text and Images to the Diagram
  • SmartArt Graphic Categories
  • The SmartArt Tools Contextual Tabs
  • Activity 4-4
  • Summary
  • Review Questions

Lesson 5: Inserting Content Using Quick Parts

TOPIC A: Insert Building Blocks

  • Quick Parts
  • Building Blocks
  • The Building Blocks Organizer Dialog Box
  • Activity 5-1

TOPIC B: Create and Modify Building Blocks

  • The Create New Building Blocks Dialog Box
  • Building Block Modification Options
  • Copying Building Blocks Between Documents
  • Activity 5-2

TOPIC C: Insert Fields Using Quick Parts

  • Fields
  • Field Code Syntax
  • The Field Dialog Box
  • Activity 5-3
  • Summary
  • Review Questions

Lesson 6: Controlling Text Flow

TOPIC A: Control Paragraph Flow

  • Paragraph Flow Options
  • Activity 6-1

TOPIC B: Insert Section Breaks

  • Sections and Section Breaks
  • When to Use Section Breaks
  • Inserting a Section Break
  • Types of Section Breaks
  • Creating Section Titles
  • Activity 6-2

TOPIC C: Insert Columns

  • Text Columns
  • Text Column Options
  • Activity 6-3

TOPIC D: Link Text Boxes to Control Text Flow

  • Linked Text Boxes
  • Inserting Text from a File
  • Activity 6-4
  • Summary
  • Review Questions

Lesson 7: Using Templates

TOPIC A: Create a Document Using a Template

  • Templates in Word
  • Creating a Document from a Template
  • Viewing Personal Templates
  • Template Storage Locations
  • Activity 7-1

TOPIC B: Create a Template

  • Creating a New Template
  • Modifying a Template
  • Attaching a Template to a Document
  • Managing Templates with the Organizer
  • The Default Template Location
  • Activity 7-2
  • Summary
  • Review Questions

Lesson 8: Using Mail Merge

TOPIC A: The Mail Merge Features

  • Mail Merge
  • Mail Merge Fields
  • Mail Merge Rules
  • Data Sources
  • The Mail Merge Process
  • The Mailings Tab
  • The Mail Merge Wizard and Related Dialog Boxes
  • Opening a Mail Merge Document with a Data Source Attached
  • Unlinking a Data Source
  • Activity 8-1

TOPIC B: Merge Envelopes and Labels

  • Merge Options for Envelopes and Labels
  • Create a Single Envelope or Label
  • Set Up a Return Address
  • Activity 8-2

TOPIC C: Create a Data Source Using Word

  • Data Sources
  • Data Guidelines
  • Creating a Data Source Using Word
  • Activity 8-3
  • Summary
  • Review Questions

Lesson 9: Using Macros

TOPIC A: Automate Tasks Using Macros

  • Macros
  • The Developer Tab
  • The Macros Dialog Box
  • Macro Security
  • Macro Security Components
  • Activity 9-1

TOPIC B: Create a Macro

  • The Record Macro Dialog Box
  • Creating Keyboard Shortcuts for Macros
  • Assigning Macros to Buttons
  • Managing Macros with the Organizer
  • Visual Basic for Applications
  • Activity 9-2
  • Summary

Course 10 - Word 2016 Part 3 Online Certificate Course

 Lesson 1: Collaborating on Documents

TOPIC A: Modify User Information

  • Viewing File Properties
  • User Information
  • Activity 1-1

TOPIC B: Share a Document

  • Sharing Options
  • Presenting Documents Online
  • OneDrive
  • Configuring a Blog Account
  • Creating a Blog Post
  • Publishing a Blog Post
  • Activity 1-2

TOPIC C: Work with Comments

  • Inserting Comments
  • Editing Comments
  • Replying to Comments
  • Marking Comments Done
  • Navigating Through Comments
  • Deleting Comments
  • Activity 1-3

TOPIC D: Compare Document Changes

  • Legal Blackline
  • Comparison Settings
  • Accepting and Rejecting Changes
  • Activity 1-4

TOPIC E: Review a Document

  • Track Changes
  • Turn Track Changes On and Off
  • Markup Views
  • Track Changes Options
  • The Track Changes Indicator
  • Reviewing Changes
  • Activity 1-5

TOPIC F: Merge Document Changes

  • Combining Modifications from Multiple Reviewers
  • Revisions Pane
  • Resolving Style Conflicts
  • Activity 1-6

TOPIC G: Coauthor Documents

  • Sharing Documents Online
  • Editing a Shared File
  • Sharing Your Changes
  • Activity 1-7
  • Summary
  • Review Questions

Lesson 2: Adding Reference Marks and Notes

TOPIC A: Add Captions

  • Captions
  • Adding Captions
  • Caption Dialog Box
  • Activity 2-1

TOPIC B: Add Cross-References

  • Cross-References
  • Adding Cross-References
  • Cross-Reference Dialog Box
  • Updating Cross-References
  • Activity 2-2

TOPIC C: Add Bookmarks

  • Bookmarks
  • Adding Bookmarks
  • Bookmark Dialog Box
  • Bookmark Formatting Marks
  • Hidden Bookmarks
  • Activity 2-3

TOPIC D: Add Hyperlinks

  • Hyperlinks
  • Adding Hyperlinks
  • Insert Hyperlink Dialog Box
  • Options in the Link To Panel
  • Edit Hyperlink Dialog Box
  • Activity 2-4

TOPIC E: Insert Footnotes and Endnotes

  • Footnotes and Endnotes
  • Inserting Footnotes and Endnotes
  • The Footnote and Endnote Dialog Box
  • Navigating Using Reference Marks
  • ScreenTips for Footnotes and Endnotes
  • Activity 2-5

TOPIC F: Add Citations

  • Sources
  • The Source Manager Dialog Box
  • The Create Source Dialog Box
  • The Edit Source Dialog Box
  • Citations
  • Adding Citations
  • The Edit Citation Dialog Box
  • Citation and Bibliography Styles
  • Activity 2-6

TOPIC G: Insert a Bibliography

  • Bibliographies
  • Adding a Bibliography
  • Updating the Bibliography
  • Activity 2-7
  • Summary
  • Review Questions

Lesson 3: Simplifying and Managing Long Documents

TOPIC A: Insert Blank and Cover Pages

  • Inserting Blank Pages
  • Inserting Cover Pages
  • Activity 3-1

TOPIC B: Insert an Index

  • The Mark Index Entry Dialog Box
  • Index Entry Field Codes
  • The Index Dialog Box
  • The Open Index AutoMark File Dialog Box
  • The Concordance File
  • The Style Dialog Box
  • The Modify Style Dialog Box
  • Updating the Index
  • Activity 3-2

TOPIC C: Insert a Table of Contents

  • Table of Contents
  • The Table of Contents Dialog Box
  • The Add Text Option
  • The Mark Table of Contents Entry Dialog Box
  • Updating a Table of Contents
  • Activity 3-3

TOPIC D: Insert an Ancillary Table

  • Ancillary Tables
  • The Table of Figures Dialog Box
  • Table of Authorities
  • The Mark Citation Dialog Box
  • The Table of Authorities Dialog Box
  • Field Code for a Marked Citation
  • Activity 3-4

TOPIC E: Manage Outlines

  • Outline View
  • Outline Symbols
  • Outline View Tools
  • Creating an Outline
  • Promoting and Demoting Sections
  • Activity 3-5

TOPIC F: Create a Master Document

  • Master Documents
  • Benefits of Master Documents
  • Creating a Master Document
  • Creating Subdocuments
  • Master Document Group
  • Managing Subdocuments
  • Activity 3-6
  • Summary
  • Review Questions

Lesson 4: Securing a Document

TOPIC A: Suppress Information

  • Suppress Sensitive Information
  • Hidden Text
  • Remove Personal Information from a Document
  • The Document Inspector Dialog Box
  • Activity 4-1

TOPIC B: Set Editing Restrictions

  • The Restrict Editing Task Pane
  • Protected View
  • Mark as Final
  • Activity 4-2

TOPIC C: Add a Digital Signature to a Document

  • Digital Certificates
  • Digital Signatures
  • The Signature Line
  • Digitally Signing a Document
  • The Signatures Task Pane
  • Requested Signatures
  • Valid Signatures
  • Activity 4-3

TOPIC D: Restrict Document Access

  • Applying a Document Password
  • Changing the Document Password
  • Removing the Document Password
  • Activity 4-4
  • Summary
  • Review Questions

Lesson 5: Forms

TOPIC A: Create Forms

  • Forms
  • Plan a Form
  • The Controls Group
  • Form Controls
  • Design Mode
  • Legacy Tools
  • Form Field Options
  • Toggling Form Field Shading
  • Clearing Entered Data from Form Fields
  • Protecting a Form
  • Activity 5-1

TOPIC B: Manipulate Forms

  • Modifying a Control’s Title Tab
  • Adding Help Contents to Form Fields
  • Activity 5-2

TOPIC C: Form Data Conversion

  • Save Form Data as a Text File
  • How Data is Saved
  • Linking the Form to a Database
  • Modifying Tab Order
  • Activity 5-3
  • Summary
  • Review Questions

Lesson 6: Managing Document Versions

TOPIC A: Create a New Document Version

  • Microsoft SharePoint Server
  • Versioning
  • Versioning Settings
  • Major vs. Minor Versions
  • Accessing Documents Directly from a SharePoint Site
  • Begin Working with Document Versions
  • Activity 6-1

TOPIC B: Compare Document Versions

  • The Compare Feature
  • Compare Document Versions

TOPIC C: Merge Document Versions

  • The Combine Feature
  • Merge Multiple Versions of a Document
  • Summary

Entry requirements

Students must have basic literacy and numeracy skills.

Minimum education

Open entry. Previous schooling and academic achievements are not required for entry into this course.

Computer requirements

Students will need access to a computer and the internet. 

Minimum specifications for the computer are:

Windows:

  • Microsoft Windows XP, or later
  • Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome, Safari)

MAC/iOS

  • OSX/iOS 6 or later
  • Modern and up to date Browser (Firefox, Chrome, Safari)

All systems

  • Internet bandwidth of 1Mb or faster
  • Flash player or a browser with HTML5 video capabilities(Currently Internet Explorer 9, Firefox, Chrome, Safari)

Students will also need access the following applications:

Adobe Acrobat Reader

1.  Who are Courses For Success?

Courses For Success is a global course platform that started in 2008 with 5 courses, since then we have grown to over 10,000 online courses. As our courses are delivered online via the internet, we sell our courses worldwide.

Our courses span across many categories including Academic, Animal, Beauty, Business, Career, Counseling, Creative & Media, Health & Therapy, Hobbies & Trades, IT, Personal Development, Sports & Fitness.

Some of the companies we work with include Groupon, Living Social, CNN, Entrepreneur, Mashable, Reed UK, Stack Social and many more.

2.  Is there a refund/cancellation policy?

Yes, we have a 7-day money-back refund guarantee. Just send us an email to email/info)(coursesforsuccess.com with the subject Courses For Success Refund so we can accommodate your request.

3.  What is the FREE Personal Success Training Program?

The Personal Success Training Program was developed by Courses For Success to help our customers achieve success. Currently, we are offering this program for FREE with every course or bundle purchase this month. This is a limited time offer! We have received thousands of reviews for this program, please see: Personal Success Training Program Reviews

4.  Are there any requirements to study this course?

No, anyone who has an interest in learning more about this subject matter is encouraged to take our course. There are no entry requirements to take this course.

5.  Do I require to have finished high school to complete this course?

No, you do not require a High School Diploma or to have finished school to study this course, this course is open to anyone who would like to take this course.

6.  What if English is not my first language?

This course is provided in English, however, due to the digital nature of our training, you can take your time studying the material and make use of tools such as google translate and Grammarly.

7.  Is this course online or conducted in person?

All our courses are accessible online on any device. You may complete them at your own pace and at your own time.

8.  How do I receive my course?

After you have completed the payment, you will receive a confirmation email and tax receipt. You will also receive an email containing your course login details (username and password), as well as instructions on how to access and log in to your course via the internet with any device, please check your junk/spam folder in the event that you do not receive the email.

9.  When does this course start?

Providing you have internet access you can start this course whenever you like, just go to the login page and insert your username and password and you can access the online material.

10.  What is online learning like?

Online learning is easy, if not easier than a traditional academic situation. By studying an online course, the usual boundaries caused by location and time constraints are eliminated, meaning you are free to study where and when you want at your own pace. Of course, you will need to be able to self-manage your time and be organized, but with our help, you’ll soon find yourself settling into a comfortable rhythm of study.

11.  What computer skills do I need for my course?

You don't need to be a computer expert to succeed with our online training, but you should be comfortable typing, using the internet and be capable of using common software (such as Microsoft word).

12.  How long will you have access to the online course?

There is no time limit for completing this course, it can be studied in your own time at your own pace. Once you have purchased this course you will have unlimited lifetime access, meaning you can access this course whenever you want.

13.  How long will my course take?

Individual courses are designed to be completed within 6-8 hours.

If you choose a course bundle, simply multiply the above hours by the number of courses included in the bundle.
For example:

  • 2 course bundle is 2 x 6-8 hours = 12-16 hours
  • 3 course bundle is 3 x 6-8 hours = 18-24 hours
  • 5 course bundle is 5 x 6-8 hours = 30-40 hours
  • 10 course bundle is 10 x 6-8 hours = 60-80 hours
14.  Do I need to buy textbooks?

All the required material for your course is included in the online system, you do not need to buy anything else.

15.  Is the course interactive?

Yes, all our courses are interactive.

16.  Is there an assessment or exam?

Yes, you will be required to complete a multiple-choice test online at the end of your course, you can do this test as many times as you require.

17.  What type of certificate will I receive?

You will receive a Certificate of Completion that is applicable worldwide, which demonstrates your commitment to learning new skills. You can share the certificate with your friends, relatives, co-workers and employers. Also, include it in your resume/CV, professional social media profiles and job applications.

Wendy Sue Hunt - 5 STAR REVIEW
"If you are considering taking any “Courses for Success”, I would highly recommend it. I have always been a firm believer it’s important to always sharpen your skills. You are never too old to learn more. I found the courses very helpful, interesting and easy to understand.
The term “Courses for Success” helped me in my current position to succeed. After completing the courses, I gave my manager the completion certificates. Recently I received a promotion too."
Valencia Marie Aviles - 5 STAR REVIEW
"I had a very good experience with my course. It has helped me to get multiple jobs and prepared me for almost everything I would need to know. The course was very informative and easy to understand and broken up perfectly to be done in a short amount of time while still learning a good amount! I would recommend Courses for Success to anyone trying to get abs certifications for job advancements, it is well worth it!"
ELENA GRIFFIN - 5 STAR REVIEW
"I have absolutely enjoyed the materials from Courses for Success. The materials are easy to understand which makes learning enjoyable. Courses for Success have great topics of interest which make you come back for more.
Thank you Courses for Success for being part of my learning journey and making education affordable!"

Our completion certificates are very valuable and will help you progress in your work environment and show employers how committed you are to learn new skills, you might even get a promotion.

18.  Will this course be credited by universities?

No, it is not equivalent to a college or university credit.

19.  Am I guaranteed to get a job with this certificate?

This course will give you the skills you need to help you obtain employment, but it’s up to you if you get the job or not.

20.  How will this course assist me with my career?

Studying and completing this course will show employers that you have the knowledge in this field, additionally you will gain more confidence in this area of expertise.

21.  How long is the certificate valid for?

The Certificates are valid for life and do not need renewing. 

22.  Can I take more than one course at a time?

Courses are studied online at your own pace and you are free to study as many or as few courses as you wish, we also offer online course bundles that allow you to save on additional courses so that you may get all the topics related to your training goals in one go.

23.  What are the Payment Methods available? Is there a payment plan?

We accept payments via PayPal, Credit Card, Bank Transfer and Amazon Pay for the USA. For payment plans, we offer Sezzle for USA & Canada, Afterpay for Australia & New Zealand. *For faster transaction Credit Card payments are preferred. Please purchase online via our website course product page or contact us at email/info)(coursesforsuccess.com, to pay via bank transfer.

24.  Can I purchase for multiple people?

Yes, you can do this by purchasing individually via website or send us a request via email at email/info)(coursesforsuccess.com

25.  Can I request for an invoice before purchase?

Yes, you can request for an invoice via email at email/info)(coursesforsuccess.com

26.  Purchase for a gift?

Yes, you can purchase this course as a gift, simply send an email to email/info)(coursesforsuccess.com, with the course details and we can accommodate this.

27.  Can I create my own course bundle?

Yes, you can customize your own bundle. Please send us the complete list with the exact course link of the courses you'd like to bundle up via email email/info)(coursesforsuccess.com and we will create them for you. *Each course access, time of completion and certification varies depending on the course type.

28.  How will I contact Courses For Success if I have any questions?

You can contact our support team, at any time through live chat on our website, or email at email/info)(coursesforsuccess.com, or by calling one of our phone numbers depending on which country you are in.  

About this Course

 Learn Everything you Need to Know About Microsoft Word - 10 Courses in this Bundle

  1. Word 2016 Essentials

  2. Word 2016 Expert

  3. Word 365 Essentials

  4. Excel 2016 Advanced

  5. Excel 2016 and VBA Online

  6. Excel 2016 Essentials

  7. Excel 2016 Expert

  8. Word 2016 Part 1

  9. Word 2016 Part 2

  10. Word 2016 Part 3

1. Word 2016 Essentials: Learn the fundamental understanding of the Microsoft Word

You will gain a fundamental understanding of the Microsoft Word environment and the ability to complete tasks independently. They will demonstrate the correct application of the principle features of Word 2016 by creating and editing documents for a variety of purposes and situations. Document examples include professional looking reports, multi-column newsletters, resumes, and business correspondence.

Key Learning Objectives

  • Create and manage documents
  • Format text, paragraphs, and sections
  • Create tables and lists
  • Create and manage references
  • Insert and format graphic elements

2. Word 2016 Expert: Learn to proficiently use the advanced features of Microsoft Word for document content management and advanced formatting

You will learn to proficiently use the advanced features of Microsoft Word for document content management and advanced formatting - critical skills for those in roles such as editors, project managers, business information workers, and educators. You will create and manage professional multi-page documents for a variety of specialized purposes and situations. You will customize their Word 2016 environments to meet project needs, and to enhance productivity. Examples of expert-level documents include a business plan, a research paper, a specialized brochure, and a mass mailing. 

Key Learning Objectives

  • Control Pagination
  • Work with styles
  • Perform advanced editing and formatting
  • Create and manage indexes
  • Create and manage references
  • Manage forms and fields
  • Create mail merge and labels
  • Create and modify building blocks and content controls
  • Work with Macros
  • Create custom style sets, themes and templates
  • Prepare a document for internationalization and accessibility
  • Work with templates
  • Use version control
  • Manage document reviews and changes

3. Word 365 Essentials: Learn to use Office 365 Word

Office 365 Word Web App Essentials course, you can access your documents anywhere, and make some basic changes without using a computer where your desktop Office applications are installed.

With Office 365 Word you will learn how to edit, share, and publish Word files using the Office 365 interface. The Office 365 experience is designed to render your documents to look exactly like they would when printed, from nearly anywhere in the world. This tool provides its users the freedom to work from anywhere.

Key Learning Objectives

  • Open and close documents in reading or editing view
  • Understand the Office 365 web interface, including the home page, the team site, and the shared documents list
  • Understand the Word 365 browser interface
  • Upload a document to the Shared Documents library 
  • Open a document in Reading View or Editing View
  • Page through documents
  • Zoom to a different view
  • Open the pop out
  • Open in Editing View
  • Type, select, and edit text
  • Understand the Word web app interface
  • Use cut, copy, and paste
  • Undo and redo tasks
  • Format fonts and paragraphs with a variety of features
  • Use bullets and numbering
  • Insert and work with tables
  • Insert links
  • Insert and work with pictures
  • Insert clip art

4. Excel 2016 Advanced: Advance your Excel skills with our Excel 2016 Advanced Online Certificate Course

In this course, students will learn how to use range names in formulas and functions, as well as how to use specialized functions.

Key Learning Objectives

  • Creating advanced formulas
  • Analyzing data with logical and lookup functions
  • Organizing worksheet data with Tables
  • Visualizing data with Charts
  • Analyzing data with PivotTables, Slicers, and PivotCharts
  • Inserting graphics
  • Enhancing workbooks

5. Excel 2016 and VBA Online: Become an expert in Microsoft Excel with our Excel 2016 and VBA Online Certificate Course

Give students the chance to expand on the knowledge they gained in Excel 2016 Essentials Course by introducing them to Microsoft Excel 2016 and VBA course.

Microsoft Office Excel 2016 and VBA continues in-depth training for Excel 2016. This course gives students the skills they need to harness Visual Basic for Applications, or VBA, to automate many tasks they encounter while using Excel 2016.

Key Learning Objectives

  • Developing Macros
  • Formatting Worksheets Using Macros
  • Creating an Interactive Worksheet
  • Working with Multiple Worksheets
  • Performing Calculations

6. Excel 2016 Essentials: Learn to Gain an advanced level of understanding for the Microsoft Excel environment

Gain an advanced level of understanding for the Microsoft Excel environment, and the ability to guide others to the proper use of the program's full features - critical skills for those in roles such as accountants, financial analysts, and commercial bankers. You will create, manage, and distribute professional spreadsheets for a variety of specialized purposes and situations. They will customize their Excel 2016 environments to meet project needs and increase productivity. Expert workbook examples include custom business templates, multi-axis financial charts, amortization tables, and inventory schedules. 

Key Learning Objectives

  • Create worksheets and workbooks
  • Navigate in worksheets and workbooks
  • Format worksheets and workbooks
  • Change views and configurations
  • Print and distribute worksheets and workbooks
  • Manage data cells and ranges
  • Create tables, charts and objects
  • Perform operations with formulas and functions

7. Excel 2016 Expert: Learn to create, manage, and distribute professional spreadsheets

Gain an advanced level of understanding for the Microsoft Excel environment, and the ability to guide others to the proper use of the program's full features - critical skills for those in roles such as accountants, financial analysts, and commercial bankers. You will create, manage, and distribute professional spreadsheets for a variety of specialized purposes and situations. They will customize their Excel 2016 environments to meet project needs and increase productivity. Expert workbook examples include custom business templates, multi-axis financial charts, amortization tables, and inventory schedules.

Key Learning Objectives

  • Save a workbook as a template, with colors, fonts, cell styles and themes
  • Reference data using structured references or data in another workbook
  • Protect a workbook from further editing
  • Prepare a workbook for internationalization
  • Apply custom data formats and validation
  • Apply advanced conditional formatting and filtering
  • Use form controls
  • Work with macros

8. Word 2016 Part 1: Learn to create a basic document

To begin this course, you will learn about the parts of the Microsoft Word 2016 interface, how to create a basic document, and how to find help in Microsoft Word.

Key Learning Objectives

  • Getting started with Word
  • Editing a document
  • Formatting text and paragraphs
  • Adding tables
  • Managing lists
  • Inserting graphic objects
  • Controlling page appearance
  • Proofing a document
  • Customizing the Word environment

9. Word 2016 Part 2: Learn to create, modify, and manage templates

Keep the learning going with the second course in our Microsoft Word 2016 series – Microsoft Word 2016 Part Two. This course is designed to help users who are familiar with Word’s basic features to take their skills to the next level.

Key Learning Objectives

  • Working with objects (including tables, charts, images, text boxes, shapes, and SmartArt)
  • Using document management tools such as Building Blocks, templates, and custom themes
  • An introduction to expert-level tools, such as macros and mail merge

10. Word 2016 Part 3: Learn to create, and manipulate forms

In this course, students will learn how to create, and manipulate forms. Techniques for saving and exporting form data are also covered.

Key Learning Objectives

  • Sharing a document, working with comments, reviewing a document
  • Adding cross-references, bookmarks and hyperlinks
  • Inserting blank and cover pages, tables of contents, indexes, and managing outlines
  • Setting editing restrictions
  • Creating and manipulating forms
  • Creating and comparing document versions, and merging document version

Receive Lifetime Access to Course Materials, so you can review at any time.

For comprehensive information on units of study click the units of study tab above.

This is an incredible opportunity to invest in yourself and your future, sharpen your training skills and learn what it takes to create your own success with Courses For Success Today!

Course Fast Facts:

  1. All courses are easy to follow and understand
  2. Only 6 to 8 hours of study is required per course
  3. Unlimited lifetime access to course materials
  4. Study as many courses as you want
  5. Delivered 100% on-line and accessible 24/7 from any computer or smartphone
  6. You can study from home or at work, at your own pace, in your own time
  7. Certificates

Course Delivery

Courses are accessed online via our learning management system by any device including PC, MAC, tablet or Smart Phone.

Recognition & Accreditation

The courses offered by Courses For Success are unique as they are taught in a step-by-step process enabling students to complete them quickly and easily, so that you can obtain your qualification sooner. All students who complete the course receive a certificate of completion. CoursesForSuccess is committed to high completion rates and therefore 100% student satisfaction.

Receive Lifetime Access to Course Materials, so you can review it at any time.

The Ultimate Word 2016 Essentials 10 Course Bundle includes the following courses, below is a summary of each course: 

Course 1 - Word 2016 Essentials Online Certificate Course

 Module One: Getting Started

  • Course Objectives

Module Two: Create and Manage Documents

  • Creating a Document
  • Introduce the Ribbon
  • Open the New Screen
  • Create a Blank Document
  • Create a Document from a Template
  • Open a PDF for Editing
  • Insert Text from a File
  • Navigating Through a Document
  • Search for Text
  • Navigate to Page
  • Use the Go To Dialog Box
  • Formatting a Document, Part One
  • Change Margins
  • Change Page Orientation
  • Change Page Size
  • Use the Page Setup Dialog Box
  • Insert Headers and Footers
  • Insert Page Numbers
  • Formatting a Document, Part Two
  • Apply Document Themes
  • Apply Document Style Sheets
  • Add a Watermark
  • Change Page Background Color
  • Use the Page Borders Dialog Box
  • Customizing Options and Views for Documents
  • Change Document View
  • Zoom
  • Add a Tool to the Quick Access Toolbar
  • Split View Window
  • Add Document Properties
  • Show or Hide Formatting Symbols
  • Printing and Saving Documents
  • Print
  • Save in Another File Format
  • Inspect a Document for Hidden Properties and Personal Information
  • Inspect a Document for Accessibility Issues
  • Inspect a Document for Compatibility Issues

Module Three: Format Text, Paragraphs, and Sections

  • Inserting and Selecting Text and Paragraphs
  • Select Text with the Mouse or Keyboard
  • Insert Special Characters
  • Editing Text
  • Cut and Paste Text
  • Copy and Paste using Keyboard Shortcuts
  • Change Text Automatically Using AutoCorrect
  • Replace Text
  • Formatting Text
  • Apply Font Face and Size
  • Use the Font Context Lis
  • Use the Format Painter
  • Highlight Text
  • Formatting Paragraphs
  • Change Line Spacing
  • Change Paragraph Spacing
  • Use Indents and Tabs
  • Clear Formatting
  • Using Styles and WordArt
  • Apply Built-in Styles
  • Change Text to WordArt
  • Breaking Up Text
  • Insert a Page Break
  • Insert a Section Break
  • Change Page Setup Options for a Section
  • Create Multiple Column Layout
  • Insert a Column Break

Module Four: Create Lists and Tables

  • Using Bulleted Lists
  • Create a Bulleted List
  • Define a Custom Bullet Character
  • Using Numbered Lists
  • Create a Numbered List
  • Control List Numbering
  • Change List Levels
  • Define a Custom Number Format
  • Creating a Table
  • Insert a Table
  • Convert Text to Table
  • Convert Tables to Text
  • Apply Table Styles
  • Modifying a Table
  • Resize a Table
  • Resize a Table’s Rows or Columns
  • Repeat Row Headers
  • Sort Table Data
  • Merge Cells
  • Split Cells
  • Split a Table
  • Set Cell Margins and Spacing

Module Five: Insert and Format Graphic Elements

  • Insert Graphic Elements
  • Insert Shapes
  • Insert Pictures
  • Insert a Full-Size Screenshot
  • Insert a Screen Clipping
  • Insert a Text Box
  • Formatting Graphic Elements
  • Select a Graphical Element
  • Format a Shape
  • Set the Text Wrapping
  • Set Positioning
  • Add Alternative Text
  • Enhancing Pictures
  • Apply a Picture Style
  • Apply Picture Effects
  • Apply Artistic Effects
  • Remove the Background from a Picture
  • Using SmartArt
  • Insert SmartArt
  • Add Text to SmartArt
  • Customize SmartArt
  • Add Shape to SmartArt

Module Six: Create and Manage References

  • Create Bookmarks and Links
  • Insert a Bookmark
  • Insert a Hyperlink
  • Creating Common Front Matter
  • Insert a Standard Table of Contents
  • Update a Table of Contents
  • Insert a Cover Page
  • Using Captions, Footnotes and Endnotes
  • Add a Figure or Table Caption
  • Modify Caption Properties
  • Add a Footnote
  • Add an Endnote
  • Modify Footnote and Endnote Properties
  • Creating and Managing Reference Markers
  • Create Bibliography Citation Sources
  • Modify Bibliography Citation Sources
  • Insert Citations for Bibliographies

Module Seven: Wrapping Up

  • Words from the Wise
  • Lessons Learned

Course 2 - Word 2016 Expert Online Certificate Course

 Module One: Getting Started

  • Course Objectives

Module Two: Design Advanced Documents

  • Control Pagination
  • Create a Two-Page Layout
  • Change Header and Footer Space
  • Change Vertical Page Alignment
  • Set Paragraph Pagination Options
  • Work with Styles
  • Modify Existing Styles
  • Resolve Style Conflicts by Using Paste Options
  • Create Paragraph and Character Styles
  • Perform Advanced Editing and Formatting
  • Find Using Formatting
  • Replace Formatting
  • Find and Replace Using Special Characters
  • Find and Replace Text by Using Wildcards
  • Link Text Boxes

Module Three: Create Advanced References

  • Create and Manage Indexes
  • Mark Index Entries
  • Create Indexes
  • Update Indexes
  • Create and Manage References
  • Customize a Table of Contents
  • Insert and Modify Captions
  • Create and Modify a Table of Figures
  • Manage Forms and Fields
  • Add Custom Fields
  • Modify Field Properties
  • Create Mail Merge and Labels
  • Manage Recipient Lists
  • Insert Merged Fields
  • Preview Merge Results
  • Perform Mail Merge

Module Four: Create Custom Word Elements

  • Create and Modify Building Blocks and Content Controls
  • Create Quick Parts
  • Manage Building Blocks
  • Insert and Configure Content Controls
  • Work with Macros
  • Record a Macro
  • Run a Macro
  • Assign a Macro to a Button or Shortcut Key
  • Enable Macros
  • Create Custom Style Sets and Templates
  • Create Custom Color Sets
  • Create Custom Font Sets
  • Create Custom Themes
  • Create Custom Style Sets
  • Manage Multiple Options for +Body and +Heading Fonts
  • Prepare a Document for Internationalization and Accessibility
  • Configure Language Options in Documents
  • Add Alt Text to Document Elements

Module Five: Manage Document Options and Settings

  • Work with Templates
  • Modify Existing Templates
  • Manage Template and Document Elements
  • Customize the Ribbon
  • Change the Application Default Font
  • Use Version Control
  • Restrict Editing
  • Mark a Document as Final
  • Protect a Document with a Password
  • Manage Document Versions
  • Manage Document Reviews and Changes
  • Track Changes
  • Manage Tracked Changes
  • Lock or Unlock Tracking
  • Add Comments
  • Manage Comments
  • Compare and Combine Multiple Documents

Module Six: Wrapping Up

  • Words from the Wise
  • Review of Parking Lot
  • Completion of Action Plans and Evaluations

Course 3 - Word 365 Essentials Online Certificate Course

 Module One: Getting Started

By the end of this course, you will be able to:

  • Open and close documents in reading or editing view
  • Understand the Office 365 web interface, including the home page, the team site, and the shared documents list
  • Understand the Word 365 browser interface
  • Upload a document to the Shared Documents library 
  • Open a document in Reading View or Editing View
  • Page through documents
  • Zoom to a different view
  • Open the pop out
  • Open in Editing View
  • Type, select, and edit text
  • Understand the Word web app interface
  • Use cut, copy, and paste
  • Undo and redo tasks
  • Format fonts and paragraphs with a variety of features
  • Use bullets and numbering
  • Insert and work with tables
  • Insert links
  • Insert and work with pictures
  • Insert clip art

Module Two: Welcome to Office 365 Web Apps

  • The Home Page
  • The Team Site
  • Shared Documents
  • Uploading a Document

Module Three: Viewing Web App Documents (I)

  • Opening a Document
  • Overview of the Reading View
  • Paging Through Documents
  • Printing From the Reading View
  • Finding Text in Your Document
  • Closing Documents

Module Four: Viewing Web App Documents (II)

  • Zooming in your Document
  • Using the Pop Out
  • Editing in Browser
  • About Converting Documents
  • Opening in Word

Module Five: Editing in the Browser

  • A New File
  • Saving Files
  • The Word Web App Interface
  • Typing Text
  • Selecting Text with the Mouse or Keyboard
  • Editing and Deleting Text

Module Six: Basic Editing Tasks

  • Using Cut, Copy, and Paste
  • Using Undo and Redo
  • Checking Your Spelling
  • Setting the Proofing Language
  • Printing from the Editing View
  • Accessing the Reading View

Module Seven: Font Formatting

  • Understanding Levels of Formatting
  • Changing Font Face and Size
  • Changing the Font Color
  • Adding Font Enhancements
  • Highlighting Text

Module Eight: Formatting Paragraphs

  • Setting the Alignment
  • Using Indents and Tabs
  • Adding Bullets and Numbering
  • Text Direction

Module Nine: Working with Styles

  • About Styles
  • Quick Styles versus the Style Gallery
  • Applying a Style
  • Clearing Formatting

Module Ten: The Insert Tools (I)

  • Inserting a Table
  • Adding Text to a Table
  • Inserting Links

Module Eleven: The Insert Tools (II)

  • Inserting Pictures
  • Inserting Clip Art
  • Working with Pictures

Module Twelve: Wrapping Up
Words from the Wise

Course 4 - Excel 2016 Advanced Online Certificate Course

 Lesson 1: Creating Advanced Formulas

  • TOPIC A: Apply Range Names
  • Range Names
  • Adding Range Names Using the Name Box
  • Adding Range Names Using the New Name Dialog Box
  • Editing a Range Name and Deleting a Range Name
  • Using Range Names in Formulas
  • Activity 1-1
  • TOPIC B: Use Specialized Functions
  • Function Categories
  • The Excel Function Reference
  • Function Syntax
  • Function Entry Dialog Boxes
  • Using Nested Functions
  • Automatic Workbook Calculations
  • Showing and Hiding Formulas
  • Enabling Iterative Calculations
  • Activity 1-2
  • Summary
  • Review Questions

Lesson 2: Analyzing Data with Logical and Lookup Functions

  • TOPIC A: Use Text Functions
  • Text Functions
  • The LEFT and RIGHT Functions
  • The MID Function
  • The LEN Function
  • The TRIM Function
  • The UPPER, LOWER, and PROPER Functions
  • The CONCATENATE Function
  • The TRANSPOSE Function
  • Activity 2-1
  • TOPIC B: Use Logical Functions
  • Logical Functions
  • Logical Operators
  • The AND Function
  • The OR Function
  • The IF Function
  • Activity 2-2
  • TOPIC C: Use Lookup Functions
  • Lookup Functions
  • The LOOKUP Function
  • The VLOOKUP Function
  • The HLOOKUP Function
  • Activity 2-3
  • TOPIC D: Use Date Functions
  • The TODAY Function
  • The NOW Function
  • Serializing Dates and Times with Functions
  • Activity 2-4
  • TOPIC E: Use Financial Functions
  • The IPMT Function
  • The PPMT Function
  • The NPV Function
  • The FV Function
  • Activity 2-5
  • Summary
  • Review Questions

Lesson 3: Organizing Worksheet Data with Tables

  • TOPIC A: Create and Modify Tables
  • Tables
  • Table Components
  • The Create Table Dialog Box
  • The Table Tools – Design Contextual Tab
  • Styles and Quick Style Sets
  • Customizing Row Display
  • Table Modification Options
  • Activity 3-1
  • TOPIC B: Sort and Filter Data
  • The Difference Between Sorting and Filtering
  • Sorting Data
  • Advanced Filtering
  • Filter Operators
  • Removing Duplicate Values
  • Activity 3-2
  • TOPIC C: Use Subtotal and Database Functions to Calculate Data
  • SUBTOTAL Functions
  • The Subtotal Dialog Box
  • Summary Functions in Tables
  • Database Functions
  • Activity 3-3
  • Summary
  • Review Questions

Lesson 4: Visualizing Data with Charts

  • TOPIC A: Create Charts
  • Charts
  • Chart Types
  • Chart Insertion Methods
  • Resizing and Moving the Chart
  • Adding Additional Data
  • Switching Between Rows and Columns
  • Activity 4-1
  • TOPIC B: Modify and Format Charts
  • The Difference Between Modifying and Formatting
  • Chart Elements
  • Minimize Extraneous Chart Elements
  • The Chart Tools Contextual Tabs
  • Formatting the Chart with a Style
  • Adding a Legend to the Chart
  • Activity 4-2
  • TOPIC C: Create a Trendline
  • Trendlines
  • Types of Trendlines
  • Adding a Trendline
  • The Format Trendline Task Pane
  • Activity 4-3
  • TOPIC D: Create Advanced Charts
  • Dual Axis Charts
  • Creating Custom Chart Templates
  • Viewing Chart Animations
  • Activity 4-4
  • Summary
  • Review Questions

Lesson 5: Analyzing Data with PivotTables, Slicers, and PivotCharts

  • TOPIC A: Create a PivotTable
  • PivotTables
  • Start with Questions, End with Structure
  • The Create PivotTable Dialog Box
  • The PivotTable Fields Pane
  • Summarize Data in a PivotTable
  • The “Show Values As” Functionality of a PivotTable
  • External Data
  • PowerPivot
  • PowerPivot Functions
  • Activity 5-1
  • TOPIC B: Filter Data by Using Slicers
  • Slicers
  • The Insert Slicers Dialog Box
  • Activity 5-2
  • TOPIC C: Analyze Data with PivotCharts
  • PivotCharts
  • Creating PivotCharts
  • Applying a Style to a PivotChart
  • Activity 5-3
  • Summary
  • Review Questions

Lesson 6: Inserting Graphics

  • TOPIC A: Insert and Modify Graphic Objects
  • Graphical Objects
  • Inserting Shapes
  • Inserting WordArt
  • Inserting Text Boxes
  • Inserting Images
  • The Picture Tools – Format Contextual Tab
  • The Drawing Tools – Format Contextual Tab
  • The SmartArt Tools Contextual Tabs
  • Activity 6-1
  • TOPIC B: Layer and Group Graphic Objects
  • Layering Objects
  • Grouping Objects
  • Positioning Objects
  • Activity 6-2
  • TOPIC C: Incorporate SmartArt
  • About SmartArt
  • The Choose a SmartArt Graphic Dialog Box
  • About the Text Pane
  • Activity 6-3
  • Summary
  • Review Questions

Lesson 7: Enhancing Workbooks

  • TOPIC A: Customize Workbooks
  • Comments
  • Hyperlinks
  • Watermarks
  • Background Pictures
  • Activity 7-1
  • TOPIC B: Manage Themes
  • About Themes
  • Customizing Themes
  • Activity 7-2
  • TOPIC C: Create and Use Templates
  • Templates
  • Template Types
  • Creating a Template
  • Modifying a Template
  • Activity 7-3
  • TOPIC D: Protect Files
  • Recovering Lost Data
  • The Changes Group
  • Worksheet and Workbook Protection
  • The Protect Worksheet Option
  • The Protect Workbook Option
  • Activity 7-4
  • TOPIC E: Preparing a Workbook for Multiple Audiences
  • Displaying Data in Multiple International Formats
  • Utilize International Symbols
  • Modifying Worksheets Using the Accessibility Checker
  • Managing Fonts
  • Activity 7-5
  • Summary
  • Review Questions

Course 5 - Excel 2016 and VBA Online Certificate Course

 Lesson 1:?Developing Macros

  • Visual Basic for Applications
  • Object-Oriented Programming
  • Macros
  • Macro Options
  • The Macro Recorder
  • Personal Macro Workbooks
  • How to Create a Macro Using the Macro Recorder
  • Activity 1-1
  • The Visual Basic Editor
  • Projects
  • Modules
  • The Modules Folder
  • Objects
  • Properties
  • Methods
  • VBA Comments
  • How to Edit a Macro
  • Activity 1-2
  • The Debugging Process
  • Debugging Tools
  • How to Debug a Macro
  • Activity 1-3
  • How to Customize the Quick Access Toolbar and Hotkeys
  • Activity 1-4
  • Digital Certificates
  • Digital Signatures
  • Macro Security Settings
  • How to Set Macro Security
  • Activity 1-5
  • Summary
  • Review Questions

Lesson 2:?Formatting Worksheets Using Macros

  • The Selection Property
  • The ActiveSheet Property
  • The Name Property
  • The Value Property
  • Concatenation
  • How to Insert Text
  • Activity 2-1
  • How to Format Text
  • Activity 2-2
  • The Range Object
  • The Select Method
  • The CurrentRegion Property
  • How to Sort Data
  • Activity 2-3
  • Data Types
  • Variables
  • Variable Naming Rules
  • Operators
  • The Assignment Operator
  • Arithmetic Operators
  • Comparison Operators
  • Logical Operators
  • The For Next Loop
  • Do Loops
  • The Worksheets Object
  • The Count Property
  • The Offset Property
  • The Copy Method
  • The Paste Method
  • How to Duplicate Data
  • Activity 2-4
  • The Columns Property
  • The AutoFit Method
  • The Address Property
  • The Call Statement
  • The Font Property
  • The End Property
  • How to Generate a Report
  • Activity 2-5
  • Summary
  • Review Questions

Lesson 3:?Creating an Interactive Worksheet

  • Message Boxes
  • Input Boxes
  • Activity 3-1
  • The InputBox Function
  • Constants
  • The MsgBox Function
  • The Code Continuation Character
  • The vbCrLf Constant
  • Decision Structures
  • The Select Case Statement
  • The If Then Structure
  • The Else Clause
  • How to Capture User Input
  • Activity 3-2
  • Summary
  • Review Questions

Lesson 4:?Working with Multiple Worksheets

  • The Add Method
  • The Copy Method
  • The Delete Method
  • How to Insert, Copy, and Delete Worksheets
  • Activity 4-1
  • Expressions
  • The DateSerial Function
  • The Format Function
  • How to Rename Worksheets
  • Activity 4-2
  • The Move Method
  • How to Modify the Order of Worksheets
  • Activity 4-3
  • The PrintPreview Method
  • The PrintOut Method
  • How to Print Worksheets
  • Activity 4-4
  • Summary
  • Review Questions

Lesson 5:?Performing Calculations

  • User-Defined Functions
  • Types of Functions
  • Arguments
  • How to Create User-Defined Functions
  • Activity 5-1
  • Declared Range Objects
  • The Set Statement
  • Range Object Cell Addressing
  • The Rows Property
  • The Formula Property
  • The Columns Property
  • Address Property Cell Reference Settings
  • How to Automate SUM Functions
  • Activity 5-2
  • Summary
  • Review Questions

Course 6 - Excel 2016 Essentials Online Certificate Course

 Module One: Getting Started

  • Course Objectives

Module Two: Create and Manage Worksheets and Workbooks

  • Create Worksheets and Workbooks
  • Create a Workbook
  • Open a Comma Separated Values File
  • Add a Worksheet to An Existing Workbook
  • Navigate in Workbooks and Worksheets
  • Search for Data
  • Navigate to a Named Cell
  • Insert and Remove Hyperlinks
  • Hide or Unhide Columns and Rows
  • Hide or Unhide Sheets
  • Modify Worksheets
  • Insert and Delete Table Rows and Columns
  • Adjust Row Height and Column Width
  • Insert Headers and Footers
  • Change Worksheet Tab Color
  • Rename Worksheet
  • Format Workbooks
  • Copy and Move Worksheets
  • Modify Page Setup
  • Change Workbook Themes
  • Customize Options and Views for Worksheets and Workbooks
  • Add a Tool to the Quick Access Toolbar
  • Zoom
  • Change Workbook Views
  • Change Window Views
  • Modify Document Properties
  • Show or Hide Formulas
  • Configure Worksheets and Workbooks for Distribution
  • Print
  • Set a Print Area
  • Save in Another File Format
  • Repeat Columns or Rows Across Multiple Pages
  • Inspect a Workbook for Hidden Properties and Personal Information
  • Inspect a Workbook for Accessibility Issues
  • Inspect a Workbook for Compatibility Issues

Module Three: Manage Data Cells and Ranges

  • Insert Data in Cells and Ranges
  • Replace Data
  • Cut, Copy and Paste Data
  • Paste Data Using Paste Options
  • Fill Cells using Autofill
  • Insert and Delete Cells
  • Format Cells and Ranges
  • Merge Cells
  • Align and Indent Cell Contents
  • Wrap Text Within Cells
  • Apply Number Formats
  • Apply Cell Formats
  • Apply Cell Styles
  • Apply Conditional Formatting
  • Format Cells using the Format Painter
  • Summarize and Organize Data
  • Insert Sparklines
  • Grouping Data
  • Adding Subtotals
  • Outline Data
  • Viewing Grouped and Outlined Data

Module Four: Create Tables

  • Create and Manage Tables
  • Create an Excel Table from a Cell Range
  • Add or Remove Table Rows and Columns
  • Convert a Table to a Cell Range
  • Manage Table Styles and Options
  • Apply Styles to Tables
  • Configure Table Style Options
  • Insert Total Rows
  • Filter and Sort a Table
  • Filter Records
  • Clear Filters
  • Use a Number Filter or Text Filter
  • Change Sort Order
  • Sort Data by Multiple Columns
  • Remove Duplicate Records

Module Five: Perform Operations with Formulas and Functions

  • Building Formulas
  • Understand Math Basics of Excel
  • Build a Formula
  • Edit a Formula
  • Copy a Formula
  • Understand Relative vs. Absolute References
  • Perform Basic Functions
  • Understand Formulas vs. Functions
  • Calculate Using Status Bar
  • Perform Basic Functions
  • AutoComplete a Function
  • Create Functions using Formulas Tab
  • Perform Conditional Functions
  • Perform the IF Function
  • Perform the SUMIF Function
  • Perform the AVERAGEIF Function
  • Perform the COUNTIF Function
  • Format and Modify Text Using Functions
  • Format Text Using UPPER, LOWER, and PROPER Functions
  • Format Text Using the CONCAT Function
  • Format Text Using LEFT, RIGHT and MID Functions

Module Six: Use Quick Analysis, Charts and Objects

  • Analyze Data with Quick Analysis
  • Format with Quick Analysis
  • Create Charts with Quick Analysis
  • Calculate Totals with Quick Analysis
  • Create Charts
  • Use Recommended Charts
  • Create a New Chart
  • Add Additional Data Series
  • Switch Between Rows and Columns in Source Data
  • Format Charts
  • Resize Charts
  • Add and Modify Chart Elements
  • Apply Chart Styles and Layouts
  • Move Charts to a Chart Sheet
  • Add Data to Chart on a Chart Sheet
  • Insert and Format Objects
  • Insert Shapes
  • Insert Text Boxes
  • Format Shapes and Text Boxes
  • Insert Pictures
  • Add Alternative Text

Module Seven: Wrapping Up

  • Words from the Wise
  • Completion of Action Plans and Evaluations

Course 7 - Excel 2016 Expert Online Certificate Course

 Module One: Getting Started

  • Course Objectives

Module Two: Manage Workbook Options and Settings

  • Manage Workbooks
  • Save a Workbook as a Template
  • Reference Data in Another Workbook
  • Reference Data by Using Structured References
  • Display Hidden Ribbon Tabs
  • Manage Workbook Review
  • Mark a Workbook as Final
  • Protect a Workbook with a Password
  • Protect a Worksheet to Restrict Editing
  • Protect Workbook Structure
  • Manage Workbook Versions
  • Setting Calculation Options

Module Three: Apply Custom Data Formats and Layouts

  • Prepare a Workbook for Internationalization
  • Apply International Currency Formats
  • Apply Locale to Date or Time Formats
  • Apply Custom Data Formats and Validation
  • Create Custom Number Formats
  • Populate Cells by Using Advanced Fill Series Options
  • Configure Data Validation
  • Apply Advanced Conditional Formatting and Filtering
  • Create Custom Conditional Formatting Rules
  • Create Conditional Formatting Rules that Use Formulas
  • Manage Conditional Formatting Rules
  • Create and Modify Custom Workbook Elements
  • Create Custom Color Formats
  • Create Custom Font Sets
  • Create and Modify Cell Styles
  • Create and Modify Custom Themes
  • Manage Multiple Options for Theme Fonts
  • Insert and Configure Form Controls
  • Work with Macros
  • Enable Macros
  • Record a Macro
  • Run a Macro
  • Edit a Macro
  • Copy Macros from One Workbook to Another

Module Four: Create Advanced Formulas

  • Define Named Ranges and Objects
  • Name Cells
  • Use Named Cells in a Formula
  • Manage Named Ranges and Objects
  • Apply Functions in Formulas
  • Perform the AND Function and the OR Function
  • Perform NOT Function
  • Perform Logical Operations by Using Nested Functions
  • Perform SUMIFS, AVERAGEIFS, and COUNTIFS Functions
  • Look Up Data by Using Functions
  • Look Up Data by Using the VLOOKUP Function
  • Look Up Data by Using the HLOOKUP Function
  • Look Up Data by using the MATCH Function
  • Look Up Data by Using the INDEX Function
  • Apply Advanced Time and Date Functions
  • Serialize Numbers by Using Date and Time Functions
  • Reference the Date and Time Using the NOW and TODAY functions
  • Perform Data Analysis and Business Intelligence
  • Import, Transform, Combine, Display, and Connect to Data
  • Consolidate Data
  • Perform What-If Analysis by Using Goal Seek
  • Perform What-If Analysis by Using Scenario Manager
  • Troubleshoot Formulas
  • Trace Precedence and Dependence
  • Monitor Cells and Formulas using the Watch Window
  • Validate Formulas by Using Error Checking Rules
  • Evaluate Formulas

Module Five: Create Advanced Charts and Tables

  • Create Advanced Charts
  • Add Trendlines to Charts
  • Create Dual-Axis Charts
  • Save a Chart as a Template
  • Create and Manage PivotTables
  • Create Slicers
  • Create PivotTables
  • Modify Field Selections and Options
  • Group PivotTable Data
  • Reference Data in a PivotTable by Using the GETPIVOTDATA Function
  • Add Calculated Fields
  • Format Data
  • Create and Manage PivotCharts
  • Create PivotCharts
  • Drill Down into PivotChart Details
  • Apply Styles to PivotCharts
  • Manipulate Options in Existing PivotCharts

Module Six: Wrapping Up

  • Words from the Wise

Course 8 - Word 2016 Part 1 Online Certificate Course

 Lesson 1: Getting Started with Word

TOPIC A: Identify the Components of the Word Interface

  • Microsoft Office Word 2016
  • Word Documents
  • The Word Application Window
  • The Ribbon
  • The Backstage View
  • Task Panes
  • Galleries
  • Document Views
  • Window Views
  • Zoom Options
  • Activity 1-1

TOPIC B: Create a Word Document

  • Creating a Blank Document
  • Default Typing Options
  • Formatting Marks
  • Save Options
  • Sharing a Document
  • Preview and Print Options
  • Activity 1-2

TOPIC C: Help

  • Using Tell Me
  • Accessing Advanced Help Options
  • Activity 1-3
  • Summary
  • Review Questions

Lesson 2: Editing a Document

TOPIC A: Navigate and Select Text

  • Scroll Bars
  • Keyboard Navigation
  • Text Selection
  • Activity 2-1

TOPIC B: Modify Text

  • Text Editing Options
  • The Clipboard Task Pane
  • Paste Options
  • Live Preview
  • The Undo Command
  • The Redo Command
  • Activity 2-2

TOPIC C: Find and Replace Text

  • The Navigation Pane
  • The Find and Replace Dialog Box
  • Find Options
  • Find and Replace with Wildcards
  • Activity 2-3
  • Summary
  • Review Questions

Lesson 3: Formatting Text and Paragraphs

TOPIC A: Apply Character Formatting

  • Fonts
  • The Mini Toolbar
  • Font Options
  • Text Highlighting Options
  • The Format Painter
  • Activity 3-1

TOPIC B: Align Text Using Tabs

  • Tabs
  • Rulers
  • Tab Stops on a Ruler
  • The Tabs Dialog Box
  • Activity 3-2

TOPIC C: Display Text as List Items

  • Lists
  • Bulleted Lists
  • Numbered Lists
  • Activity 3-3

TOPIC D: Control Paragraph Layout

  • Margins
  • Paragraph Alignment Options
  • Indents
  • Indent Markers
  • Indentation Options
  • Spacing Options
  • Hyphenation
  • Activity 3-4

TOPIC E: Apply Borders and Shading

  • Borders
  • Types of Borders
  • Shading
  • The Borders and Shading Dialog Box
  • Activity 3-5

TOPIC F: Apply Styles

  • Word Styles
  • Style Sets
  • The Styles Task Pane
  • Applying Styles
  • Activity 3-6

TOPIC G: Manage Formatting

  • The Reveal Formatting Task Pane
  • Clear Formatting Options
  • Find and Replace Text Formatting Options
  • Activity 3-7
  • Summary
  • Review Questions

Lesson 4: Adding Tables

TOPIC A: Insert a Table

  • Tables
  • Using Tables to Control Page Layout
  • Table Creation Options
  • Quick Tables
  • Inserting Word Data
  • Table Navigation Methods
  • Activity 4-1

TOPIC B: Modify a Table

  • Table Selection Methods
  • The Table Tools – Layout Contextual Tab
  • The Table Properties Dialog Box
  • Inserting and Deleting Rows and Columns
  • Moving and Resizing Rows and Columns
  • Customizing Cell Margins
  • Setting Table Titles
  • Activity 4-2

TOPIC C: Format a Table

  • Table Styles
  • Table Fonts
  • The Table Tools – Design Contextual Tab
  • Activity 4-3

TOPIC D: Convert Text to a Table

  • The Convert Text to Table Dialog Box
  • The Convert Table to Text Dialog Box
  • Activity 4-4
  • Summary
  • Review Questions

Lesson 5: Managing Lists

TOPIC A: Sort a List

  • Sort Types
  • Sort Fields
  • Sorting Text
  • Activity 5-1

TOPIC B: Renumber a List

  • Renumbering Options
  • Activity 5-2
  • TOPIC C: Customize a List
  • Multilevel Lists
  • Increasing and Decreasing List Levels
  • List Styles
  • The Multilevel List Gallery
  • List Appearance Customization Options
  • List Appearance Formatting Options
  • Activity 5-3
  • Summary
  • Review Questions

Lesson 6: Inserting Graphic Objects

TOPIC A: Insert Symbols and Special Characters

  • Symbols
  • Special Characters
  • Activity 6-1

TOPIC B: Add Images to a Document

  • Illustrations
  • Local Pictures
  • Online Pictures
  • The Picture Tools – Format Contextual Tab
  • Activity 6-2
  • Summary
  • Review Questions

Lesson 7: Controlling Page Appearance

TOPIC A: Apply a Page Border and Color

  • Page Borders
  • Border Options
  • Page Color Options
  • Activity 7-1

TOPIC B: Add a Watermark

  • Watermarks
  • The Printed Watermark Dialog Box
  • Activity 7-2

TOPIC C: Add Headers and Footers

  • Inserting Page Numbers
  • Headers and Footers
  • The Header & Footer Tools – Design Tab
  • Activity 7-3

TOPIC D: Control Page Layout

  • Margin Options
  • Page Orientation
  • Vertical Alignment Options
  • The Paper Size Option
  • Page Breaks
  • The Page Setup Dialog Box
  • Activity 7-4
  • Summary
  • Review Questions

Lesson 8: Proofing a Document

TOPIC A: Check Spelling and Grammar

  • Spelling and Grammar Check Options
  • The Dictionary
  • The Insights Pane
  • The Readability Statistics Dialog Box
  • The Word Count Dialog Box
  • Activity 8-1

TOPIC B: Other Proofing Tools

  • The Thesaurus
  • The Thesaurus Task Pane
  • The Translation Feature
  • The Research Options Dialog Box
  • Activity 8-2

TOPIC C: Check Accessibility

  • Accessibility
  • Section 508
  • Accessibility Checker
  • Adding Alternative Text to Objects
  • Activity 8-3
  • Summary
  • Review Questions

Lesson 9: Customizing the Word Environment

TOPIC A: Customize the Word Interface

  • The Word Options Dialog Box
  • Customizing the Ribbon
  • Customizing the Quick Access Toolbar
  • The AutoCorrect Dialog Box
  • The AutoCorrect Tab
  • Activity 9-1

TOPIC B: Additional Save Options

  • Word 2016 File Formats
  • Compatibility Checker
  • AutoSave
  • AutoRecover
  • Recovering an Unsaved Document
  • Activity 9-2

TOPIC C: Manage Additional File Types

  • Opening Non-Native Files in Microsoft Word
  • Importing Files
  • Opening and Editing PDF Documents
  • Appending Text to a Document
  • Linking to Other Documents
  • Activity 9-3
  • Summary

Course 9 - Word 2016 Part 2 Online Certificate Course

 Lesson 1: Working with Tables and Charts

TOPIC A: Sort Table Data

  • Sorting Tables
  • Activity 1-1

TOPIC B: Control Cell Layout

  • Cell Merging
  • Cell Splitting
  • Cell Alignment
  • Text Direction
  • Activity 1-2

TOPIC C: Perform Calculations in a Table

  • Formulas in Word
  • Functions in Word
  • Equations
  • Activity 1-3

TOPIC D: Create a Chart

  • Charts
  • Chart Components
  • Types of Charts
  • Creating a Chart
  • The Chart Tools Tabs
  • Chart Quick Analysis Buttons
  • Changing the Chart Type
  • Editing Chart Data
  • Saving a Chart as a Template
  • The Caption Dialog Box
  • Activity 1-4
  • Summary
  • Review Questions

Lesson 2: Customizing Formats Using Styles and Themes

TOPIC A: Create and Modify Text Styles

  • Types of Text Styles
  • Applying Styles
  • Character Spacing
  • Custom Styles
  • The Create New Style from Formatting Dialog Box
  • Style Modification Options
  • Assigning Keyboard Shortcuts to Styles
  • Activity 2-1

TOPIC B: Create Custom List or Table Styles

  • Tools for List Styles
  • Tools for Table Styles
  • Activity 2-2

TOPIC C: Apply and Customize Document Themes

  • Applying Document Themes
  • Changing the Style Set
  • Creating Custom Style Sets
  • The Document Formatting Group
  • Creating Custom Color Schemes
  • Creating Custom Font Schemes
  • Saving Custom Themes
  • Activity 2-3
  • Summary
  • Review Questions

Lesson 3: Using Images in a Document

TOPIC A: Resize an Image

  • Resizing Options
  • Cropping Images
  • Activity 3-1

TOPIC B: Adjust Image Appearance

  • The Adjust Group
  • Corrections Options
  • Color Options
  • Artistic Effects Options
  • Compression Tools
  • The Background Removal Tool
  • Applying Picture Styles
  • Activity 3-2

TOPIC C: Integrate Pictures and Text

  • Text Wrapping Styles
  • Picture Positioning Options
  • Rotating Images
  • Adding Captions
  • Activity 3-3

TOPIC D: Insert and Format Screenshots

  • The Screenshot Tool
  • Activity 3-4
  • TOPIC E: Insert Video
  • Video Links
  • Inserting a Video
  • Playing a Video
  • Activity 3-5
  • Summary
  • Review Questions

Lesson 4: Creating Custom Graphic Elements

TOPIC A: Create Text Boxes and Pull Quotes

  • Types of Text Boxes
  • Inserting a Text Box with the Text Box Gallery
  • Drawing a Text Box
  • The Drawing Tools – Format Contextual Tab
  • Applying Text Box Styles
  • Formatting Text Boxes
  • Applying Shadow and 3-D Effects
  • Changing Text Direction
  • Saving the Selection to the Text Box Gallery
  • Arranging Text Boxes
  • Activity 4-1

TOPIC B: Draw Shapes

  • Shapes in Word
  • Types of Shapes
  • The Drawing Canvas
  • Text Wrapping Styles
  • Adding Text to a Shape
  • Modifying Text in a Shape
  • Adding Captions
  • Setting Shape Styles
  • Resizing Options
  • Positioning Options
  • Activity 4-2

TOPIC C: Add WordArt and Other Text Effects

  • WordArt
  • Drop Caps
  • Activity 4-3

TOPIC D: Create Complex Illustrations with SmartArt

  • SmartArt Graphics
  • The Choose a SmartArt Graphic Dialog Box
  • Adding Text and Images to the Diagram
  • SmartArt Graphic Categories
  • The SmartArt Tools Contextual Tabs
  • Activity 4-4
  • Summary
  • Review Questions

Lesson 5: Inserting Content Using Quick Parts

TOPIC A: Insert Building Blocks

  • Quick Parts
  • Building Blocks
  • The Building Blocks Organizer Dialog Box
  • Activity 5-1

TOPIC B: Create and Modify Building Blocks

  • The Create New Building Blocks Dialog Box
  • Building Block Modification Options
  • Copying Building Blocks Between Documents
  • Activity 5-2

TOPIC C: Insert Fields Using Quick Parts

  • Fields
  • Field Code Syntax
  • The Field Dialog Box
  • Activity 5-3
  • Summary
  • Review Questions

Lesson 6: Controlling Text Flow

TOPIC A: Control Paragraph Flow

  • Paragraph Flow Options
  • Activity 6-1

TOPIC B: Insert Section Breaks

  • Sections and Section Breaks
  • When to Use Section Breaks
  • Inserting a Section Break
  • Types of Section Breaks
  • Creating Section Titles
  • Activity 6-2

TOPIC C: Insert Columns

  • Text Columns
  • Text Column Options
  • Activity 6-3

TOPIC D: Link Text Boxes to Control Text Flow

  • Linked Text Boxes
  • Inserting Text from a File
  • Activity 6-4
  • Summary
  • Review Questions

Lesson 7: Using Templates

TOPIC A: Create a Document Using a Template

  • Templates in Word
  • Creating a Document from a Template
  • Viewing Personal Templates
  • Template Storage Locations
  • Activity 7-1

TOPIC B: Create a Template

  • Creating a New Template
  • Modifying a Template
  • Attaching a Template to a Document
  • Managing Templates with the Organizer
  • The Default Template Location
  • Activity 7-2
  • Summary
  • Review Questions

Lesson 8: Using Mail Merge

TOPIC A: The Mail Merge Features

  • Mail Merge
  • Mail Merge Fields
  • Mail Merge Rules
  • Data Sources
  • The Mail Merge Process
  • The Mailings Tab
  • The Mail Merge Wizard and Related Dialog Boxes
  • Opening a Mail Merge Document with a Data Source Attached
  • Unlinking a Data Source
  • Activity 8-1

TOPIC B: Merge Envelopes and Labels

  • Merge Options for Envelopes and Labels
  • Create a Single Envelope or Label
  • Set Up a Return Address
  • Activity 8-2

TOPIC C: Create a Data Source Using Word

  • Data Sources
  • Data Guidelines
  • Creating a Data Source Using Word
  • Activity 8-3
  • Summary
  • Review Questions

Lesson 9: Using Macros

TOPIC A: Automate Tasks Using Macros

  • Macros
  • The Developer Tab
  • The Macros Dialog Box
  • Macro Security
  • Macro Security Components
  • Activity 9-1

TOPIC B: Create a Macro

  • The Record Macro Dialog Box
  • Creating Keyboard Shortcuts for Macros
  • Assigning Macros to Buttons
  • Managing Macros with the Organizer
  • Visual Basic for Applications
  • Activity 9-2
  • Summary

Course 10 - Word 2016 Part 3 Online Certificate Course

 Lesson 1: Collaborating on Documents

TOPIC A: Modify User Information

  • Viewing File Properties
  • User Information
  • Activity 1-1

TOPIC B: Share a Document

  • Sharing Options
  • Presenting Documents Online
  • OneDrive
  • Configuring a Blog Account
  • Creating a Blog Post
  • Publishing a Blog Post
  • Activity 1-2

TOPIC C: Work with Comments

  • Inserting Comments
  • Editing Comments
  • Replying to Comments
  • Marking Comments Done
  • Navigating Through Comments
  • Deleting Comments
  • Activity 1-3

TOPIC D: Compare Document Changes

  • Legal Blackline
  • Comparison Settings
  • Accepting and Rejecting Changes
  • Activity 1-4

TOPIC E: Review a Document

  • Track Changes
  • Turn Track Changes On and Off
  • Markup Views
  • Track Changes Options
  • The Track Changes Indicator
  • Reviewing Changes
  • Activity 1-5

TOPIC F: Merge Document Changes

  • Combining Modifications from Multiple Reviewers
  • Revisions Pane
  • Resolving Style Conflicts
  • Activity 1-6

TOPIC G: Coauthor Documents

  • Sharing Documents Online
  • Editing a Shared File
  • Sharing Your Changes
  • Activity 1-7
  • Summary
  • Review Questions

Lesson 2: Adding Reference Marks and Notes

TOPIC A: Add Captions

  • Captions
  • Adding Captions
  • Caption Dialog Box
  • Activity 2-1

TOPIC B: Add Cross-References

  • Cross-References
  • Adding Cross-References
  • Cross-Reference Dialog Box
  • Updating Cross-References
  • Activity 2-2

TOPIC C: Add Bookmarks

  • Bookmarks
  • Adding Bookmarks
  • Bookmark Dialog Box
  • Bookmark Formatting Marks
  • Hidden Bookmarks
  • Activity 2-3

TOPIC D: Add Hyperlinks

  • Hyperlinks
  • Adding Hyperlinks
  • Insert Hyperlink Dialog Box
  • Options in the Link To Panel
  • Edit Hyperlink Dialog Box
  • Activity 2-4

TOPIC E: Insert Footnotes and Endnotes

  • Footnotes and Endnotes
  • Inserting Footnotes and Endnotes
  • The Footnote and Endnote Dialog Box
  • Navigating Using Reference Marks
  • ScreenTips for Footnotes and Endnotes
  • Activity 2-5

TOPIC F: Add Citations

  • Sources
  • The Source Manager Dialog Box
  • The Create Source Dialog Box
  • The Edit Source Dialog Box
  • Citations
  • Adding Citations
  • The Edit Citation Dialog Box
  • Citation and Bibliography Styles
  • Activity 2-6

TOPIC G: Insert a Bibliography

  • Bibliographies
  • Adding a Bibliography
  • Updating the Bibliography
  • Activity 2-7
  • Summary
  • Review Questions

Lesson 3: Simplifying and Managing Long Documents

TOPIC A: Insert Blank and Cover Pages

  • Inserting Blank Pages
  • Inserting Cover Pages
  • Activity 3-1

TOPIC B: Insert an Index

  • The Mark Index Entry Dialog Box
  • Index Entry Field Codes
  • The Index Dialog Box
  • The Open Index AutoMark File Dialog Box
  • The Concordance File
  • The Style Dialog Box
  • The Modify Style Dialog Box
  • Updating the Index
  • Activity 3-2

TOPIC C: Insert a Table of Contents

  • Table of Contents
  • The Table of Contents Dialog Box
  • The Add Text Option
  • The Mark Table of Contents Entry Dialog Box
  • Updating a Table of Contents
  • Activity 3-3

TOPIC D: Insert an Ancillary Table

  • Ancillary Tables
  • The Table of Figures Dialog Box
  • Table of Authorities
  • The Mark Citation Dialog Box
  • The Table of Authorities Dialog Box
  • Field Code for a Marked Citation
  • Activity 3-4

TOPIC E: Manage Outlines

  • Outline View
  • Outline Symbols
  • Outline View Tools
  • Creating an Outline
  • Promoting and Demoting Sections
  • Activity 3-5

TOPIC F: Create a Master Document

  • Master Documents
  • Benefits of Master Documents
  • Creating a Master Document
  • Creating Subdocuments
  • Master Document Group
  • Managing Subdocuments
  • Activity 3-6
  • Summary
  • Review Questions

Lesson 4: Securing a Document

TOPIC A: Suppress Information

  • Suppress Sensitive Information
  • Hidden Text
  • Remove Personal Information from a Document
  • The Document Inspector Dialog Box
  • Activity 4-1

TOPIC B: Set Editing Restrictions

  • The Restrict Editing Task Pane
  • Protected View
  • Mark as Final
  • Activity 4-2

TOPIC C: Add a Digital Signature to a Document

  • Digital Certificates
  • Digital Signatures
  • The Signature Line
  • Digitally Signing a Document
  • The Signatures Task Pane
  • Requested Signatures
  • Valid Signatures
  • Activity 4-3

TOPIC D: Restrict Document Access

  • Applying a Document Password
  • Changing the Document Password
  • Removing the Document Password
  • Activity 4-4
  • Summary
  • Review Questions

Lesson 5: Forms

TOPIC A: Create Forms

  • Forms
  • Plan a Form
  • The Controls Group
  • Form Controls
  • Design Mode
  • Legacy Tools
  • Form Field Options
  • Toggling Form Field Shading
  • Clearing Entered Data from Form Fields
  • Protecting a Form
  • Activity 5-1

TOPIC B: Manipulate Forms

  • Modifying a Control’s Title Tab
  • Adding Help Contents to Form Fields
  • Activity 5-2

TOPIC C: Form Data Conversion

  • Save Form Data as a Text File
  • How Data is Saved
  • Linking the Form to a Database
  • Modifying Tab Order
  • Activity 5-3
  • Summary
  • Review Questions

Lesson 6: Managing Document Versions

TOPIC A: Create a New Document Version

  • Microsoft SharePoint Server
  • Versioning
  • Versioning Settings
  • Major vs. Minor Versions
  • Accessing Documents Directly from a SharePoint Site
  • Begin Working with Document Versions
  • Activity 6-1

TOPIC B: Compare Document Versions

  • The Compare Feature
  • Compare Document Versions

TOPIC C: Merge Document Versions

  • The Combine Feature
  • Merge Multiple Versions of a Document
  • Summary

Entry requirements

Students must have basic literacy and numeracy skills.

Minimum education

Open entry. Previous schooling and academic achievements are not required for entry into this course.

Computer requirements

Students will need access to a computer and the internet. 

Minimum specifications for the computer are:

Windows:

  • Microsoft Windows XP, or later
  • Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome, Safari)

MAC/iOS

  • OSX/iOS 6 or later
  • Modern and up to date Browser (Firefox, Chrome, Safari)

All systems

  • Internet bandwidth of 1Mb or faster
  • Flash player or a browser with HTML5 video capabilities(Currently Internet Explorer 9, Firefox, Chrome, Safari)

Students will also need access the following applications:

Adobe Acrobat Reader

1.  Who are Courses For Success?

Courses For Success is a global course platform that started in 2008 with 5 courses, since then we have grown to over 10,000 online courses. As our courses are delivered online via the internet, we sell our courses worldwide.

Our courses span across many categories including Academic, Animal, Beauty, Business, Career, Counseling, Creative & Media, Health & Therapy, Hobbies & Trades, IT, Personal Development, Sports & Fitness.

Some of the companies we work with include Groupon, Living Social, CNN, Entrepreneur, Mashable, Reed UK, Stack Social and many more.

2.  Is there a refund/cancellation policy?

Yes, we have a 7-day money-back refund guarantee. Just send us an email to email/info)(coursesforsuccess.com with the subject Courses For Success Refund so we can accommodate your request.

3.  What is the FREE Personal Success Training Program?

The Personal Success Training Program was developed by Courses For Success to help our customers achieve success. Currently, we are offering this program for FREE with every course or bundle purchase this month. This is a limited time offer! We have received thousands of reviews for this program, please see: Personal Success Training Program Reviews

4.  Are there any requirements to study this course?

No, anyone who has an interest in learning more about this subject matter is encouraged to take our course. There are no entry requirements to take this course.

5.  Do I require to have finished high school to complete this course?

No, you do not require a High School Diploma or to have finished school to study this course, this course is open to anyone who would like to take this course.

6.  What if English is not my first language?

This course is provided in English, however, due to the digital nature of our training, you can take your time studying the material and make use of tools such as google translate and Grammarly.

7.  Is this course online or conducted in person?

All our courses are accessible online on any device. You may complete them at your own pace and at your own time.

8.  How do I receive my course?

After you have completed the payment, you will receive a confirmation email and tax receipt. You will also receive an email containing your course login details (username and password), as well as instructions on how to access and log in to your course via the internet with any device, please check your junk/spam folder in the event that you do not receive the email.

9.  When does this course start?

Providing you have internet access you can start this course whenever you like, just go to the login page and insert your username and password and you can access the online material.

10.  What is online learning like?

Online learning is easy, if not easier than a traditional academic situation. By studying an online course, the usual boundaries caused by location and time constraints are eliminated, meaning you are free to study where and when you want at your own pace. Of course, you will need to be able to self-manage your time and be organized, but with our help, you’ll soon find yourself settling into a comfortable rhythm of study.

11.  What computer skills do I need for my course?

You don't need to be a computer expert to succeed with our online training, but you should be comfortable typing, using the internet and be capable of using common software (such as Microsoft word).

12.  How long will you have access to the online course?

There is no time limit for completing this course, it can be studied in your own time at your own pace. Once you have purchased this course you will have unlimited lifetime access, meaning you can access this course whenever you want.

13.  How long will my course take?

Individual courses are designed to be completed within 6-8 hours.

If you choose a course bundle, simply multiply the above hours by the number of courses included in the bundle.
For example:

  • 2 course bundle is 2 x 6-8 hours = 12-16 hours
  • 3 course bundle is 3 x 6-8 hours = 18-24 hours
  • 5 course bundle is 5 x 6-8 hours = 30-40 hours
  • 10 course bundle is 10 x 6-8 hours = 60-80 hours
14.  Do I need to buy textbooks?

All the required material for your course is included in the online system, you do not need to buy anything else.

15.  Is the course interactive?

Yes, all our courses are interactive.

16.  Is there an assessment or exam?

Yes, you will be required to complete a multiple-choice test online at the end of your course, you can do this test as many times as you require.

17.  What type of certificate will I receive?

You will receive a Certificate of Completion that is applicable worldwide, which demonstrates your commitment to learning new skills. You can share the certificate with your friends, relatives, co-workers and employers. Also, include it in your resume/CV, professional social media profiles and job applications.

Wendy Sue Hunt - 5 STAR REVIEW
"If you are considering taking any “Courses for Success”, I would highly recommend it. I have always been a firm believer it’s important to always sharpen your skills. You are never too old to learn more. I found the courses very helpful, interesting and easy to understand.
The term “Courses for Success” helped me in my current position to succeed. After completing the courses, I gave my manager the completion certificates. Recently I received a promotion too."
Valencia Marie Aviles - 5 STAR REVIEW
"I had a very good experience with my course. It has helped me to get multiple jobs and prepared me for almost everything I would need to know. The course was very informative and easy to understand and broken up perfectly to be done in a short amount of time while still learning a good amount! I would recommend Courses for Success to anyone trying to get abs certifications for job advancements, it is well worth it!"
ELENA GRIFFIN - 5 STAR REVIEW
"I have absolutely enjoyed the materials from Courses for Success. The materials are easy to understand which makes learning enjoyable. Courses for Success have great topics of interest which make you come back for more.
Thank you Courses for Success for being part of my learning journey and making education affordable!"

Our completion certificates are very valuable and will help you progress in your work environment and show employers how committed you are to learn new skills, you might even get a promotion.

18.  Will this course be credited by universities?

No, it is not equivalent to a college or university credit.

19.  Am I guaranteed to get a job with this certificate?

This course will give you the skills you need to help you obtain employment, but it’s up to you if you get the job or not.

20.  How will this course assist me with my career?

Studying and completing this course will show employers that you have the knowledge in this field, additionally you will gain more confidence in this area of expertise.

21.  How long is the certificate valid for?

The Certificates are valid for life and do not need renewing. 

22.  Can I take more than one course at a time?

Courses are studied online at your own pace and you are free to study as many or as few courses as you wish, we also offer online course bundles that allow you to save on additional courses so that you may get all the topics related to your training goals in one go.

23.  What are the Payment Methods available? Is there a payment plan?

We accept payments via PayPal, Credit Card, Bank Transfer and Amazon Pay for the USA. For payment plans, we offer Sezzle for USA & Canada, Afterpay for Australia & New Zealand. *For faster transaction Credit Card payments are preferred. Please purchase online via our website course product page or contact us at email/info)(coursesforsuccess.com, to pay via bank transfer.

24.  Can I purchase for multiple people?

Yes, you can do this by purchasing individually via website or send us a request via email at email/info)(coursesforsuccess.com

25.  Can I request for an invoice before purchase?

Yes, you can request for an invoice via email at email/info)(coursesforsuccess.com

26.  Purchase for a gift?

Yes, you can purchase this course as a gift, simply send an email to email/info)(coursesforsuccess.com, with the course details and we can accommodate this.

27.  Can I create my own course bundle?

Yes, you can customize your own bundle. Please send us the complete list with the exact course link of the courses you'd like to bundle up via email email/info)(coursesforsuccess.com and we will create them for you. *Each course access, time of completion and certification varies depending on the course type.

28.  How will I contact Courses For Success if I have any questions?

You can contact our support team, at any time through live chat on our website, or email at email/info)(coursesforsuccess.com, or by calling one of our phone numbers depending on which country you are in.  

We provide a 7 Day Money Back Refund on all Courses

Special Offer

 

Receive The Personal Success Training Program FREE, When You Purchase This Course - Limited Time Remaining!  (Value £300)

 

The Personal Success Training Program Helps You Stay Focused To Achieve Your Goals!
Benefits:
  • How to layout a Success Plan.
  • Get where you want to be in life.
  • How to unclutter your mind to succeed.
  • Achieve your dreams using your imagination.
  • How to have faith in yourself.
Features:
  • 12 month online access,  24/7 anywhere.
  • Complement your individual course purchase.
  • Thousands of positive reviews.
  • Limited Time Offer - Ends Soon.
 

Training 2 Or More People?


Empower your business with access to 500+ job & soft skills online training courses.

SUCCESS PRO - For Business

Course Summary

Course ID: CFS02MSW1610CB
Delivery Mode: Online
Access: Lifetime
Tutor Support: Yes
Time: Study at your own pace
Duration: 60-80 Hours for total bundle
Assessments: Yes
Qualification: Certificate

Learn More With Course Bundles

Popular Courses and Bundles

Get a FREE Career Planner