Microsoft Office is a set of desktop applications that offer flexible and powerful ways to organize, manage, and present information. Universally used in office settings, knowledge of Microsoft Office tools are a must for anyone in today's job market.
Microsoft Office training from United will help you or your team effectively utilize all the features of Microsoft Office products, and set you or your team up for Microsoft certifications, if desired. All of our trainers are Microsoft Certified.

Session 1: Getting Familiar

• 1.01 Introduction
• 1.02 Interface Overview
• 1.03 Common Buttons, Tabs and Ribbons

Session 2: Document Navigation Tips

• 2.01 Introduction
• 2.02 How Navigation Tips Help
• 2.03 Using The Slider
• 2.04 Keyboard Navigation Tips
• 2.05 Using Browse Objects Tools
• 2.06 Selecting Text Options

Session 3: Manipulating Text

• 3.01 Introduction
• 3.02 Page Layout
• 3.03 Cut, Copy, Paste, Move
• 3.04 Find and Replace

Session 4: Formatting Characters

• 4.01 Introduction
• 4.02 How Formatting Makes a Difference
• 4.03 Changing Fonts
• 4.04 Typical Text Format Options
• 4.05 Bullet and Numbered Lists
• 4.06 Other Formatting Tools

Session 5: Formatting Paragraphs

• 5.01 Introduction
• 5.02 Line Spacing
• 5.03 What Are Quick Styles
• 5.04 More Quick Styles
• 5.05 Creating A New Quick Style
• 5.06 Paragraph Marks

Session 6: Themes and Templates

• 6.01 Introduction
• 6.02 Applying Themes
• 6.03 Opening Existing Templates
• 6.04 Creating Templates
• 6.05 Working With Existing Content

Session 7: Quick Parts

• 7.01 Introduction
• 7.02 Quick Parts - Options
• 7.03 Creating Quick Parts
• 7.04 Quick Parts - Inserting Fields
• 7.05 Quick Parts - Inserting Images

Session 8: Preparing Documents for Printing

• 8.01 Introduction
• 8.02 Spelling and Grammar Check
• 8.03 Saving A Document
• 8.04 Printing And Preview Options

Session 9: Organizing Content

• 9.01 Introduction
• 9.02 Creating Lists
• 9.03 Creating and Formatting Tables
• 9.04 Converting Text To Tables
• 9.05 Table Borders and Shading

Session 10: Tabs, Columns, and Charts

• 10.01 Introduction
• 10.02 Creating Columns
• 10.03 Creating Tabular Lists
• 10.04 Creating Charts

Session 11: Links, Headers, and Footers

• 11.01 Introduction
• 11.02 Creating Web Links
• 11.03 Creating Document Location Links
• 11.04 Creating Email Links
• 11.05 Creating Headers and Footers

Session 12: References

• 12.01 Introduction
• 12.02 Bookmarks
• 12.03 Captions
• 12.04 Footnotes
• 12.05 Citations
• 12.06 Reference Styles for Research
• 12.07 Research Options
• 12.08 Creating Indexes
• 12.09 Bibliographies
• 12.10 Table of Figures
• 12.11 Table of Contents
• 12.12 Cross Reference Bookmarks
• 12.13 Cross Reference Page Numbers

Session 13: Mail Merge

• 13.01 Introduction
• 13.02 Mail Merge for Letters
• 13.03 Mail Merge for Envelopes
• 13.04 Mail Merge for Labels

Session 14: Visual Content

• 14.01 Introduction
• 14.02 Character Spacing
• 14.03 Inserting Shapes
• 14.04 Inserting Images
• 14.05 Using Word Art
• 14.06 Using Pull Quotes
• 14.07 Using Text Boxes
• 14.08 Sorting Text
• 14.09 Using Smart Art

Session 15: Reviewing Documents

• 15.01 Introduction
• 15.02 Document Views
• 15.03 Split Screen View
• 15.04 Tracking Changes
• 15.05 Collaboration Options
• 15.06 Combining and Approving Changes
• 15.07 Using Comments

Session 16: Protecting and Sharing Documents

• 16.01 Introduction
• 16.02 Compatibility Checker
• 16.03 Previous Word Versions Compatibility
• 16.04 Digital Signatures
• 16.05 Restricting Permissions

Session 1: Introduction

• 1.01 Introduction
• 1.02 Interface
• 1.03 Tabs and Ribbons
• 1.04 Document Windows
• 1.05 Navigation Tips
• 1.06 Office Button and Save

Session 2: Entering, Editing and Formatting Data

• 2.01 Introduction
• 2.02 Entering Data
• 2.03 Fonts, Fills, and Alignment
• 2.04 Cut, Copy, and Paste
• 2.05 Paste Special
• 2.06 Undo and Redo
• 2.07 Moving, Finding, and Replacing a Value
• 2.08 Cell Styles
• 2.09 Comments

Session 3: Formatting Numbers

• 3.01 Introduction
• 3.02 Currency Format
• 3.03 Format Painter
• 3.04 Formatting Dates
• 3.05 Custom and Special Formats

Session 4: Managing Worksheets

• 4.01 Introduction
• 4.02 Naming and Moving Worksheets
• 4.03 Copying Worksheets
• 4.04 Adding, Deleting and Hiding Worksheets
• 4.05 Grouping Worksheets
• 4.06 Moving, Copying, Deleting and Hiding Grouped Worksheets

Session 5: Modifying Rows and Columns

• 5.01 Introduction
• 5.02 Inserting and Deleting Columns and Rows
• 5.03 Inserting & Deleting Cells
• 5.04 Inserting Multiple Columns & Rows
• 5.05 Modifying Cell Width and Height
• 5.06 Hiding and Unhiding Rows and Columns

Session 6: Understanding Formulas

• 6.01 Introduction
• 6.02 Using Operations
• 6.03 Creating Formulas
• 6.04 AutoSum
• 6.05 Common Formulas
• 6.06 Searching for Formulas
• 6.07 Copying Formulas
• 6.08 Using Relative and Absolute References

Session 7: Changing Views

• 7.01 Introduction
• 7.02 Workbook Views
• 7.03 Show/Hide
• 7.04 Zoom Features
• 7.05 Freeze Panes
• 7.06 Split Windows
• 7.07 Viewing Multiple Windows
• 7.08 Minimize The Ribbon
• 7.09 Worksheet Backgrounds
• 7.10 Watermarks

Session 8: AutoFill and Custom Lists

• 8.01 Introduction
• 8.02 AutoFill a Series
• 8.03 AutoFill Non-Adjacent Cells
• 8.04 AutoFill on Multiple Sheets
• 8.05 Creating Custom Lists
• 8.06 Series Formatting

Session 9: Conditional Formatting

• 9.01 Introduction
• 9.02 Highlight Cells Rules
• 9.03 Top/Bottom Rules
• 9.04 Data Bars
• 9.05 Color Scales
• 9.06 Custom Formatting Rule

Session 10: Tables

• 10.01 Introduction
• 10.02 Insert a Table and Style Options
• 10.03 Add Rows and Columns
• 10.04 Perform a Function in a Table
• 10.05 Summarise With Pivot Table

Session 11: Data Tools

• 11.01 Introduction
• 11.02 Data Validation
• 11.03 Drop-Down Lists
• 11.04 Removing Duplicates
• 11.05 Text To Columns
• 11.06 Goal Seek
• 11.07 Scenario Manager

Session 12: Referencing Formulas

• 12.01 Introduction
• 12.02 Multiple Sheet References
• 12.03 Consolidating Data - With or Without Links
• 12.04 Trace the Precedents and Dependents
• 12.05 Using the Watch Window

Session 13: Ranges and Dates

• 13.01 Introduction
• 13.02 Cell Names
• 13.03 Named Ranges
• 13.04 Formulas with Cell Names
• 13.05 Date Formulas

Session 14: Lookups

• 14.01 Introduction
• 14.02 VLOOKUP
• 14.03 VLOOKUP Exact Match
• 14.04 HLOOKUP
• 14.05 HLOOKUP Exact Match

Session 15: Conditional Logic

• 15.01 Introduction
• 15.02 IF Statement
• 15.03 Nested IF
• 15.04 AND
• 15.05 OR
• 15.06 NOT
• 15.07 IFERROR
• 15.08 SUMIF
• 15.09 AVERAGEIF
• 15.10 COUNTIF & COUNTIFS
• 15.11 SUMIFS
• 15.12 AVERAGEIFS

Session 16: Text Formulas

• 16.01 Introduction
• 16.02 Case Formulas
• 16.03 Fix Number Fields
• 16.04 Trim Spaces
• 16.05 Substitute Text

Session 17: Introduction to Charts

• 17.01 Introduction
• 17.02 Chart Types
• 17.03 Instant Chart
• 17.04 Update Chart
• 17.05 Column Chart
• 17.06 Picture Fill
• 17.07 Adjust Chart Size
• 17.08 Line Chart
• 17.09 Scatter Chart

Session 18: Formatting Charts

• 18.01 Introduction
• 18.02 Chart Styles
• 18.03 Chart Layouts
• 18.04 Add Labels
• 18.05 Axis Options
• 18.06 Chart Title
• 18.07 Legends
• 18.08 Data Labels

Session 19: Adding Graphics to Spreadsheets

• 19.01 Introduction
• 19.02 Insert Pictures
• 19.03 Modifying Pictures
• 19.04 Insert Shapes
• 19.05 Insert SmartArt
• 19.06 Apply Themes
• 19.07 Arrange

Session 20: Outline, Sort, Filter, and Subtotal

• 20.01 Introduction
• 20.02 Group and Ungroup
• 20.03 Sort Data
• 20.04 Sort Multiple Levels
• 20.05 Filter Data
• 20.06 Advanced Filter
• 20.07 Conditional Sorting and Filtering
• 20.08 Sorting with Custom Lists
• 20.09 Subtotal

Session 21: PivotTables

• 21.01 Introduction
• 21.02 Creating PivotTables
• 21.03 Choosing Fields
• 21.04 PivotTable Layout
• 21.05 Filtering PivotTables
• 21.06 Modifying PivotTable Data
• 21.07 PivotCharts

Session 22: Protecting Data

• 22.01 Introduction
• 22.02 Workbook Passwords
• 22.03 Protecting Workbooks
• 22.04 Unlocking Cells

Session 23: Collaboration

• 23.01 Introduction
• 23.02 Document Properties
• 23.03 Inserting Hyperlinks
• 23.04 Sharing a Workbook
• 23.05 Track Changes
• 23.06 Accept/Reject Changes
• 23.07 Mark as Final

Session 24: Printing

• 24.01 Introduction
• 24.02 Page Orientation
• 24.03 Page Breaks
• 24.04 Print Area
• 24.05 Margins
• 24.06 Print Titles
• 24.07 Headers and Footers
• 24.08 Scaling
• 24.09 Sheet Options

Session 25: Saving a Workbook

• 25.01 Introduction
• 25.02 Save As Previous Version
• 25.03 AutoRecover Save Options
• 25.04 Templates
• 25.05 Save As PDF
• 25.06 Save As Web Page
• 25.07 Macro-Enabled Workbook

Session 26: Macros

• 26.01 Introduction and Macro Security
• 26.02 Recording a Macro
• 26.03 Assign a Macro to a Button or Shape
• 26.04 Run a Macro upon Opening a Workbook
• 26.05 How to Inspect and Modify a Macro

Session 1: Introduction to Microsoft PowerPoint

• 1.01 Create a New Presentation
• 1.02 Edit a Presentation in Normal View
• 1.03 Add Pictures to a Presentation
• 1.04 Print and view a Presentation
• 1.05 Edit an Existing Presentation
• 1.06 Format a Presentation
• 1.07 Use Slide Sorter View
• 1.08 Apply Slide Transitions

Session 2: Format PowerPoint Presentations

• 2.01 Format Numbered and Bulleted Lists
• 2.02 Insert Online Pictures
• 2.03 Insert Text Boxes and Shapes
• 2.04 Format Objects
• 2.05 Remove Picture Backgrounds and Insert WordArt
• 2.06 Create and Format a SmartArt Graphic

Session 3: Enhance a Presentation with Animation, Video, Table, and Charts

• 3.01 Customize Slide Backgrounds and Themes
• 3.02 Animate a Slide Show
• 3.03 Insert a video
• 3.04 Create and Modify Tables
• 3.05 Create and Modify Charts

Session 4: Format a Presentation Using Slide Masters; Review, Compare, Combine, and Protect Presentations.

• 4.01 Modify Slide Masters
• 4.02 Create a Custom Template
• 4.03 Create and Edit Comments
• 4.04 Compare and Combine Presentations
• 4.05 Prepare a Presentation for Distribution
• 4.06 Protect a Presentation

Session 5: Apply Advanced Graphic Techniques and Insert Audio and Video

• 5.01 Apply Picture Corrections
• 5.02 Add a Border to a Picture
• 5.03 Change the Shape of a Picture
• 5.04 Add a Picture to a WordArt Object and
  
  Merge Shapes
• 5.05 Enhance a Presentation with Audio and Video
• 5.06 Create a Photo Album
• 5.07 Edit a Photo Album and Add a Caption
• 5.08 Crop a Picture

Session 6: Deliver a Presentation

• 6.01 Apply and Modify Slide Transitions
• 6.02 Apply Custom Animation Effects
• 6.03 Modify Animation Effects
• 6.04 Insert Hyperlinks
• 6.05 Create Custom Slide Shows
• 6.06 Present and View a Slide Presentation

Session 7: Presentations Using Tables and Pie Charts

• 7.01 Add a Table to a Presentation
• 7.02 Add or Delete Table Rows, Columns, or Cells
• 7.03 Modify a Table
• 7.04 Insert a Section
• 7.05 Create Pie Charts
• 7.06 Modify Charts
• 7.07 Change a Chart Type

Session 8: Publish Presentations and Use Sway

• 8.01 Insert Outline Text from Another Program into
  
  a PowerPoint Presentation
• 8.02 Proof a Presentation
• 8.03 Format Text As Columns
• 8.04 Save a Presentation in Other Formats
• 8.05 Create a Sway Presentation
• 8.06 Add Content to a Sway Presentation

Session 1: Create and Modify Databases

• 1.01 Create a blank desktop database
• 1.02 Create a database from a template
• 1.03 Create a database by using Import objects or
  
  data from other sources
• 1.04 Delete database objects

Session 2: Manage Relationships and Keys

• 2.01 Create and modify relationships
• 2.02 Set the primary key
• 2.03 Enforce referential integrity
• 2.04 Set foreign keys
• 2.05 View relationships

Session 3: Navigate through a Database

• 3.01 Navigate specific records
• 3.02 Create and modify a navigation form
• 3.03 Set a form as the startup option
• 3.04 Display objects in the Navigation Pane
• 3.05 Change views of objects

Session 4: Protect and Maintain Databases

• 4.01 Compact a database
• 4.02 Repair a database
• 4.03 Back up a database
• 4.04 Split a database
• 4.05 Encrypt a database with a password
• 4.06 Recover data from backup

Session 5: Print and Export Data

• 5.01 Print reports
• 5.02 Print records
• 5.03 Save a database as a template
• 5.04 Export objects to alternative formats

Session 6: Create Tables

• 6.01 Create a table
• 6.02 Import data into tables
• 6.03 Create linked tables from external sources
• 6.04 Import tables from other databases
• 6.05 Create a table from a template with application
  
  parts

Session 7: Manage Tables

• 7.01 Hide fields in tables
• 7.02 Add total rows
• 7.03 Add table descriptions
• 7.04 Rename tables

Session 8: Manage Records in Tables

• 8.01 Update records
• 8.02 Add records
• 8.03 Delete records
• 8.04 Append records from external data
• 8.05 Find and replace data
• 8.06 Sort records
• 8.07 Filter records

Session 9: Create and Modify Fields

• 9.01 Add fields to tables
• 9.02 Add validation rules to fields
• 9.03 Change field captions
• 9.04 Change field sizes
• 9.05 Change field data types
• 9.06 Configure fields to auto-increment
• 9.07 Set default values
• 9.08 Using input masks
• 9.09 Delete fields

Session 10: Create a Query

• 10.01 Run a query
• 10.02 Create a crosstab query
• 10.03 Create a parameter query
• 10.04 Create an action query
• 10.05 Create a multi-table query
• 10.06 Save a query

Session 11: Modify a Query

• 11.01 Rename a query
• 11.02 Add fields
• 11.03 Remove fields
• 11.04 Hide fields
• 11.05 Sort data within queries
• 11.06 Format fields within queries

Session 12: Create Calculated Fields and Grouping within Queries

• 12.01 Add calculated fields
• 12.02 Set filtering criteria
• 12.03 Group and summarize data
• 12.04 Group data by using comparison operators
• 12.05 Group data by using arithmetic and logical
  
  operators

Session 13: Create a Form

• 13.01 Create a form
• 13.02 Create a form from a template with application
  
  parts
• 13.03 Save a form

Session 14: Configure Form Controls

• 14.01 Move form controls
• 14.02 Add form controls
• 14.03 Modify data sources
• 14.04 Remove form controls
• 14.05 Set form control properties
• 14.06 Manage labels
• 14.07 Add sub-forms

Session 15: Format a Form

• 15.01 Modify tab order
• 15.02 Configure Print settings
• 15.03 Sort records by form field
• 15.04 Apply a theme
• 15.05 Control form positioning
• 15.06 Insert backgrounds
• 15.07 Insert headers and footers
• 15.08 Insert images

Session 16: Create a Report

• 16.01 Create a report based on the query or table
• 16.02 Create a report in Design view
• 16.03 Create a report by using a wizard

Session 17: Configure Report Controls

• 17.01 Group and sort fields
• 17.02 Modify data sources
• 17.03 Add report controls
• 17.04 Add and modify labels

Session 18: Format a Report

• 18.01 Format a report into multiple columns
• 18.02 Add calculated fields
• 18.03 Control report positioning
• 18.04 Format report elements
• 18.05 Change report orientation
• 18.06 Insert header and footer information
• 18.07 Insert images
• 18.08 Apply a theme