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. Word is a word processing program that allows users to create and edit text documents. Excel is a spreadsheet program used for data analysis and visualization. PowerPoint is a presentation program used to create slideshows for business or academic presentations.
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