Choose from the Following Sessions

Getting Started with Acrobat

• Introducing Acrobat & PDFs
• Accessing PDFs
• Creating PDFs
• Searching PDFs
• Creating Bookmarks
• Creating Links

Beyond the Basics

• Advanced Document Tools
• Creating Links
• Enhancing Scans
• Adding Rich Media
• Automating with Action Words
• Exporting PDFs
• Redacting PDF Content
• Creating Signatures and Certificates

Polishing and Perfecting PDFs

• Creating Links
• Working with Text and Images
• Working with Headers and Footers
• Using Watermarks
• Working with Organize Pages
• Optimizing PDFs
• Restricting Editing of PDFs

Reviewing and Collaborating in Acrobat

• Comparing Documents
• Reviewing PDFs
• Working with the Comment Tools Pane
• Sending a PDF for Review
• Adding Stamps
• Protecting PDFs

Creating Interactive Forms

• Creating Forms
• Working with the Form Field
• Adding Form Fields
• Finalizing the Form

Choose from the Following Versions: 2013, 2016, 2019 or 365

Analyzing Excel Data with Lookup Functions

• Make Functions and Formulas Easier to Read with Named Ranges
• The Power of VLOOKUP
• The Power of HLOOKUP
• Using INDEX and MATCH

Automating with Macros

• Creating a Macro
• Recording a Macro to Automate Formatting
• Running a Macro
• Exploring the VBA Environment

Building a Spreadsheet

• Getting Started with Excel
• Navigating and Selecting in an Excel Workbook
• Entering Data in a Worksheet
• Working with Basic Excel Functions
• Understanding Cell and Range References

Calculating and Analyzing Data with Excel IF Statements

• Summarize Data with SUMIF, AVERAGEIF, and COUNTIF
• Analyzing with Logical Functions
• Using Nested IF Functions
• Handling Errors with the IFERROR Function

Check It & Protect It: Auditing & Protecting Workbooks

• Auditing Workbooks
• Applying Data Validation
• Password Protecting a Workbook
• Protecting Cells, Worksheets, and Workbooks

Creating Easy to Read Spreadsheets

• Adjusting Worksheet Layout and Data
• Modifying Text
• Aligning Cell Contents
• Formatting Numbers
• Working with Borders and Fills
• Format Quickly with Styles
• Applying Themes
• Automatically Format with Conditional Formatting
• Create and Use Templates

Creating Interactive Reports with Pivot Charts

• Analyzing with PivotCharts
• Formatting a Chart
• Modifying a PivotChart Design
• Formatting PivotChart Elements
• Filtering with Slicers and Timeline Slicers

Discovering and Presenting Trends Data with Charts

• Types of Charts
• Creating Charts and Graphs
• Modifying and Formatting Charts
• Advanced Charting Features
• Displaying Trends with Sparklines

Ensuring Data Integrity

• Converting Text to Columns
• Locating Duplicates
• Sharing Workbooks
• Tracking Changes in a Workbook
• Importing and Exporting Data

Managing and Delivering Workbooks

• Use Find, Replace, and Go To
• Proofing a Workbook
• Previewing a Workbook
• Preparing a Workbook for Printing
• Manage Worksheets
• Manage Workbook and Worksheet Views
• Manage Workbook Properties

New Features of Excel 2016

• New in Excel 2016
• Using Flash Fill
• New Chart Types
• Using the Quick Analysis Tools
• Working with Recommended PivotTables

PivotTables: Beyond the Basics

• Adding Calculated Fields and Calculated Items
• Applying Conditional Formatting to a PivotTable
• Creating Filter Pages
• Working with PowerPivot

Using Automated Analysis Tools

• Determining Potential Outcomes Using Data Tables
• Determining Potential Outcomes Using Scenarios
• Using Goal Seek
• Working with Solver
• Analyzing Data with Analysis ToolPak

Using Excel PivotTables to Present Interactive Data

• Analyzing with PivotTables
• Using the PivotTable Fields Pane
• Working with the PivotTable Tools Analyze Tab
• Formatting the PivotTable
• Filtering with Slicers and Timeline Slicers
• Creating a PivotChart from a PivotTable

Working Together: Connecting Worksheets & Workbooks

• The AutoFill Feature
• Using Quick Analysis Tools
• Switching Between Relative, Absolute, and Mixed References
• Linking Worksheets and Workbooks
• Working with Range Names

Choose from the Following Sessions

Getting Started with Office 2016

• The Office 2016 Environment
• Collaborating in Office 2016
• New in Word 2016
• New in Excel 2016
• New in PowerPoint 2016
• New in Outlook 2016

Excel 2016 New Features

• New in Excel 2016
• Using Flash Fill
• New Chart Types
• Using the Quick Analysis Tools
• Working with Recommended PivotTables

Outlook 2016 New Features

• New in Outlook 2016
• Understanding the People View
• Understanding the People Card
• New in Outlook Mail

PowerPoint 2016 New Features

• New Features Across Office Applications
• New in PowerPoint 2016
• Collaborating in Office 2016

Word 2016 New Features

• New in Word 2016
• New Features Across Office Applications
• Word 2016 Enhancements
• Collaborating in Office 2016

Choose from the Following Sessions

Getting Started with Office 365

• What is Office 365?
• Navigating in Office 365
• Using Outlook in Office 365
• Working with Word, Excel, and PowerPoint
• Working with Comments
• Printing and Sharing Documents in Office Online
• Using Co-Authoring for Collaboration

Getting Started with Delve

• Overview of Delve
• Using Boards
• Searching in Delve
• Working with the Me or People View
• Sharing Documents

Getting Started with Office 365 Video

• Overview of Office 365 Video
• Playing a Video
• Working with Channels
• Uploading a Video
• Sharing Videos
• Administrative Permissions

Getting Started with OneDrive

• Overview of OneDrive
• Opening and Saving Files in OneDrive
• Creating and Rearranging Folders
• Collaborating in OneDrive
• Working with Files
• Syncing Files

Getting Started with OneNote Online

• OneNote for Business Overview
• Creating a New Notebook
• Adding Sections and Pages to a Notebook
• Adding and Formatting Content
• Working with OneNote
• Printing and Sharing a Notebook

Getting Started with Outlook Online

• Working with Mail
• Folders and Views
• Managing Outlook Mail
• Working with the Calendar
• Working with People
• Working with Tasks

Getting Started with Planner

• Working with Plans
• Using Boards and Buckets
• Working with Tasks
• Working with Team Members
• Using Notifications
• Using the Charts View
• Using the Notebook

Getting Started with SharePoint Sites

• Sites Overview
• Creating and Sharing a Site
• Adding Content to a Site
• Creating a Library
• Inserting a Web Part
• Working with Files
• Creating a List
• Document Collaboration
• Using the Newsfeed
• Setting an Alert

Getting Started with Skype for Business

• Skype for Business Overview
• Working with a User’s Presence Status
• Working with Contacts
• Sending an Instant Message (IM)
• Using Desktop Sharing
• Working with Skype Meetings
• Sharing Files
• Additional Skype Features

Getting Started with Sway

• Overview of Sway
• Creating a New Sway Presentation
• Adding Content
• Changing the Look of a Presentation
• Sharing a Presentation
• Co-Authoring in Sway

Getting Started with Teams

• Overview of Teams
• Working with Conversations
• Overview of Channels
• Working with Files
• Integration with SharePoint
• Working with Meetings
• Adding a Tab
• Adding a Connector

Getting Started with Yammer

• Overview of Yammer
• Editing a User Profile
• Working with Groups
• Working with Conversations
• Working with Messages
• Searching in Yammer

Skype for Business Collaborating with Meetings

• The Basics of Using Skype for Business
• Working with a User’s Presence Status
• Working with Contacts
• Collaborating with Skype Meetings
• Sharing Content
• Using OneNote to Collaborate

Skype for Business Team Collaboration with OneNote

• The Basics Using Skype for Business
• Working with a User’s Presence Status
• Working with Contacts
• Collaborating with Skype Meetings
• Sharing Content
• Using OneNote to Collaborate

Choose from the Following Versions: 2010, 2013, 2016

Become a Power User with the Office Ribbon

• Understanding the Office Ribbon
• Working with Ribbon Tabs
• Working with Groups
• Customizing the Quick Access Toolbar
• Tailoring Backstage Options

Getting Started with Office 2016

• The Office 2016 Environment
• Collaborating in Office 2016
• New in Word 2016
• New in Excel 2016
• New in PowerPoint 2016
• New in Outlook 2016

Choose from the Following Versions: 2013, 2016, 2019 or 365

Be More Productive with OneNote

• Building and Organizing Notebooks
• Customizing the View
• Working with Images, Audio and Video
• Working with Data and Files
• Syncing and Sharing Notebooks

Getting Started with OneNote

• Understanding the Basics
• Adding Content
• Formatting a Notebook
• Working with Tags
• Working with Embedded Content

Organizing Meetings and Notes with OneNote and Outlook

• Setting Up a Notebook
• Sharing and Sending OneNote Content
• Working with Tasks
• Managing Outlook Meetings with OneNote

Team Collaboration

• Creating and Managing a Shared Notebook
• Syncing a Notebook
• Developing OneNote Pages
• Adding Additional Content Types
• Inserting an Excel File

Choose from the Following Versions: 2013, 2016, 2019 or 365

Automating E-mail Merges Using Microsoft Word

• Using Mail Merge to Send E-mails
• Formatting E-mail Messages in Word
• Start an E-mail Merge from Microsoft Word
• Using Mail Merge to Create Labels

Automating Outlook—Let Outlook Work for You

• Working with Email Templates
• Replying with Features
• Resending or Recalling a Message
• Working with Signatures
• Automating Outlook with Quick Steps
• Utilizing Quick Parts
• Creating and Managing Rules and Alerts
• Using Conditional Formatting
• Advanced Searching

Creating Attention Getting Emails

• Using Tables, SmartArt, and AutoText
• Working with Hyperlinks and Symbols
• Inserting Pictures and Shapes
• Using Stationery
• Assigning Importance or Sensitivity Options
• Using and Tracking Voting

Customizing the Outlook Experience

• Modifying Preview Settings
• Modifying Message Settings, Properties, and Options
• Using and Tracking Voting
• Modifying Contact Options
• Modifying Calendar Options

Getting Started with Outlook

• Understanding Outlook Components
• Performing Basic Outlook Functions
• Exploring the Mail Interface
• Organizing and Formatting Emails
• Exploring the New Message Tabs
• Forwarding and Replying to Emails
• Attaching and Inserting Files and Items
• Checking Spelling and Grammar

Keeping in Touch - Managing People and Contacts

• Contact Views
• Searching for Contacts
• Working with Contacts and Contact Groups
• Creating a Contact
• Creating Contact Groups
• Working with Business Cards

Keeping Your Mailbox Clean

• Cleaning up the Mailbox
• Backing Up Data
• Importing and Exporting Contacts
• Working with Junk Mail

Manage Your Outlook Mailbox Like a Pro

• Reading Options
• Working with Attachments
• Working with Color Categories and Flags
• Sorting and Filtering Emails
• Searching and Finding Emails
• Organizing Emails with Folders
• Printing Emails and Attachments
• Deleting Emails

New Features in Outlook 2016

• New in Outlook 2016
• Understanding the People View
• Understanding the People Card
• New in Outlook Mail

Organizing Meetings and Notes with OneNote and Outlook

• Getting Started with OneNote
• Note Taking in OneNote
• The Power of Search
• Integrating OneNote with Outlook

Quick and Easy Ways to Find Messages in Outlook

• Working with Color Categories and Flags
• Using Conditional Formatting
• Sorting and Filtering Emails
• Advanced Searching
• Organizing Emails with Folders
• Organizing Messages with Rules
• Creating Advanced Rules

Using the Calendar and Time Management Tools

• Exploring the Calendar Views
• Creating an Appointment
• Creating Meetings
• Managing Meetings
• Working with the Calendar
• Printing the Calendar
• Working with Tasks
• Assigning Tasks
• Working with Notes

Choose from the Following Versions: 2013, 2016, 2019 or 365

Building Your First Presentation

• Understanding the User Interface
• Elements of a Slide Layout
• Working with PowerPoint Presentations
• Creating Slides
• Working with Slide Elements
• Organizing Content with Slide Layouts
• Working with Slides in Other Views

Collaboration in PowerPoint

• Working with Existing Slides and Text
• Using Excel Data in PowerPoint
• Reviewing Presentations Using Comments
• Compare and Merge Presentations

Creating Dynamic Presentations Using Excel Data

• Preparing a Spreadsheet for Presentation
• Creating a Chart in Excel
• Modifying the Document Theme
• Inserting the Chart into PowerPoint

Creating Organized and Dynamic Presentations

• Adding Navigation with Hyperlinks
• Adding Interactivity with Action Buttons
• Creating Custom Slides Shows
• Organizing Slides with Sections

Designing Engaging PowerPoint Presentations with Animations

• Animating Objects and Text
• Modifying Animation Effects
• Applying Advanced Animation Effects
• Using Slide Transitions
• Modifying Transitions

Designing Memorable PowerPoint Presentations Using Media & Graphics

• Adding Interest with Images
• Working with Shapes
• Enhancing with Smart Art
• Working with Media

Enhancing Slides with Charts and Tables

• Creating and Formatting Tables
• Modifying Tables
• Creating Charts

Essentials of Formatting Presentations

• Character Formatting
• Paragraph Formatting
• Bullets and Numbering

Fundamentals of Delivering a Presentation

• Proofing a Presentation
• Customizing Print Options
• Delivering a Presentation
• Presenter View

New Features in PowerPoint 2016

• New Features Across Office Applications
• New in PowerPoint 2016
• Collaborating in Office 2016

Present Like a Pro: Using Advanced SlideShow Features

• Adding Annotations to Slides
• Working with Hidden Slides
• Recording Slide Timings
• Recording with Voice Narration and Slide Timings
• Configuring Advanced Presentation Formats
• Presenting Online
• Packaging a Presentation and Saving to a Folders

Using Slide Masters Effectively and Building Custom Templates

• Working with PowerPoint Masters
• Customizing Layout Masters
• Working with Custom Themes and Templates
• Working with Notes and Handout Masters

Choose from the Following Versions: 2013, 2016, 2019 or 365

An Introduction to SharePoint

• Accessing your SharePoint Site
• Navigating your SharePoint Site
• Components of SharePoint
• Performing a Search
• Uploading Documents and Pictures to a SharePoint Library
• Opening, Editing, and Saving a SharePoint file

Creating Document Libraries for Site Owners/Power Users

• Creating SharePoint Libraries
• Customizing Name and Navigation Options
• Configuring Version and Check Out Options
• Working with Advanced Settings
• Creating Alerts

Getting the Most from SharePoint

• What is SharePoint?
• Authoring and Organizing
• Collaboration and Sharing
• Integration with Office and Business Intelligence

Working with Libraries for the Site User

• Working with the User Interface Tools
• Organizing Files in a Document Library
• Working in Different Views
• Setting Alerts
• Using Check Out and Check In
• Understanding Versions

Working with Lists for the Site User

• Types of SharePoint Lists
• Working with the User Interface Tools
• Using a SharePoint Calendar
• Utilizing a SharePoint Task List
• Exploring Additional List Options

Choose from the Following Sessions

Conquer the Windows 10 Apps

• Cortana
• Maps
• Photos
• Mail
• People
• Calendar
• Weather

Customize Windows 10

• Adjusting Account Settings
• Personalizing Windows 10
• Changing the Display Options
• Modifying Additional Settings
• Managing Devices

Go to the Edge - Learn to Use Microsoft's New Browser

• Browsing the Web
• Utilizing Favorites
• Understanding the Reading List and Reading View
• Using Web Notes
• Downloading and Viewing Files
• Clearing the Browsing History

Installing, Updating and Troubleshooting Windows 10

• Working with Applications
• Configuring Windows 10
• Backing Up Windows 10
• Troubleshooting Windows 10

Manage Your Files Like a Boss

• Understanding Drive and Folder Structure
• Managing Files
• Customizing the File Explorer
• Working with Libraries
• Using OneDrive
• Sharing and Syncing Files

Master the Essentials

• Getting Started with Windows 10
• Exploring the Desktop
• Introducing the Action Center, Settings, and Control Panel
• Interacting with Windows, Menus, and Ribbons
• Using Tablet Mode
• Using Applications
• Customizing the Start Menu and Taskbar

Choose from the Following Versions: 2013, 2016, 2019 or 365

Advanced Document Layout

• Controlling Layout with Page and Section Breaks
• Changing Page Orientation
• Working with Columns
• Adding Borders and Shading
• Working with Multiple Headers and Footers
• Creating Signature Lines

Automatic Mail Merge

• Using Mail Merge to Create Form Letters
• Data Sources
• Mailing Labels and Envelopes
• Advanced Mail Merge

Automating Document Creation

• Using the Building Blocks Organizer
• Working with AutoText
• Using Field Codes
• Creating a Macro

Creating Documents Fast and Effectively

• Understanding the Word User Interface
• Navigating and Selecting Text
• Editing Text
• Opening and Editing a PDF
• Understanding Word File Formats

Creating Forms

• Working with Form Fields
• Adding Content Controls
• Using the Form
• Enforce Restricted Editing
• Entering Data in a Form

Creating Organized Documents with Tables and Lists

• Using Bulleted and Numbered Lists
• Customizing Lists
• Inserting Tables
• Modifying and Formatting Tables
• Adjusting Cells, Rows, and Columns
• Formatting Tables
• Creating Tables from Existing Text
• Embedding an Excel Object

Designing Style Guides for Fast and Consistent Formatting

• Creating and Applying Styles
• Modifying and Navigating with Styles
• Using Style Sets
• Using Themes
• Using Themes with Templates

Embellishing Documents with Graphics and Special Elements

• Working with Drop Caps and Special Characters
• Inserting and Formatting Pictures
• Resizing Images
• Inserting Text Boxes and Shapes
• Working with Page Elements

Finish Strong: Finalizing a Document for Printing

• Using Find, Replace, and Go To
• Proofing Documents
• Inserting Pages and Breaks
• Working with Headers & Footers
• Preparing a Document for Printing
• Previewing and Printing Documents

Let's Get Graphic: Working with Pictures and Shapes

• Working with Pictures
• Inserting Text Boxes and Shapes
• Wrapping Text around Objects
• Grouping and Aligning Objects
• Inserting SmartArt
• Modifying a SmartArt Graphic
• Enhancing Text with Effects and WordArt

Making Your Words Sing with Formatting

• Applying Character Formatting
• Working with Live Preview
• Applying Paragraph Formatting
• Adding Paragraph Borders and Shading
• Using the Format Painter

Managing Long Documents with Word

• Creating a Table of Contents
• Creating an Index
• Creating Tables of Figures or Tables of Tables
• Outline View
• Creating Master Documents

New Features in Word 2016

• New in Word 2016
• New Features Across Office Applications
• Word 2016 Enhancements
• Collaborating in Office 2016

Reference and Citation Tools in Word

• Using Bookmarks
• Using Hyperlinks
• Creating Cross-references
• Creating Footnotes and Endnotes
• Inserting Citations and Bibliographies

Team Collaboration with Microsoft Word

• Tracking Changes
• Accept and Reject Changes
• Working with Comments
• Comparing and Merging Documents