LearnKey Training

Office 2016 Series

Office 2016 Series

Back to Product Page


Office 2016 Series

0 Sessions -
52 Hours of Interactive Training

The Office 2016 certification training series from LearnKey is packed with information covering the new features of Office 2016. This series is ideal for professionals who are looking to improve their proficiency with Office or for any individuals who are looking to enhance their skill set with the MOS certifications offered by Microsoft. Create your competitive edge with the knowledge of Microsoft Office 2016. This series includes LearnKey's Access 2016, Excel 2016, Outlook 2016, PowerPoint 2016, and Word 2016 courses.

Benefits
  • Become proficient with the 2016 versions of Access, Excel, Outlook, PowerPoint, and Word
  • Test your understanding of Access, Excel, Outlook, PowerPoint, and Word with hundreds of practice test questions
  • View your online courseware anytime, anywhere

Access 2016 (77-730) Course
Session 1

Section A: Introduction

  • Course Opening
  • How to Study for This Exam

Section B: Introduction to Access

  • Database Definition
  • Tour of Access

Section C: Create and Modify Databases

  • Create a Blank Database
  • Create a Database from a Template
  • Import Objects from Access
  • Import Objects from Excel
  • Delete Database Objects

Section D: Rules of Databases

  • Relational Database Definition
  • Flat Database Problem
  • Rules of Relational Table Design
  • Planning a Database

Section E: Manage Relationships and Keys

  • Create and Modify Relationships
  • Set Primary Keys
  • Referential Integrity and Foreign Keys
  • View Relationships

Section F: Navigate Through a Database

  • Navigate Specific Records
  • Create a Navigation Form
  • Modify a Navigation Form
  • Set a Form as the Startup Option
  • Set Navigation Pane Display Options
  • Change Object Views

Section G: Protect and Maintain Databases

  • Compact and Repair a Database
  • Back Up a Database
  • Split a Database
  • Encrypt a Database
  • Recover Data from a Backup

Section H: Print and Export Data

  • Print Reports
  • Print Records
  • Save a Database as a Template
  • Export Data

Section I: Session 1 Recap

  • Domain 1 Test Tips

Access 2016 (77-730) Course
Session 2

Section A: Create Tables

  • Build Tables
  • Import Data into Tables
  • Create External Links to Tables
  • Import Tables from Other Databases
  • Use Application Parts to Create Tables

Section B: Manage Tables

  • Hide Fields in Tables
  • Add Total Rows
  • Add Table Descriptions
  • Rename Tables

Section C: Manage Records in Tables

  • Update Records
  • Add and Delete Records
  • Append Records from External Data
  • Find and Replace Data
  • Sort Records
  • Filter Records

Section D: Create and Modify Fields

  • Add Fields to Tables
  • Add Field Validation Rules
  • Change Fields Captions
  • Change Field Sizes
  • Change Field Data Types
  • Change Field Formatting
  • Configure Fields to Auto-Increment
  • Set Default Values
  • Use Input Masks
  • Delete Fields

Section E: Session 2 Recap

  • Domain 2 Test Tips

Access 2016 (77-730) Course
Session 3

Section A: Create a Query

  • Create a Select Query
  • Add Criteria
  • Create a Crosstab Query
  • Create a Parameter Query
  • Create an Action Query
  • Create a Multi-Table Query
  • Save a Query

Section B: Modify a Query

  • Rename a Query
  • Add Fields
  • Remove Fields, Hide Fields
  • Sort Data Within Queries
  • Format Fields Within Queries

Section C: Calculated Fields and Grouping

  • Add Calculated Fields
  • Set Filtering Criteria
  • Inner and Outer Joins
  • Group and Summarize Data
  • Use Comparison, Arithmetic, and Logical

Access 2016 (77-730) Course
Session 4

Section A: Build Forms

  • Create a Form
  • Use Application Parts to Create a Form
  • Save a Form

Section B: Configure Form Controls

  • Move Form Controls
  • Add Form Controls
  • Modify Data Sources
  • Remove Form Controls
  • Set Form Control Properties
  • Manage Labels
  • Add Subforms

Section C: Format a Form

  • Modify Tab Order
  • Configure Print Settings
  • Sort Records by Form Field
  • Apply a Theme
  • Control Form Positioning
  • Insert Backgrounds
  • Insert Headers and Footers
  • Insert Images

Section D: Session 4 Recap

  • Domain 4 Test Tips

Access 2016 (77-730) Course
Session 5

Section A: Create Reports

  • Reports Based on a Queries and Tables
  • Create a Report in Design View
  • Create a Report by Using a Wizard

Section B: Configure Report Controls

  • Group and Sort Fields
  • Modify Data Sources
  • Add Report Controls
  • Add and Modify Labels

Section C: Format a Report

  • Split Report into Multiple Columns
  • Add Calculated Fields
  • Control Report Positioning
  • Format Report Elements
  • Change Report Orientation
  • Insert Header and Footer Information
  • Insert Logo and Title
  • Insert Images
  • Apply a Theme

Section D: Session 5 Recap

  • Domain 5 Test Tips
  • Conclusion

Excel 2016 (77-727)
Session 1

Section A: Introduction to Excel 2016

  • About This Course

Section B: Create Worksheets and Workbooks

  • Tour of Excel
  • Create a Blank Workbook
  • Create a Workbook Using Templates
  • Add Data to a Worksheet
  • Import Data
  • Add a Worksheet
  • Copy a Worksheet
  • Move a Worksheet

Section C: Navigate in Worksheets and Workbooks

  • Search for Data
  • Navigate a Workbook
  • Insert and Remove Hyperlinks

Section D: Format Worksheets and Workbooks

  • Change Worksheet Tab Color
  • Rename a Worksheet
  • Change Worksheet Order
  • Modify Page Setup
  • Insert and Delete Columns or Rows
  • Change Workbook Themes
  • Adjust Row Height and Column Width
  • Insert Headers and Footers

Section E: Customize Options and Views

  • Hide and Unhide Worksheets
  • Hide and Unhide Columns and Rows
  • Customize the Quick Access Toolbar
  • Change Workbook Views
  • Change Window Views
  • Modify Document Properties
  • Change Magnification
  • Display Formulas

Section F: Prepare Files for Distribution

  • Set a Print Area
  • Save Workbooks in Other Formats
  • Print All or Part of a Workbook
  • Set Print Scaling
  • Display Repeating Row and Column Titles
  • Inspect for Hidden Properties
  • Inspect for Accessibility Issues
  • Inspect for Compatibility Issues

Section G: Domain 1 Recap

  • Domain 1 Test Tips

Excel 2016 (77-727)
Session 2

Section A: Manage Data

  • Insert Data in Cells and Ranges
  • Replace Data
  • Cut and Paste Data
  • Copy and Paste Data
  • Paste Data with Special Paste Options
  • Using AutoFill to Fill Cells
  • Insert and Delete Cells

Section B: Format Cells and Ranges

  • Merge Cells
  • Modify Cell Alignment and Indentation
  • Use Format Painter to Format Cells
  • Wrap Text Within Cells
  • Apply Number Formats
  • Apply Cell Formats
  • Apply Cell Styles

Section C: Summarize and Organize Data

  • Insert Sparklines
  • Outline Data
  • Create Subtotals
  • Apply Conditional Formatting

Section D: Domain 2 Recap

  • Domain 2 Test Tips

Excel 2016 (77-727)
Session 3

Section A: Create Tables

  • Create and Manage Tables
  • Create an Excel Table from a Cell Range
  • Convert a Table to a Cell Range
  • Add or Remove Table Rows and Columns

Section B: Manage Table Styles and Options

  • Apply Styles to Tables
  • Configure Table Style Options
  • Insert Total Rows

Section C: Filter and Sort a Table

  • Filter Records
  • Sort Data by Multiple Columns
  • Sort Data by Custom Lists
  • Change Sort Order
  • Remove Duplicate Records

Section D: Domain 3 Recap

  • Domain 3 Test Tips

Excel 2016 (77-727)
Session 4

Section A: Calculations with Formulas and Functions

  • Use Basic Formulas and Functions
  • Use Basic Formulas
  • Use Absolute and Mixed References
  • Using Formulas Across Worksheets
  • Calculate with the SUM Function
  • Use the MIN and MAX Functions
  • Use the COUNT Functions
  • Use the AVERAGE Functions
  • Formula and Function Tips

Section B: Use Conditional Functions

  • Use the IF Function
  • Use the SUMIF Function
  • Use the AVERAGEIF Function
  • Use the COUNTIF Function

Section C: Use Text Functions

  • Use the LEFT Function
  • Use the MID Function
  • Use the RIGHT Function
  • Use the UPPER and LOWER Functions
  • Use the PROPER Function
  • Use the CONCAT Function

Section D: Domain 4 Recap

  • Domain 4 Test Tips

Excel 2016 (77-727)
Session 5

Section A: Create Charts and Objects

  • Create Charts
  • Create a New Chart
  • Add Additional Data Series
  • Switch Orientation of Source Data
  • Use Quick Analysis to Analyze Data

Section B: Format Charts

  • Resize Charts
  • Add and Modify Chart Elements
  • Data Labels and Legends
  • Gridlines
  • Apply Chart Layouts and Styles
  • Change Chart Type
  • Create Secondary Axis
  • Move Charts to a Chart Sheet

Section C: Insert and Format Objects

  • Insert Text Boxes and Shapes
  • Insert and Modify Images
  • Add Alternative Text to Objects

Section D: Domain 5 Recap

  • Domain 5 Test Tips

Section E: Test Taking Tips

  • Overall Test Tips

Section F: Conclusion

  • Course Ending

Outlook 2016 (77-731) Course
Session 1

Section A: Introduction

  • Course Opening
  • How to Study for the Exam
  • Tour of Outlook

Section B: Customize Settings

  • Customize Reply Messages
  • Change Outgoing Message Formats
  • Customize the Navigation Pane
  • Configure Views
  • Add and Manage Multiple Accounts

Section C: Print and Save Information

  • Print Messages and Calendar Information
  • Print Contact and Task Information
  • Save and Preview Attachments
  • Save Messages in Other Formats
  • Export Messages

Section D: Search Operations

  • Create Search Folders
  • Item Searches
  • Advanced Searches
  • Folder Searches

Section E: Session 1 Recap

  • Domain 1 Test Tips

Outlook 2016 (77-731) Course
Session 2

Section A: Configure Mail Settings

  • Set Fonts for New Messages and Replies
  • Create, Assign and Modify Signatures
  • Create Rules
  • Manage Rules, Create Automatic Replies
  • Use Quick Parts to Create Messages
  • Configure Junk Email Settings
  • Configure Clutter Settings

Section B: Create Messages

  • Compose a Message
  • Add or Remove Attachments
  • Add Attachment as a Link
  • Add Cc and Bcc to Messages
  • Add Tracking and Voting Options
  • Forward, Reply to Messages
  • Request a Receipt
  • Redirect Replies
  • Flag Outgoing Messages
  • Recall a Message

Section C: Format Messages

  • Format Text
  • Insert Hyperlinks
  • Apply Themes and Styles
  • Insert Images
  • Add a Signature to Specific Messages

Section D: Organize and Manage Messages

  • Sort Messages
  • Move Messages to Folders
  • Add New Local Folders
  • Apply Categories
  • Clean Up Messages
  • Mark Messages Read or Unread
  • Flag Received Messages
  • Ignore Messages
  • Sort Messages by Conversation
  • Delete Messages
  • Automation Through Quick Steps
  • Configure AutoArchive
  • Delegate Access

Section E: Session 2 Recap

  • Domain 2 Test Tips

Outlook 2016 (77-731) Course
Session 3

Section A: Create and Manage Calendars

  • Create and Add Calendars
  • Adjust Viewing Details
  • Modify Calendar Time Zones
  • Delete Calendars, Set Work Times
  • Manage Multiple Calendars
  • Manage Calendar Groups
  • Display Multiple Calendars
  • Share Calendars

Section B: Appointments, Meetings, and Events

  • Create Calendar Items
  • Create Recurring Calendar Items
  • Cancel Items, Create Items from Messages
  • Set Calendar Item Times
  • Schedule Assistant
  • Set Free or Busy Status
  • Schedule Resources and Locations

Section C: Organize and Manage Calendar Items

  • Set Calendar Item Importance
  • Forward Calendar Items
  • Configure Reminders
  • Add Participants
  • Respond to Invitations
  • Update Calendar Items
  • Update Recurring Calendar Items
  • Share Meeting Notes
  • Categorize Calendar Items

Section D: Create and Manage Notes and Tasks

  • Create and Manage Tasks
  • Create and Organize Notes

Section E: Session 3 Recap

  • Domain 3 Test Tips

Outlook 2016 (77-731) Course
Session 4

Section A: Create and Manage Contacts

  • Create New Contacts
  • Import Contacts
  • Delete and Edit Contacts
  • Add Contact Details
  • Share Contacts
  • Create and Manage Address Books

Section B: Create and Manage Contact Groups

  • Create New Contact Groups
  • Add Contacts to Existing Groups
  • Add Notes to a Contact Group
  • Update Contacts within Groups
  • Delete Contact Group Members and Groups

Section C: Session 4 and Course Recap

  • Domain 4 Test Tips
  • Overall Test Tips and Course Conclusion

PowerPoint 2016 (77-729)
Session 1

Section A: Introduction to PowerPoint 2016

  • Course Opener
  • How to Take This Course
  • Tour of PowerPoint
  • Backstage View

Section B: Create a Presentation

  • Create a Blank Presentation
  • Create a Presentation Using Templates
  • Online Templates
  • Import Word Document Outlines

Section C: Insert and Format Slides

  • Insert Specific Slide Layouts
  • Duplicate Existing Slides
  • Hide and Unhide Slides
  • Delete Slides
  • Apply a Different Slide Layout
  • Modify Individual Slide Backgrounds
  • Insert Headers and Footers

Section D: Modify Slides, Handouts, and Notes

  • Change Slide Master Theme or Background
  • Effects
  • Modify Slide Master Content
  • Create a Slide Layout
  • Modify a Slide Layout
  • Modify a Handout Master
  • Modify the Notes Master

Section E: Order and Group Slides

  • Create Sections
  • Modify Slide Order
  • Rename Sections

Section F: Change Presentation Options and Views

  • Change Slide Size
  • Change Views of a Presentation
  • Set File Properties

Section G: Configure a Presentation for Print

  • Print All or Part of a Presentation
  • Print Notes Pages, Handouts
  • Print in Color or Black and White

Section H: Configure and Present a Slide Show

  • Create Custom Slide Shows
  • Configure Slide Show Options
  • Rehearse Slide Show Timing
  • Present a Slide Show in Presenter View

Section I: Domain 1 Recap

  • Domain 1 Test Tips

PowerPoint 2016 (77-729)
Session 2

Section A: Insert and Format Text

  • Insert Text on a Slide
  • Apply Formatting and Styles to Text
  • Apply WordArt Styles to Text
  • Format Text in Multiple Columns
  • Create Bulleted and Numbered Lists
  • Insert Hyperlinks

Section B: Insert and Format Shapes and Text Boxes

  • Insert or Replace Shapes
  • Insert Text Boxes
  • Resize Shapes and Text Boxes
  • Format Shapes and Text Boxes
  • Apply Styles to Shapes and Text Boxes

Section C: Insert and Format Images

  • Insert Images
  • Resize and Crop Images
  • Apply Styles and Effects

Section D: Order and Group Objects

  • Order Objects
  • Align Objects
  • Group Objects
  • Display Alignment Tools

Section E: Domain 2 Recap

  • Domain 2 Test Tips

PowerPoint 2016 (77-729)
Session 3

Section A: Insert and Format Tables

  • Create a Table
  • Insert and Delete Table Rows and Columns
  • Apply Table Styles
  • Import a Table

Section B: Insert and Format Charts

  • Create a Chart
  • Import a Chart
  • Change the Chart Type
  • Add a Chart Legend
  • Work with Chart Elements
  • Change the Chart Style

Section C: Insert and Format SmartArt Graphics

  • Create a SmartArt Graphic
  • Convert Lists to SmartArt Graphics
  • Add Shapes to SmartArt Graphics
  • Reorder Shapes in SmartArt Graphics
  • Change the Color of SmartArt Graphics

Section D: Insert and Manage Media

  • Insert Audio and Video Clips
  • Screen Recording
  • Configure Media Playback Options
  • Adjust Media Window Size
  • Set the Video Start and Stop Time
  • Set Media Timing Options

Section E: Domain 3 Recap

  • Domain 3 Test Tips

PowerPoint 2016 (77-729)
Session 4

Section A: Apply Transitions and Animations

  • Apply Slide Transitions
  • Insert Slide Transitions
  • Set Transition Effect Options

Section B: Animate Slide Content

  • Apply Animations to Objects
  • Apply Animations to Text
  • Set Animation Effect Options
  • Set Animation Paths

Section C: Set Timing for Transitions, Animations

  • Set Transition Effect Duration
  • Configure Transition Start and Finish
  • Reorder Animations on a Slide

Section D: Domain 4 Recap

  • Domain 4 Test Tips

PowerPoint 2016 (77-729)
Session 5

Section A: Manage Multiple Presentations

  • Merge Content from Presentations
  • Insert Slides from Another Presentation
  • Combine Presentations
  • Insert Comments
  • Review Comments

Section B: Finalize Presentations

  • Protect a Presentation
  • Inspect a Presentation
  • Proof a Presentation
  • Preserve Presentation Content
  • Export Presentations to Other Formats

Section C: Domain 5 Recap

  • Domain 5 Test Tips

Section D: Test-Taking Tips

  • Overall Test Tips

Word 2016 (77-725)
Session 1

Section A: Introduction to Word 2016

  • Introduction

Section B: Getting Started

  • How to Take This Course
  • Tour of Office
  • Tour of Word

Section C: Create Documents

  • Create a Blank Document
  • Create a Document from a Template
  • Open a PDF in Word
  • Insert Text from Other Sources

Section D: Navigate Through Documents

  • Search for Text
  • Insert Hyperlinks
  • Create Bookmarks
  • The Go To Feature

Section E: Format Documents

  • Modify Page Setup
  • Apply Document Themes
  • Apply Document Style Sets
  • Insert Headers and Footers
  • Insert Page Numbers
  • Format Page Background Elements
  • Watermarks

Section F: Customize Document Views and Options

  • Change Document Views
  • Customize Through Zoom Settings
  • Customize the Quick Access Toolbar
  • Split Windows
  • Add Document Properties
  • Show and Hide Formatting Symbols

Section G: Print and Save Documents

  • Modify Print Settings
  • Save Documents in Different Formats
  • Print Documents
  • Check for Document Issues
  • Inspect for Accessibility Issues
  • Inspect for Compatibility Issues

Section H: Domain 1 Recap

  • Domain 1 Test Tips

Word 2016 (77-725)
Session 2

Section A: Insert Text and Paragraphs

  • Find and Replace Text
  • Cut and Paste Text
  • Copy and Paste Text
  • Use AutoCorrect to Replace Text
  • Insert Symbols
  • Insert Special Characters
  • Use Undo and Redo

Section B: Format Text and Paragraphs

  • Apply Font Formatting
  • Use the Format Painter
  • Set Line and Paragraph Spacing
  • Set Line and Paragraph Indentation
  • Set Tabs
  • Clear Formatting
  • Use the Text Highlighter
  • Apply Built-In Styles
  • Change Text to WordArt

Section C: Order and Group Text and Paragraphs

  • Format Text in Multiple Columns
  • Insert Page Breaks
  • Insert Section Breaks
  • Insert Column Breaks
  • Set Page Setup Options in a Section

Section D: Domain 2 Recap

  • Domain 2 Test Tips

Word 2016 (77-725)
Session 3

Section A: Create Tables and Lists

  • Create a Table
  • Convert Text to Tables
  • Convert Tables to Text
  • Create a Table with Specific Options
  • Apply Table Styles
  • Set Table Style Options

Section B: Modify a Table

  • Sort Table Data
  • Cell Margins and Spacing
  • Merge and Split Cells
  • Resize Tables
  • Resize Rows and Columns
  • Split Tables
  • Configure a Repeating Row Header

Section C: Create and Modify a List

  • Create a Numbered List
  • Create a Bulleted List
  • Change Number Formats
  • Change Bullet Characters
  • Customize Bullet Characters
  • Customize Number Formats
  • Increase or Decrease List Levels
  • Control List Numbering
  • Set Starting Number Value

Section D: Domain 3 Recap

  • Domain 3 Test Tips

Word 2016 (77-725)
Session 4

Section A: Create and Manage References

  • Create and Manage Reference Markers
  • Insert Footnotes
  • Insert Endnotes
  • Modify Footnote Properties
  • Modify Endnote Properties
  • Create Bibliography Citation Sources
  • Modify Bibliography Citation Sources
  • Insert Citations for Bibliographies
  • Insert Figure Captions
  • Insert Table Captions
  • Modify Caption Properties

Section B: Create and Manage Simple References

  • Insert a Table of Contents
  • Update a Table of Contents
  • Insert a Cover Page

Section C: Proofing the Document

  • Check Spelling and Grammar

Section D: Domain 4 Recap

  • Domain 4 Test Tips

Word 2016 (77-725)
Session 5

Section A: Insert and Format Graphic Elements

  • Insert Graphic Elements
  • Insert Shapes
  • Insert Pictures
  • Insert Screenshots
  • Insert Screen Clippings
  • Insert Text Boxes

Section B: Format Graphic Elements

  • Apply Artistic Effects
  • Apply Picture Effects
  • Remove Picture Backgrounds
  • Format Objects
  • Apply Picture Styles
  • Wrap Text Around Objects
  • Position Objects
  • Add Alternative Text to Objects

Section C: Insert and Format SmartArt Graphics

  • Create a SmartArt Graphic
  • Format a SmartArt Graphic
  • Modify SmartArt Graphic Content

Section D: Domain 5 Recap

  • Domain 5 Test Tips

Section E: Test Taking Tips

  • Overall Test Tips