Ready to Checkout?

shopping-cart

Quality Training Since 2001

Microsoft Office 2016 Tutorial Course

Microsoft Office 2016 Tutorial Includes: Video Lessons, Instruction Manuals, Exam & Certificate of Completion.

Microsoft Office 2016 tutorial: Free Demo button.Microsoft Office 2016 tutorial: Buy Now button.Microsoft Office 2016 tutorial: Sample Lessons button.

Microsoft Office 2016 tutorial: An image of our Microsoft Office 2016 tutorial.

Course Title: Mastering Microsoft Office Made Easy
Courses Included: Access, Excel, OneNote, Outlook, PowerPoint, Publisher & Word
Versions Covered: 2016 & 2013
Hours of Content: 42
Video Lessons: 809
Manuals: 15 (Introductory, Intermediate & Advanced)
Download/DVD-ROM: Standard: $99 | CPE: $129 | Buy
Online: Access to ALL courses. One low price. | Info
Multi-User: Network Installation | Info
CPE Credits: CPAs (57) | Verify


Course Description

Learn Microsoft Office 2016 with this comprehensive Microsoft Office 2016 tutorial from TeachUcomp, Inc. Mastering Microsoft Office Made Easy features 809 video lessons with over 42 hours of introductory through advanced instruction. You get our complete courses in Access, Excel, OneNote, Outlook, PowerPoint, Publisher and Word. Watch, listen and learn as your expert instructors guide you through each lesson step-by-step. During this media-rich learning experience, you will see each function performed just as if your instructor were there with you. Reinforce your learning with the text of our fifteen printable classroom instruction manuals (Introductory, Intermediate and Advanced), additional images and practice exercises.  This complete Microsoft Office 2016 tutorial covers the same curriculum as our classroom training and was designed to provide a solid foundation in Office.

Whether you are completely new to Microsoft Office or upgrading from an older version, this Microsoft Office 2016 tutorial will empower you with the knowledge and skills necessary to be a proficient user. Our Microsoft Office 2016 tutorial is based on years of classroom training experience and teaching techniques. This lets us develop a Microsoft Office 2016 tutorial that is easy to use.  You can also customize it to meet your personal learning needs.  Simply launch the Microsoft Office 2016 tutorial interface, click to start a video lesson or open one of the manuals, and you’re on your way to mastering Office.

 

Course Syllabus & Sample Lessons

Select any of the video lessons markedMicrosoft Office 2016 tutorial: Free button.to view them in a new window. 

To view samples of the instruction manuals in PDF, click here: Introductory Access | Intermediate Access | Advanced Access

CHAPTER 1-

Microsoft Office 2016 Tutorial: Getting Acquainted with Access

Lesson 1.1- Creating a New Database Microsoft Office 2016 tutorial: Free button.
Lesson 1.2- Overview of a Database
Lesson 1.3- The Access Interface
Lesson 1.4- Touch Mode Microsoft Office 2016 tutorial: Free button.
Lesson 1.5- Viewing Database Objects in the Navigation Bar
Lesson 1.6- Opening and Closing Databases

CHAPTER 2-

Microsoft Office 2016 Tutorial: Creating Relational Database Tables

Lesson 2.1- The “Flat File” Method of Data Storage
Lesson 2.2- The Relational Model of Data Storage
Lesson 2.3- Tips for Creating a Relational Database
Lesson 2.4- Creating Relational Database Tables Microsoft Office 2016 tutorial: Free button.
Lesson 2.5- Assigning a Primary Key to a Table Microsoft Office 2016 tutorial: Free button.

CHAPTER 3-

Microsoft Office 2016 Tutorial: Using Tables

Lesson 3.1- Using Datasheet View
Lesson 3.2- Navigating in Datasheet View
Lesson 3.3- Adding Records in Database View
Lesson 3.4- Editing and Deleting Records in Datasheet View
Lesson 3.5- Inserting New Fields
Lesson 3.6- Renaming Fields
Lesson 3.7- Deleting Fields

CHAPTER 4-

Microsoft Office 2016 Tutorial: Field Properties

Lesson 4.1- Setting Field Properties
Lesson 4.2- The ‘Field Size’ Property
Lesson 4.3- The ‘Format’ Property for Date/Time Fields
Lesson 4.4- The ‘Format’ Property for Logical Fields
Lesson 4.5- Setting Default Values for Fields
Lesson 4.6- Setting Input Masks
Lesson 4.7- Setting Up Validation Rules and Responses
Lesson 4.8- Requiring Field Input
Lesson 4.9- Allowing Zero Length Entries

CHAPTER 5-

Microsoft Office 2016 Tutorial: Joining Tables in a Database

Lesson 5.1- The Relationships Window
Lesson 5.2- Enforcing Referential Integrity
Lesson 5.3- Creating Lookup Fields

CHAPTER 6-

Microsoft Office 2016 Tutorial: Indexing Tables

Lesson 6.1- Indexes
Lesson 6.2- Creating Indexes
Lesson 6.3- Deleting Indexes

CHAPTER 7-

Microsoft Office 2016 Tutorial: Queries

Lesson 7.1- Using the Simple Query Wizard
Lesson 7.2- Designing Queries
Lesson 7.3- Joining Tables in a Query
Lesson 7.4- Adding Criteria to the QBE Grid
Lesson 7.5- Running A Query
Lesson 7.6- How is Using the QBE Grid Writing SQL Code?
Lesson 7.7- Sorting Query Results
Lesson 7.8- Hiding Fields in a Query
Lesson 7.9- Using Comparison Operators
Lesson 7.10- Using ‘AND’ and ‘OR’ Conditions

CHAPTER 8-

Microsoft Office 2016 Tutorial: Advanced Queries

Lesson 8.1- Using the ‘BETWEEN…AND’ Condition
Lesson 8.2- Using Wildcard Characters in Criteria
Lesson 8.3- Creating a Calculated Field
Lesson 8.4- Creating ‘Top Value’ Queries
Lesson 8.5- Function Queries
Lesson 8.6- Parameter Queries

CHAPTER 9-

Microsoft Office 2016 Tutorial: Advanced Query Types

Lesson 9.1- Make-Table Queries
Lesson 9.2- Update Queries
Lesson 9.3- Append Queries
Lesson 9.4- Delete Queries
Lesson 9.5- Crosstab Queries
Lesson 9.6- The ‘Find Duplicates’ Query
Lesson 9.7- The ‘Find Unmatched’ Query

CHAPTER 10-

Microsoft Office 2016 Tutorial: Creating Forms

Lesson 10.1- Forms Overview
Lesson 10.2- The Form Wizard
Lesson 10.3- Creating AutoForms
Lesson 10.4- Using Forms
Lesson 10.5- Form and Report Layout View
Lesson 10.6- Form and Report Design View
Lesson 10.7- Viewing the Ruler and Gridlines
Lesson 10.8- The ‘Snap to Grid’ Feature
Lesson 10.9- Creating a Form in Design View

CHAPTER 11-

Microsoft Office 2016 Tutorial: Form & Report Controls

Lesson 11.1- Selecting Controls
Lesson 11.2- Deleting Controls
Lesson 11.3- Moving and Resizing Controls
Lesson 11.4- Sizing Controls ‘To Fit’
Lesson 11.5- ‘Nudging’ Controls
Lesson 11.6- Aligning, Spacing and Sizing Controls
Lesson 11.7- Formatting Controls
Lesson 11.8- Viewing Control Properties

CHAPTER 12-

Microsoft Office 2016 Tutorial: Using Controls

Lesson 12.1- The Controls Group
Lesson 12.2- Adding Label Controls
Lesson 12.3- Adding Logos and Image Controls
Lesson 12.4- Adding Line and Rectangle Controls
Lesson 12.5- Adding Combo Box Controls
Lesson 12.6- Adding List Box Controls
Lesson 12.7- Setting Tab Order

CHAPTER 13-

Microsoft Office 2016 Tutorial: Subforms

Lesson 13.1- Creating Subforms
Lesson 13.2- Using the Subform/Subreport Control

CHAPTER 14-

Microsoft Office 2016 Tutorial: Reports

Lesson 14.1- Using the Report Wizard
Lesson 14.2- Using Basic Reports
Lesson 14.3- Creating a Report in Design View
Lesson 14.4- Sorting and Grouping Data in Reports
Lesson 14.5- Creating Calculated Fields

CHAPTER 15-

Microsoft Office 2016 Tutorial: Subreports

Lesson 15.1- Creating Subreports

CHAPTER 16-

Microsoft Office 2016 Tutorial: Charting Data

Lesson 16.1- Using Charts

CHAPTER 17-

Microsoft Office 2016 Tutorial: Macros

Lesson 17.1- Creating a Standalone Macro
Lesson 17.2- Assigning Macros to a Command Button
Lesson 17.3- Using Program Flow with Macros
Lesson 17.4- Creating Autoexec Macros
Lesson 17.5- Creating Data Macros
Lesson 17.6- Editing Named Data Macros
Lesson 17.7- Renaming and Deleting Named Data Macros

CHAPTER 18-

Microsoft Office 2016 Tutorial: Switchboard and Navigation Forms

Lesson 18.1- Creating a Switchboard Form
Lesson 18.2- Creating a Navigation Form
Lesson 18.3- Controlling Startup Behavior

CHAPTER 19-

Microsoft Office 2016 Tutorial: Advanced Features

Lesson 19.1- Getting External Data
Lesson 19.2- Exporting Data
Lesson 19.3- Setting a Database Password

CHAPTER 20-

Microsoft Office 2016 Tutorial: Advanced Features

Lesson 20.1- Using Access Help
Lesson 20.2- The Tell Me Bar- 2016 Only


Excel Course Syllabus & Sample Lessons

Select any of the video lessons markedMicrosoft Office 2016 tutorial: Free button.to view them in a new window.

To view samples of the instruction manuals in PDF, click here: Introductory Excel | Intermediate Excel | Advanced Excel

CHAPTER 1-

Microsoft Office 2016 Tutorial: Getting Acquainted with Excel

Lesson 1.1- About Excel Microsoft Office 2016 tutorial: Free button.
Lesson 1.2- The Excel Environment Microsoft Office 2016 tutorial: Free button.
Lesson 1.3- The Title Bar
Lesson 1.4- The Ribbon
Lesson 1.5- The “File” Tab and Backstage View
Lesson 1.6- Scroll Bars
Lesson 1.7- The Quick Access Toolbar
Lesson 1.8- Touch Mode
Lesson 1.9- The Formula Bar
Lesson 1.10- The Workbook Window
Lesson 1.11- The Status Bar
Lesson 1.12- The Workbook View Buttons
Lesson 1.13- The Zoom Slider
Lesson 1.14- The Mini Toolbar
Lesson 1.15- Keyboard Shortcuts

CHAPTER 2-

Microsoft Office 2016 Tutorial: File Management

Lesson 2.1- Creating New Workbooks Microsoft Office 2016 tutorial: Free button.
Lesson 2.2- Saving Workbooks
Lesson 2.3- Closing Workbooks
Lesson 2.4- Opening Workbooks Microsoft Office 2016 tutorial: Free button.
Lesson 2.5- Recovering Unsaved Workbooks
Lesson 2.6- Opening a Workbook in a New Window
Lesson 2.7- Arranging Open Workbook Windows
Lesson 2.8- Freeze Panes
Lesson 2.9- Split Panes
Lesson 2.10- Hiding and Unhiding Workbook Windows
Lesson 2.11- Comparing Open Workbooks
Lesson 2.12- Switching Open Workbooks
Lesson 2.13- Switching to Full Screen View
Lesson 2.14- Working With Excel File Formats

CHAPTER 3-

Microsoft Office 2016 Tutorial: Data Entry

Lesson 3.1- Selecting Cells Microsoft Office 2016 tutorial: Free button.
Lesson 3.2- Entering Text into Cells Microsoft Office 2016 tutorial: Free button.
Lesson 3.3- Entering Numbers into Cells Microsoft Office 2016 tutorial: Free button.
Lesson 3.4- AutoComplete
Lesson 3.5- Pick from Drop-Down List
Lesson 3.6- Flash Fill
Lesson 3.7- Selecting Ranges
Lesson 3.8- Ranged Data Entry
Lesson 3.9- Using AutoFill

CHAPTER 4-

Microsoft Office 2016 Tutorial: Creating Formulas

Lesson 4.1- Ranged Formula Syntax Microsoft Office 2016 tutorial: Free button.
Lesson 4.2- Simple Formula Syntax Microsoft Office 2016 tutorial: Free button.
Lesson 4.3- Writing Formulas Microsoft Office 2016 tutorial: Free button.
Lesson 4.4- Using AutoSum
Lesson 4.5- Inserting Functions
Lesson 4.6- Editing a Range
Lesson 4.7- Formula AutoCorrect
Lesson 4.8- AutoCalculate
Lesson 4.9- Function Compatibility

CHAPTER 5-

Microsoft Office 2016 Tutorial: Copying & Pasting Formulas

Lesson 5.1- Relative References and Absolute References
Lesson 5.2- Cutting, Copying, and Pasting Data
Lesson 5.3- AutoFilling Cells
Lesson 5.4- The Undo Button
Lesson 5.5- The Redo Button

CHAPTER 6-

Microsoft Office 2016 Tutorial: Columns & Rows

Lesson 6.1- Selecting Columns & Rows
Lesson 6.2- Adjusting Column Width and Row Height
Lesson 6.3- Hiding and Unhiding Columns and Rows
Lesson 6.4- Inserting and Deleting Columns and Rows

CHAPTER 7-

Microsoft Office 2016 Tutorial: Formatting Worksheets

Lesson 7.1- Formatting Cells
Lesson 7.2- The Format Cells Dialog Box
Lesson 7.3- Clearing All Formatting from Cells
Lesson 7.4- Copying All Formatting from Cells to Another Area

CHAPTER 8-

Microsoft Office 2016 Tutorial: Worksheet Tools

Lesson 8.1- Inserting and Deleting Worksheets
Lesson 8.2- Selecting Multiple Worksheets
Lesson 8.3- Navigating Worksheets
Lesson 8.4- Renaming Worksheets
Lesson 8.5- Coloring Worksheet Tabs
Lesson 8.6- Copying or Moving Worksheets

CHAPTER 9-

Microsoft Office 2016 Tutorial: Setting Worksheet Layout

Lesson 9.1- Using Page Break Preview
Lesson 9.2- Using The Page Layout View
Lesson 9.3- Opening the Page Setup Dialog Box
Lesson 9.4- Page Settings
Lesson 9.5- Setting Margins
Lesson 9.6- Creating Headers and Footers
Lesson 9.7- Sheet Settings

CHAPTER 10-

Microsoft Office 2016 Tutorial: Printing Worksheets

Lesson 10.1- Previewing and Printing Worksheets

CHAPTER 11-

Microsoft Office 2016 Tutorial: Helping Yourself

Lesson 11.1- Using Excel Help
Lesson 11.2- The Tell Me Bar- 2016 Only
Lesson 11.3- Smart Lookup and Insights- 2016 Only

CHAPTER 12-

Microsoft Office 2016 Tutorial: Creating 3D Formulas

Lesson 12.1- Creating 3D Formulas
Lesson 12.2- 3D Formula Syntax
Lesson 12.3- Creating 3D Range References

CHAPTER 13-

Microsoft Office 2016 Tutorial: Named Ranges

Lesson 13.1- Naming Ranges
Lesson 13.2- Creating Names from Headings
Lesson 13.3- Moving to a Named Range
Lesson 13.4- Using Named Ranges in Formulas
Lesson 13.5- Naming 3D Ranges
Lesson 13.6- Deleting Named Ranges

CHAPTER 14-

Microsoft Office 2016 Tutorial: Conditional Formatting and Cell Styles

Lesson 14.1- Conditional Formatting
Lesson 14.2- Finding Cells with Conditional Formatting
Lesson 14.3- Clearing Conditional Formatting
Lesson 14.4- Using Table and Cell Styles

CHAPTER 15-

Microsoft Office 2016 Tutorial: Paste Special

Lesson 15.1- Using Paste Special
Lesson 15.2- Pasting Linked Formulas

CHAPTER 16-

Microsoft Office 2016 Tutorial: Sharing Workbooks

Lesson 16.1- About Sharing Workbooks
Lesson 16.2- Simplified Workbook Sharing in Excel 2016
Lesson 16.3- Traditional Workbook Sharing
Lesson 16.4- Highlighting Changes
Lesson 16.5- Reviewing Changes
Lesson 16.6- Using Comments
Lesson 16.7- Compare and Merge Workbooks

CHAPTER 17-

Microsoft Office 2016 Tutorial: Auditing Worksheets

Lesson 17.1- Auditing Worksheets
Lesson 17.2- Tracing Precedent and Dependent Cells
Lesson 17.3- Tracing Errors
Lesson 17.4- Error Checking
Lesson 17.5- Using the Watch Window
Lesson 17.6- Cell Validation

CHAPTER 18-

Microsoft Office 2016 Tutorial: Outlining Worksheets

Lesson 18.1- Using Outlines
Lesson 18.2- Applying and Removing Outlines

CHAPTER 19-

Microsoft Office 2016 Tutorial: Consolidating Worksheets

Lesson 19.1- Consolidating Data

CHAPTER 20-

Microsoft Office 2016 Tutorial: Tables

Lesson 20.1- Creating a Table
Lesson 20.2- Adding and Editing Records
Lesson 20.3- Inserting Records and Fields
Lesson 20.4- Deleting Records and Fields

CHAPTER 21-

Microsoft Office 2016 Tutorial: Sorting Data

Lesson 21.1- Sorting Data
Lesson 21.2- Custom Sort Orders

CHAPTER 22-

Microsoft Office 2016 Tutorial: Filtering Data

Lesson 22.1- Using AutoFilters
Lesson 22.2- Using the Top 10 AutoFilter
Lesson 22.3- Applying a Custom AutoFilter
Lesson 22.4- Creating Advanced Filters
Lesson 22.5- Applying Multiple Criteria
Lesson 22.6- Using Complex Criteria
Lesson 22.7- Copying Filter Results to a New Location
Lesson 22.8- Using Database Functions

CHAPTER 23-

Microsoft Office 2016 Tutorial: What-If Analysis and Forecasts

Lesson 23.1- Using Data Tables
Lesson 23.2- Using Scenario Manager
Lesson 23.3- Using Goal Seek
Lesson 23.4- Forecast Sheets- 2016 Only

CHAPTER 24-

Microsoft Office 2016 Tutorial: Table-Related Functions

Lesson 24.1- The Hlookup and Vlookup Functions
Lesson 24.2- Using the IF, AND, and OR Functions

CHAPTER 25-

Microsoft Office 2016 Tutorial: Sparklines

Lesson 25.1- Inserting and Deleting Sparklines
Lesson 25.2- Modifying Sparklines

CHAPTER 26-

Microsoft Office 2016 Tutorial: Creating Charts In Excel

Lesson 26.1- Creating Charts
Lesson 26.2- Selecting Charts and Chart Elements
Lesson 26.3- Adding Chart Elements
Lesson 26.4- Moving and Resizing Charts
Lesson 26.5- Changing the Chart Type
Lesson 26.6- Changing the Data Range
Lesson 26.7- Switching Column and Row Data
Lesson 26.8- Choosing a Chart Layout
Lesson 26.9 Choosing a Chart Style
Lesson 26.10 Changing Color Schemes
Lesson 26.11- Printing Charts
Lesson 26.12- Deleting Charts

CHAPTER 27-

Microsoft Office 2016 Tutorial: Formatting Charts in Excel

Lesson 27.1- Formatting Chart Objects
Lesson 27.2- Inserting Objects into a Chart
Lesson 27.3- Formatting Axes
Lesson 27.4- Formatting Axis Titles
Lesson 27.5- Formatting a Chart Title
Lesson 27.6- Formatting Data Labels
Lesson 27.7- Formatting a Data Table
Lesson 27.8- Formatting Error Bars
Lesson 27.9- Formatting Gridlines
Lesson 27.10- Formatting a Legend
Lesson 27.11- Formatting Drop and High-Low Lines
Lesson 27.12- Formatting Trendlines
Lesson 27.13- Formatting Up/Down Bars
Lesson 27.14- Formatting the Chart and Plot Areas
Lesson 27.15- Naming Charts
Lesson 27.16- Applying Shape Styles
Lesson 27.17- Applying WordArt Styles
Lesson 27.18- Saving Custom Chart Templates

CHAPTER 28-

Microsoft Office 2016 Tutorial: Data Models

Lesson 28.1- Creating a Data Model from External Relational Data
Lesson 28.2- Creating a Data Model from Excel Tables
Lesson 28.3- Relating Tables in a Data Model
Lesson 28.4- Managing a Data Model

CHAPTER 29-

Microsoft Office 2016 Tutorial: PivotTables and PivotCharts

Lesson 29.1- Creating Recommended PivotTables
Lesson 29.2- Manually Creating a PivotTable
Lesson 29.3- Creating a PivotChart
Lesson 29.4- Manipulating a PivotTable or PivotChart
Lesson 29.5- Changing Calculated Value Fields
Lesson 29.6- Formatting PivotTables
Lesson 29.7- Formatting PivotCharts
Lesson 29.8- Setting PivotTable Options
Lesson 29.9- Sorting and Filtering Using Field Headers

CHAPTER 30-

Microsoft Office 2016 Tutorial: Power Pivot

Lesson 30.1- Starting Power Pivot
Lesson 30.2- Managing the Data Model
Lesson 30.3- Calculated Columns
Lesson 30.4- Measures
Lesson 30.5- Creating KPIs
Lesson 30.6- Creating and Managing Perspectives
Lesson 30.6- Power Pivot PivotTables and PivotCharts

CHAPTER 31-

Microsoft Office 2016 Tutorial: Power View

Lesson 31.1- Starting Power View
Lesson 31.2- Adding Report Visualizations
Lesson 31.3- Changing the Layout of Report Visualizations
Lesson 31.4- Using Undo and Redo in Power View
Lesson 31.5- Formatting the Power View Sheet
Lesson 31.6- Creating Multiples in a Chart
Lesson 31.7- Filtering Power View Using the Filter Area
Lesson 31.8- Cross-Filtering Visualizations

CHAPTER 32-

Microsoft Office 2016 Tutorial: Slicers and Timelines

Lesson 32.1- Inserting and Deleting Slicers
Lesson 32.2- Modifying Slicers
Lesson 32.3- Inserting and Deleting Timelines
Lesson 32.4- Modifying Timelines

CHAPTER 33-

Microsoft Office 2016 Tutorial: Security Features

Lesson 33.1- Unlocking Cells
Lesson 33.2- Worksheet Protection
Lesson 33.3- Workbook Protection
Lesson 33.4- Password Protecting Excel Files

CHAPTER 34-

Microsoft Office 2016 Tutorial: Making Macros

Lesson 34.1- Recording Macros
Lesson 34.2- Running and Deleting Recorded Macros
Lesson 34.3- The Personal Macro Workbook


OneNote Course Syllabus & Sample Lessons

Select any of the video lessons markedMicrosoft Office 2016 tutorial: Free button.to view them in a new window.

To view a sample of the instruction manual in PDF, click here: Introductory OneNote

CHAPTER 1-

Microsoft Office 2016 Tutorial: Getting Acquainted with OneNote

Lesson 1.1- The OneNote Environment Microsoft Office 2016 tutorial: Free button.
Lesson 1.2- The Title Bar
Lesson 1.3- The Ribbon
Lesson 1.4- The “File” Tab and Backstage View
Lesson 1.5- The Quick Access Toolbar
Lesson 1.6- The Scroll Bars
Lesson 1.7- The Mini Toolbar

CHAPTER 2-

Microsoft Office 2016 Tutorial: Getting Started

Lesson 2.1- Opening, Saving and Closing Notebooks Microsoft Office 2016 tutorial: Free button.
Lesson 2.2- Creating New Notebooks
Lesson 2.3- Creating, Moving and Deleting Sections and Pages
Lesson 2.4- Creating, Moving and Deleting Subpages

CHAPTER 3-

Microsoft Office 2016 Tutorial: Notes

Lesson 3.1- Creating a Basic Note Microsoft Office 2016 tutorial: Free button.
Lesson 3.2- Quick Notes
Lesson 3.3- Copying and Pasting Content Microsoft Office 2016 tutorial: Free button.
Lesson 3.4- Screen Clippings
Lesson 3.5- Adding Pictures
Lesson 3.6- Adding Audio & Video Files
Lesson 3.7- Inserting Online Video
Lesson 3.8- Recording Audio & Video Files
Lesson 3.9- Adding Other Types of Files
Lesson 3.10- Embedding an Excel Spreadsheet
Lesson 3.11- Adding Mathematical Equations
Lesson 3.12- Quick Filing – Sending Information to OneNote

CHAPTER 4-

Microsoft Office 2016 Tutorial: Formatting Notes

Lesson 4.1- Basic Text Formatting Microsoft Office 2016 tutorial: Free button.
Lesson 4.2- Bullets and Numbering Microsoft Office 2016 tutorial: Free button.
Lesson 4.3- Checking Spelling
Lesson 4.4- Setting Default Proofing Options

CHAPTER 5-

Microsoft Office 2016 Tutorial: Working with Microsoft Outlook

Lesson 5.1- Inserting Outlook Meetings
Lesson 5.2- Sending Notebook Pages via Microsoft Outlook
Lesson 5.3- Working with Microsoft Outlook Tasks

CHAPTER 6-

Microsoft Office 2016 Tutorial: Tables

Lesson 6.1- Creating a Table
Lesson 6.2- Working with Columns and Rows
Lesson 6.3- Formatting Tables and Table Data
Lesson 6.4- Moving Tables and Table Data

CHAPTER 7-

Microsoft Office 2016 Tutorial: Writing Tools

Lesson 7.1- Pen Mode
Lesson 7.2- Formatting Written Notes & Drawings
Lesson 7.3- Adding and Removing Note Space
Lesson 7.4- Converting Handwriting to Type

CHAPTER 8-

Microsoft Office 2016 Tutorial: Viewing and Organizing Information

Lesson 8.1- Organizing the OneNote Interface
Lesson 8.2- Creating New Windows
Lesson 8.3 Searching Content in a Notebook
Lesson 8.4- Wiki Linking
Lesson 8.5- Tagging Notes
Lesson 8.6- Working with Sections
Lesson 8.7- Section Groups

CHAPTER 9-

Microsoft Office 2016 Tutorial: Stationery and Templates

Lesson 9.1- Applying Templates and Stationery
Lesson 9.2- Custom Templates
Lesson 9.3- Choosing a Default Template

CHAPTER 10-

Microsoft Office 2016 Tutorial: Formatting Pages

Lesson 10.1- Defining Paper Size and Margins
Lesson 10.2- Formatting Page Backgrounds
Lesson 10.3- Adding a Background Graphic

CHAPTER 11-

Microsoft Office 2016 Tutorial: Printing

Lesson 11.1- Previewing and Printing

CHAPTER 12-

Microsoft Office 2016 Tutorial: Sharing Notebooks & Collaborating

Lesson 12.1- Saving and Exporting Notebooks to Share
Lesson 12.2- Creating a Shared Notebook and Inviting Others to Share
Lesson 12.3- Sharing Notes in an Outlook Meeting Invitation
Lesson 12.4- Synching Notebooks
Lesson 12.5- Sending Pages in Various Formats
Lesson 12.6- Author Indicators
Lesson 12.7- Finding Newly Added Content with Highlighting
Lesson 12.8- Page Versions
Lesson 12.9- The Notebook Recycle Bin

CHAPTER 13-

Microsoft Office 2016 Tutorial: Researching with OneNote

Lesson 13.1- Linked Notes
Lesson 13.2- The Research Pane
Lesson 13.3- Translating Text with the Mini Translator

CHAPTER 14-

Microsoft Office 2016 Tutorial: Changing OneNote Options

Lesson 14.1- Customizing the Quick Access Toolbar and Ribbon
Lesson 14.2- Changing OneNote Options

CHAPTER 15-

Microsoft Office 2016 Tutorial: Helping Yourself

Lesson 15.1- Using OneNote Help


Outlook Course Syllabus & Sample Lessons

Select any of the video lessons markedMicrosoft Office 2016 tutorial: Free button.to view them in a new window.

To view a sample of the instruction manuals in PDF, click here: Introductory Outlook | Advanced Outlook

CHAPTER 1-

Microsoft Office 2016 Tutorial: Getting Acquainted with Outlook

Lesson 1.1- The Outlook Environment Microsoft Office 2016 tutorial: Free button.
Lesson 1.2- The Title Bar
Lesson 1.3- The Ribbon
Lesson 1.4- The Quick Access Toolbar
Lesson 1.5- Touch Mode
Lesson 1.6- The Navigation Bar, Folder Pane, Reading Pane, and To-Do Bar
Lesson 1.7- What’s New in Outlook 2016

CHAPTER 2-

Microsoft Office 2016 Tutorial: Making Contacts

Lesson 2.1- The People Folder
Lesson 2.2- Customizing the Contacts Folder View Microsoft Office 2016 tutorial: Free button.
Lesson 2.3- Creating Contacts Microsoft Office 2016 tutorial: Free button.
Lesson 2.4- Basic Contact Management
Lesson 2.5- Printing Contacts
Lesson 2.6- Creating Contact Groups
Lesson 2.7- Categorizing Contacts
Lesson 2.8- Searching for Contacts
Lesson 2.9- Calling Contacts
Lesson 2.10- Mapping a Contact’s Address

CHAPTER 3-

Microsoft Office 2016 Tutorial: E-Mail

Lesson 3.1- Using the Inbox
Lesson 3.2- Changing the Inbox View
Lesson 3.3- Message Flags
Lesson 3.4- Searching for Messages
Lesson 3.5- Creating, Addressing, and Sending Messages
Lesson 3.6- Checking Message Spelling
Lesson 3.7- Setting Message Options
Lesson 3.8- Formatting Messages
Lesson 3.9- Using Signatures
Lesson 3.10- Replying to Messages
Lesson 3.11- Forwarding Messages
Lesson 3.12- Sending Attachments
Lesson 3.13- Sharing a OneDrive File as an Attachment- 2016 Only
Lesson 3.14- Opening Attachments
Lesson 3.15- Ignoring Conversations

CHAPTER 4-

Microsoft Office 2016 Tutorial: The Sent Items Folder

Lesson 4.1- The Sent Items Folder
Lesson 4.2- Resending Messages
Lesson 4.3- Recalling Messages

CHAPTER 5-

Microsoft Office 2016 Tutorial: The Outbox Folder

Lesson 5.1- Using the Outbox

CHAPTER 6-

Microsoft Office 2016 Tutorial: Using the Calendar

Lesson 6.1- The Calendar Window
Lesson 6.2- Switching the Calendar View
Lesson 6.3- Navigating the Calendar
Lesson 6.4- Appointments, Meetings and Events
Lesson 6.5- Manipulating Calendar Objects
Lesson 6.6- Setting an Appointment Microsoft Office 2016 tutorial: Free button.
Lesson 6.7- Scheduling a Meeting Microsoft Office 2016 tutorial: Free button.
Lesson 6.8- Checking Meeting Attendance Status
Lesson 6.9- Responding to Meeting Requests
Lesson 6.10- Scheduling an Event
Lesson 6.11- Setting Recurrence
Lesson 6.12- Printing the Calendar
Lesson 6.13- Join Skype Meeting in Outlook 2016
Lesson 6.14- Meeting Notes

CHAPTER 7-

Microsoft Office 2016 Tutorial: Tasks

Lesson 7.1- Using Tasks
Lesson 7.2- Printing Tasks
Lesson 7.3- Creating a Task Microsoft Office 2016 tutorial: Free button.
Lesson 7.4- Setting Task Recurrence Microsoft Office 2016 tutorial: Free button.
Lesson 7.5- Creating a Task Request
Lesson 7.6- Responding to Task Requests
Lesson 7.7- Sending Status Reports
Lesson 7.8- Deleting Tasks

CHAPTER 8-

Microsoft Office 2016 Tutorial: Deleted Items

Lesson 8.1- The Deleted Items Folder
Lesson 8.2- Permanently Deleting Items
Lesson 8.3- Recovering Deleted Items
Lesson 8.4- Recovering and Purging Permanently Deleted Items

CHAPTER 9-

Microsoft Office 2016 Tutorial: Groups

Lesson 9.1- Accessing Groups
Lesson 9.2- Creating a New Group
Lesson 9.3- Adding Members to Groups
Lesson 9.4- Contributing to Groups
Lesson 9.5- Managing Files in Groups
Lesson 9.6- Accessing the Group Calendar
Lesson 9.7- Subscribing to and Unsubscribing from Groups
Lesson 9.8- Leaving Groups
Lesson 9.9- Editing, Managing and Deleting Groups

CHAPTER 10-

Microsoft Office 2016 Tutorial: The Journal Folder

Lesson 10.1- The Journal Folder
Lesson 10.2- Switching the Journal View
Lesson 10.3- Recording Journal Items
Lesson 10.4- Opening Journal Entries and Documents
Lesson 10.5- Deleting Journal Items

CHAPTER 11-

Microsoft Office 2016 Tutorial: Public Folders

Lesson 11.1- Creating Public Folders
Lesson 11.2- Setting Permissions
Lesson 11.3- Folder Rules
Lesson 11.4- Copying Public Folders

CHAPTER 12-

Microsoft Office 2016 Tutorial: Personal & Private Folders

Lesson 12.1- Creating a Personal Folder
Lesson 12.2- Setting AutoArchiving for Folders
Lesson 12.3- Creating Private Folders
Lesson 12.4- Creating Search Folders

CHAPTER 13-

Microsoft Office 2016 Tutorial: Notes

Lesson 13.1- Creating and Using Notes

CHAPTER 14-

Microsoft Office 2016 Tutorial: Advanced Mailbox Options

Lesson 14.1- Creating Mailbox Rules
Lesson 14.2- Creating Custom Mailbox Views
Lesson 14.3- Handling Junk Mail
Lesson 14.4- Color Categorizing
Lesson 14.5- Advanced Find
Lesson 14.6- Mailbox Cleanup

CHAPTER 15-

Microsoft Office 2016 Tutorial: Outlook Options

Lesson 15.1- Using Shortcuts
Lesson 15.2- Adding Additional Profiles
Lesson 15.3- Adding Additional Services
Lesson 15.4- Outlook Options
Lesson 15.5- Using Outlook Help

CHAPTER 16-

Microsoft Office 2016 Tutorial: Delegates

Lesson 16.1- Creating a Delegate
Lesson 16.2- Acting as a Delegate
Lesson 16.3- Deleting a Delegate


PowerPoint Course Syllabus & Sample Lessons

Select any of the video lessons markedMicrosoft Office 2016 tutorial: Free button.to view them in a new window.

To view a sample of the instruction manuals in PDF, click here: Introductory PowerPoint | Advanced PowerPoint

CHAPTER 1-

Microsoft Office 2016 Tutorial: Getting Acquainted with PowerPoint

Lesson 1.1- The PowerPoint Environment Microsoft Office 2016 tutorial: Free button.
Lesson 1.2- The Title Bar
Lesson 1.3- The Ribbon
Lesson 1.4- The “File” Tab and Backstage View Microsoft Office 2016 tutorial: Free button.
Lesson 1.5- The Quick Access Toolbar
Lesson 1.6- Touch/Mouse Mode
Lesson 1.7- The Scroll Bars
Lesson 1.8- The Presentation View Buttons
Lesson 1.9- The Zoom Slider
Lesson 1.10- The Status Bar
Lesson 1.11- The Mini Toolbar
Lesson 1.12- Keyboard Shortcuts
Lesson 1.13- What’s New in PowerPoint 2016

CHAPTER 2-

Microsoft Office 2016 Tutorial: Creating Basic Presentations

Lesson 2.1- Opening Presentations
Lesson 2.2- Closing Presentations
Lesson 2.3- Creating New Presentations
Lesson 2.4- Saving Presentations
Lesson 2.5- Recovering Unsaved Presentations Microsoft Office 2016 tutorial: Free button.
Lesson 2.6- Inserting New Slides Microsoft Office 2016 tutorial: Free button.
Lesson 2.7- Applying Slide Layouts
Lesson 2.8- Sharing Presentations
Lesson 2.9- Working with PowerPoint File Formats

CHAPTER 3-

Microsoft Office 2016 Tutorial: Using Presentation Views

Lesson 3.1- Normal View
Lesson 3.2- Outline View
Lesson 3.3- Slide Sorter View
Lesson 3.4- Notes Page View
Lesson 3.5- Slide Show View
Lesson 3.6- Reading View

CHAPTER 4-

Microsoft Office 2016 Tutorial: Using Text

Lesson 4.1- Adding Text to Slides
Lesson 4.2- Basic Object Manipulation
Lesson 4.3- Font Formatting
Lesson 4.4- Paragraph Formatting
Lesson 4.5- Applying Custom Bullets and Numbering
Lesson 4.6- Using Tabs
Lesson 4.7- Setting Text Options
Lesson 4.8- Checking Spelling

CHAPTER 5-

Microsoft Office 2016 Tutorial: Using Pictures

Lesson 5.1- Inserting Pictures Saved Locally
Lesson 5.2- Inserting Online Pictures
Lesson 5.3- Basic Graphic Manipulation
Lesson 5.4- Using Picture Tools
Lesson 5.5- Using the Format Picture Task Pane
Lesson 5.6- Fill and Line Settings
Lesson 5.7- Effects Settings
Lesson 5.8- Size and Properties Settings
Lesson 5.9- Picture Settings

CHAPTER 6-

Microsoft Office 2016 Tutorial: Using SmartArt

Lesson 6.1- Inserting and Manipulating SmartArt
Lesson 6.2- Formatting SmartArt

CHAPTER 7-

Microsoft Office 2016 Tutorial: Using Slide Show View

Lesson 7.1- Running a Slide Show
Lesson 7.2- Using Custom Shows

CHAPTER 8-

Microsoft Office 2016 Tutorial: Printing Your Presentation

Lesson 8.1- Changing Slide Size
Lesson 8.2- Setting the Slide Header and Footer
Lesson 8.3- Previewing and Printing Presentations

CHAPTER 9-

Microsoft Office 2016 Tutorial: Helping Yourself

Lesson 9.1- Using PowerPoint Help
Lesson 9.2- The Tell Me Bar- 2016 Only
Lesson 9.3- Smart Lookup and Insights- 2016 Only

CHAPTER 10-

Microsoft Office 2016 Tutorial: Applying Animation

Lesson 10.1- Adding Slide Transition Animation
Lesson 10.2- Adding Object Animation

CHAPTER 11-

Microsoft Office 2016 Tutorial: Drawing Objects

Lesson 11.1- Inserting Shapes
Lesson 11.2- Formatting Shapes
Lesson 11.3- Inserting WordArt

CHAPTER 12-

Microsoft Office 2016 Tutorial: Inserting Video and Sound

Lesson 12.1- Inserting Videos
Lesson 12.2- Inserting Audio
Lesson 12.3- Animating Multimedia Playback
Lesson 12.4- Recording a Sound
Lesson 12.5- Screen Recording

CHAPTER 13-

Microsoft Office 2016 Tutorial: Using Themes

Lesson 13.1- Applying Themes
Lesson 13.2- Creating Custom Color Schemes
Lesson 13.3- Creating Custom Font Schemes
Lesson 13.4- Customizing the Slide Background

CHAPTER 14-

Microsoft Office 2016 Tutorial: Using Presentation Masters

Lesson 14.1- Using Slide Masters and Slide Layouts
Lesson 14.2- Using the Notes Master
Lesson 14.3- Using the Handout Master
Lesson 14.4- Saving a Presentation Template

CHAPTER 15-

Microsoft Office 2016 Tutorial: Setting Up the Presentation

Lesson 15.1- Setting Up the Slide Show
Lesson 15.2- Recording Narration
Lesson 15.3- Recording Timings

CHAPTER 16-

Microsoft Office 2016 Tutorial: Applying Actions

Lesson 16.1- Inserting Actions
Lesson 16.2- Inserting Hyperlinks

CHAPTER 17-

Microsoft Office 2016 Tutorial: Inserting Charts, Tables, and Objects

Lesson 17.1- Inserting Charts
Lesson 17.2- Inserting Tables
Lesson 17.3- Inserting Objects

CHAPTER 18-

Microsoft Office 2016 Tutorial: Setting PowerPoint Options

Lesson 18.1- Setting PowerPoint Options


Publisher Course Syllabus & Sample Lessons

Select any of the video lessons markedMicrosoft Office 2016 tutorial: Free button.to view them in a new window.

To view a sample of the instruction manual in PDF, click here: Introductory Publisher

CHAPTER 1-

Microsoft Office 2016 Tutorial: Getting Acquainted with Publisher

Lesson 1.1- The Publisher Environment Microsoft Office 2016 tutorial: Free button.
Lesson 1.2- The Title Bar
Lesson 1.3- The Ribbon
Lesson 1.4- The File Tab and Backstage View
Lesson 1.5- The Quick Access Toolbar
Lesson 1.6- Touch Mode
Lesson 1.7- The Scroll Bars
Lesson 1.8- The Page Layout View Buttons
Lesson 1.9- The Zoom Slider and Zoom Button
Lesson 1.10- The Status Bar
Lesson 1.11- The Mini Toolbar
Lesson 1.12- Keyboard Shortcuts

CHAPTER 2-

Microsoft Office 2016 Tutorial: Creating Basic Publications

Lesson 2.1- Creating New Publications
Lesson 2.2- Changing the Publication Template Microsoft Office 2016 tutorial: Free button.
Lesson 2.3- Using Business Information Microsoft Office 2016 tutorial: Free button.
Lesson 2.4- Saving Publications
Lesson 2.5- Closing Publications
Lesson 2.6- Opening Publications
Lesson 2.7- Inserting New Pages
Lesson 2.8- Deleting Pages
Lesson 2.9- Moving Pages

CHAPTER 3-

Microsoft Office 2016 Tutorial: Basic Skills

Lesson 3.1- Inserting Text Boxes
Lesson 3.2- Inserting Shapes
Lesson 3.3- Adding Text to Shapes Microsoft Office 2016 tutorial: Free button.
Lesson 3.4- Inserting Pictures Saved Locally
Lesson 3.5- Inserting Online Pictures
Lesson 3.6- Inserting Picture Placeholders
Lesson 3.7- Using the Scratch Area
Lesson 3.8- Moving, Resizing, and Rotating Objects
Lesson 3.9- Deleting Objects
Lesson 3.10- Using Find and Replace
Lesson 3.11- Using AutoCorrect
Lesson 3.12- Inserting WordArt

CHAPTER 4-

Microsoft Office 2016 Tutorial: Formatting Objects

Lesson 4.1- Formatting Text
Lesson 4.2- Formatting Shapes
Lesson 4.3- Formatting Clip Art and Pictures

CHAPTER 5-

Microsoft Office 2016 Tutorial: Using Building Blocks

Lesson 5.1- Creating Basic Building Blocks
Lesson 5.2- Using Building Blocks

CHAPTER 6-

Microsoft Office 2016 Tutorial: Master Pages

Lesson 6.1- Using Master Pages

CHAPTER 7-

Microsoft Office 2016 Tutorial: Customizing Schemes

Lesson 7.1- Creating a Custom Color Scheme
Lesson 7.2- Creating a Custom Font Scheme
Lesson 7.3- Customizing Page Backgrounds

CHAPTER 8-

Microsoft Office 2016 Tutorial: Using Tables

Lesson 8.1- Creating and Deleting Tables
Lesson 8.2- Selecting Table Elements
Lesson 8.3- Inserting and Deleting Columns and Rows
Lesson 8.4- Merging Text in Table Cells
Lesson 8.5- Modifying Text in Table Cells
Lesson 8.6- Formatting Tables

CHAPTER 9-

Microsoft Office 2016 Tutorial: Page Setup and Layouts

Lesson 9.1- Using Page Setup
Lesson 9.2- Using Layout Guides
Lesson 9.3- Using the Rulers

CHAPTER 10-

Microsoft Office 2016 Tutorial: Mailings

Lesson 10.1- Mail Merge
Lesson 10.2- The Step by Step Mail Merge Wizard
Lesson 10.3- Creating a Data Source
Lesson 10.4- Selecting Recipients
Lesson 10.5- Inserting and Deleting Merge Fields
Lesson 10.6- Previewing a Merge
Lesson 10.7- Detaching the Data Source
Lesson 10.8- Finishing a Mail Merge
Lesson 10.9- Merging a Catalog

CHAPTER 11-

Microsoft Office 2016 Tutorial: Printing

Lesson 11.1- Previewing and Printing
Lesson 11.2- Using the Pack and Go Feature
Lesson 11.3- Sharing and Exporting Publications

CHAPTER 12-

Microsoft Office 2016 Tutorial: Helping Yourself

Lesson 12.1- Using Publisher Help


Word Course Syllabus & Sample Lessons

Select any of the video lessons markedMicrosoft Office 2016 tutorial: Free button.to view them in a new window.

To view samples of the instruction manuals in PDF, click here: Introductory Word | Intermediate Word| Advanced Word

CHAPTER 1-

Microsoft Office 2016 Tutorial: Getting Acquainted with Word

Lesson 1.1- About Word
Lesson 1.2- The Word Environment
Lesson 1.3- The Title Bar
Lesson 1.4- The Ribbon
Lesson 1.5- The “File” Tab and Backstage View
Lesson 1.6- The Quick Access Toolbar
Lesson 1.7- Touch Mode
Lesson 1.8- The Ruler
Lesson 1.9- The Scroll Bars
Lesson 1.10- The Document View Buttons
Lesson 1.11- The Zoom Slider
Lesson 1.12- The Status Bar
Lesson 1.13- The Mini Toolbar
Lesson 1.14- Keyboard Shortcuts

CHAPTER 2-

Microsoft Office 2016 Tutorial: Creating Basic Documents

Lesson 2.1- Opening Documents
Lesson 2.2- Closing Documents
Lesson 2.3- Creating New Documents
Lesson 2.4- Saving Documents
Lesson 2.5- Recovering Unsaved Documents Microsoft Office 2016 tutorial: Free button.
Lesson 2.6- Entering Text
Lesson 2.7- Moving through Text
Lesson 2.8- Selecting Text
Lesson 2.9- Non-Printing Characters Microsoft Office 2016 tutorial: Free button.

CHAPTER 3-

Microsoft Office 2016 Tutorial: Document Views

Lesson 3.1- Changing Document Views
Lesson 3.2- Showing and Hiding the Ruler
Lesson 3.3- Showing and Hiding Gridlines
Lesson 3.4- Showing and Hiding the Navigation Pane
Lesson 3.5- Zooming the Document
Lesson 3.6- Opening a Copy of a Document in a New Window
Lesson 3.7- Arranging Open Document Windows
Lesson 3.8- Split Window Microsoft Office 2016 tutorial: Free button.
Lesson 3.9- Comparing Open Documents Microsoft Office 2016 tutorial: Free button.
Lesson 3.10- Switching Open Documents
Lesson 3.11- Switching to Full Screen View
Lesson 3.12- Working with Word File Formats

CHAPTER 4-

Microsoft Office 2016 Tutorial: Basic Editing Skills

Lesson 4.1- Deleting Text
Lesson 4.2- Cutting, Copying, and Pasting
Lesson 4.3- Undoing and Redoing Actions
Lesson 4.4- Finding and Replacing Text
Lesson 4.5- Selecting Text and Objects

CHAPTER 5-

Microsoft Office 2016 Tutorial: Basic Proofing Skills

Lesson 5.1- The Spelling and Grammar Tool
Lesson 5.2- Setting Default Proofing Options
Lesson 5.3- Using the Thesaurus
Lesson 5.4- Finding the Word Count
Lesson 5.5- Translating Documents

CHAPTER 6-

Microsoft Office 2016 Tutorial: Font Formatting

Lesson 6.1- Formatting Fonts
Lesson 6.2- The Font Dialog Box
Lesson 6.3- The Format Painter
Lesson 6.4- Applying Styles to Text
Lesson 6.5- Removing Styles from Text

CHAPTER 7-

Microsoft Office 2016 Tutorial: Formatting Paragraphs

Lesson 7.1- Aligning Paragraphs
Lesson 7.2- Indenting Paragraphs
Lesson 7.3- Line Spacing and Paragraph Spacing

CHAPTER 8-

Microsoft Office 2016 Tutorial: Document Layout

Lesson 8.1- About Documents and Sections
Lesson 8.2- Setting Page and Section Breaks Microsoft Office 2016 tutorial: Free button.
Lesson 8.3- Creating Columns in a Document
Lesson 8.4- Creating Column Breaks
Lesson 8.5- Using Headers and Footers
Lesson 8.6- The Page Setup Dialog Box
Lesson 8.7- Setting Margins
Lesson 8.8- Paper Settings
Lesson 8.9- Layout Settings
Lesson 8.10- Adding Line Numbers
Lesson 8.11- Hyphenation Settings

CHAPTER 9-

Microsoft Office 2016 Tutorial: Using Templates

Lesson 9.1- Using Templates
Lesson 9.2- Creating Personal Templates

CHAPTER 10-

Microsoft Office 2016 Tutorial: Printing Documents

Lesson 10.1- Previewing and Printing Documents

CHAPTER 11-

Microsoft Office 2016 Tutorial: Helping Yourself

Lesson 11.1- Using Word Help
Lesson 11.2- The Tell Me Bar- 2016 Only
Lesson 11.3- Smart Lookup and Insights- 2016 Only

CHAPTER 12-

Microsoft Office 2016 Tutorial: Working with Tabs

Lesson 12.1- Using Tab Stops
Lesson 12.2- Using the Tabs Dialog Box

CHAPTER 13-

Microsoft Office 2016 Tutorial: Pictures and Media

Lesson 13.1- Inserting Online Pictures
Lesson 13.2- Inserting Your Own Pictures
Lesson 13.3- Using Picture Tools
Lesson 13.4- Using the Format Picture Task Pane
Lesson 13.5- Fill & Line Settings
Lesson 13.6- Effects Settings
Lesson 13.7- Layout & Properties Settings
Lesson 13.8- Picture Settings
Lesson 13.9- Inserting Screenshots
Lesson 13.10- Inserting Screen Clippings
Lesson 13.11- Inserting Online Video

CHAPTER 14-

Microsoft Office 2016 Tutorial: Drawing Objects

Lesson 14.1- Inserting Shapes
Lesson 14.2- Inserting WordArt
Lesson 14.3- Inserting Text Boxes
Lesson 14.4- Formatting Shapes
Lesson 14.5- The Format Shape Task Pane
Lesson 14.6- Inserting SmartArt
Lesson 14.7- Design and Format SmartArt
Lesson 14.8- Inserting Charts

CHAPTER 15-

Microsoft Office 2016 Tutorial: Using Building Blocks

Lesson 15.1- Creating Building Blocks
Lesson 15.2- Using Building Blocks

CHAPTER 16-

Microsoft Office 2016 Tutorial: Styles

Lesson 16.1- About Styles
Lesson 16.2- Applying Styles
Lesson 16.3- Showing Headings in the Navigation Pane
Lesson 16.4- The Styles Task Pane
Lesson 16.5- Clearing Styles from Text
Lesson 16.6- Creating a New Style
Lesson 16.7- Modifying an Existing Style
Lesson 16.8- Selecting All Instances of a Style in a Document
Lesson 16.9- Renaming Styles
Lesson 16.10- Deleting Custom Styles
Lesson 16.11- Using the Style Inspector Pane
Lesson 16.12- Using the Reveal Formatting Pane

CHAPTER 17-

Microsoft Office 2016 Tutorial: Themes and Style Sets

Lesson 17.1- Applying a Theme
Lesson 17.2- Applying a Style Set
Lesson 17.3- Customizing Theme Colors
Lesson 17.4- Customizing Theme Fonts
Lesson 17.5- Selecting Theme Effects

CHAPTER 18-

Microsoft Office 2016 Tutorial: Page Backgrounds

Lesson 18.1- Applying Watermarks
Lesson 18.2- Creating Custom Watermarks
Lesson 18.3- Removing Watermarks
Lesson 18.4- Selecting a Page Background Color or Fill Effect
Lesson 18.5- Applying Page Borders

CHAPTER 19-

Microsoft Office 2016 Tutorial: Bullets and Numbering

Lesson 19.1- Applying Bullets and Numbering
Lesson 19.2- Formatting Bullets and Number
Lesson 19.3- Applying a Multilevel List
Lesson 19.4- Modifying a Multilevel List

CHAPTER 20-

Microsoft Office 2016 Tutorial: Tables

Lesson 20.1- Using Tables
Lesson 20.2- Creating Tables
Lesson 20.3- Selecting Table Objects
Lesson 20.4- Inserting and Deleting Columns and Rows
Lesson 20.5- Deleting Cells and Tables
Lesson 20.6- Merging and Splitting Cells
Lesson 20.7- Adjusting Cell Size
Lesson 20.8- Aligning Text in Table Cells
Lesson 20.9- Converting a Table into Text
Lesson 20.10- Sorting Tables
Lesson 20.11- Formatting Tables
Lesson 20.12- Inserting Quick Tables

CHAPTER 21-

Microsoft Office 2016 Tutorial: Table Formulas

Lesson 21.1- Inserting Table Formulas
Lesson 21.2- Recalculating Word Formulas
Lesson 21.3- Viewing Formulas vs. Formula Results
Lesson 21.4- Inserting a Microsoft Excel Worksheet

CHAPTER 22-

Microsoft Office 2016 Tutorial: Inserting Page Elements

Lesson 22.1- Inserting Drop Caps
Lesson 22.2- Inserting Equations
Lesson 22.3- Inserting Ink Equations
Lesson 22.4- Inserting Symbols
Lesson 22.5- Inserting Bookmarks
Lesson 22.6- Inserting Hyperlinks

CHAPTER 23-

Microsoft Office 2016 Tutorial: Outlines

Lesson 23.1- Using Outline View
Lesson 23.2- Promoting and Demoting Outline Text
Lesson 23.3- Moving Selected Outline Text
Lesson 23.4- Collapsing and Expanding Outline Text

CHAPTER 24-

Microsoft Office 2016 Tutorial: Mailings

Lesson 24.1- Mail Merge
Lesson 24.2- The Step by Step Mail Merge Wizard
Lesson 24.3- Creating a Data Source
Lesson 24.4- Selecting Recipients
Lesson 24.5- Inserting and Deleting Merge Fields
Lesson 24.6- Error Checking
Lesson 24.7- Detaching a Data Source
Lesson 24.8- Finishing a Mail Merge

CHAPTER 25-

Microsoft Office 2016 Tutorial: Sharing Documents

Lesson 25.1- Simplified Document Sharing in Word 2016
Lesson 25.2- Inserting Comments
Lesson 25.3- Sharing by Email
Lesson 25.4- Presenting Online
Lesson 25.5- Posting to a Blog
Lesson 25.6- Saving as a PDF or XPS File
Lesson 25.7- Saving as a Different File Type

CHAPTER 26-

Microsoft Office 2016 Tutorial: Creating a Table of Contents

Lesson 26.1- Creating a Table of Contents
Lesson 26.2- Customizing a Table of Contents
Lesson 26.3- Updating a Table of Contents
Lesson 26.4- Deleting a Table of Contents

CHAPTER 27-

Microsoft Office 2016 Tutorial: Creating an Index

Lesson 27.1- Creating an Index
Lesson 27.2- Customizing an Index
Lesson 27.3- Updating an Index

CHAPTER 28-

Microsoft Office 2016 Tutorial: Citations and Bibliography

Lesson 28.1- Select a Citation Style
Lesson 28.2- Insert a Citation
Lesson 28.3- Insert a Citation Placeholder
Lesson 28.4- Managing Sources
Lesson 28.5- Editing Sources
Lesson 28.6- Creating a Bibliography

CHAPTER 29-

Microsoft Office 2016 Tutorial: Captions

Lesson 29.1- Inserting Captions
Lesson 29.2- Inserting a Table of Figures
Lesson 29.3- Inserting a Cross-Reference
Lesson 29.4- Updating a Table of Figures

CHAPTER 30-

Microsoft Office 2016 Tutorial: Creating Forms

Lesson 30.1- Displaying the Developer Tab
Lesson 30.2- Creating a Form
Lesson 30.3- Inserting Controls
Lesson 30.4- Repeating Section Content Control
Lesson 30.5- Adding Instructional Text
Lesson 30.6- Protecting a Form

CHAPTER 31-

Microsoft Office 2016 Tutorial: Making Macros

Lesson 31.1- Recording Macros
Lesson 31.2- Running and Deleting Recorded Macros
Lesson 31.3- Assigning Macros

CHAPTER 32-

Microsoft Office 2016 Tutorial: Word Options

Lesson 32.1- Setting Word Options
Lesson 32.2- Setting Document Properties
Lesson 32.3- Checking Accessibility

CHAPTER 33-

Microsoft Office 2016 Tutorial: Document Security

Lesson 33.1- Applying Password Protection to a Document
Lesson 33.2- Removing Password Protection from a Document
Lesson 33.3- Restrict Editing within a Document
Lesson 33.4- Removing Editing Restrictions from a Document


Microsoft Office 2016 Tutorial: Course Overview

Microsoft Office is a powerful suite of desktop applications used by individuals and businesses the world over. Mastering Microsoft Office Made Easy brings together 7 of our most popular application courses. Our Microsoft Office 2016 tutorial includes introductory through advanced material in Microsoft Access, Excel, OneNote, Outlook, PowerPoint, Publisher, and Word. This Microsoft Office 2016 tutorial also offers over 42 hours of expert video training, 15 classroom instruction manuals in PDF (Introductory, Intermediate and Advanced), practice exercises and much more. This complete Microsoft Office 2016 tutorial covers the same curriculum as our classroom training and was designed to provide a solid foundation in Office.

We offer two types of Microsoft Office 2016 tutorials – Standard and CPE (Continuing Professional Education). The Standard training course includes all video lessons and printable classroom instruction manuals. The CPE edition includes the same training curriculum, plus a practice exam with evaluative feedback (find out why your answers are right or wrong), your final exam submission and a course certificate of completion – for each of the seven courses. The Microsoft Office CPE training course also qualifies for continuing education credit for CPAs (Certified Public Accountants) in certain states.

At TeachUcomp, Inc., you choose how you want your Microsoft Office 2016 tutorial delivered.

Online subscriptions offer the most flexibility and value. With online training, you can access your courses anytime and anywhere you have an internet connection (including all new releases and updates). Your subscription grants you instant access to ALL of our courses for one low price. There are no contracts and you can cancel at any time. You may choose between a monthly or annual plan.

Courses are also available individually via digital download or DVD-ROM for a one-time charge.

 

 

TOP