Liwara 2, Ajman, UAE info@theunitedinstitute.com

Office Address

  • 2 Floor Bin Hamooda Building,
    Flat #208, Liwara 2, Near ABCD Bank
    Ajman, UAE
  • theunitedinstitute@gmail.com
  • +971 54 7899 234 ,0506016017

Our Courses

Microsoft Office

microsoft office pic

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.

Course Covers

Microsoft Word
  • Session 1: Getting Familiar
  • Session 2: Document Navigation Tips
  • Session 3: Manipulating Text
  • Session 4: Formatting Characters
  • Session 5: Formatting Paragraphs
  • Session 6: Themes and Templates
  • Session 7: Quick Parts
  • Session 8: Preparing Documents for Printing
  • Session 9: Organizing Content
  • Session 10: Tabs, Columns, and Charts
  • Session 11: Links, Headers, and Footers
  • Session 12: References
  • Session 13: Mail Merge
  • Session 14: Visual Content
  • Session 15: Reviewing Documents
  • Session 16: Protecting and Sharing Documents
Microsoft Excel
  • Session 1: Introduction
  • Session 2: Entering, Editing and Formatting Data
  • Session 3: Formatting Numbers
  • Session 4: Managing Worksheets
  • Session 5: Modifying Rows and Columns
  • Session 6: Understanding Formulas
  • Session 7: Changing Views
  • Session 8: AutoFill and Custom Lists
  • Session 9: Conditional Formatting
  • Session 10: Tables
  • Session 11: Data Tools
  • Session 12: Referencing Formulas
  • Session 13: Ranges and Dates
  • Session 14: Lookups
  • Session 15: Conditional Logic
  • Session 16: Text Formulas
  • Session 17: Introduction to Charts
  • Session 18: Formatting Charts
  • Session 19: Adding Graphics to Spreadsheets
  • Session 20: Outline, Sort, Filter, and Subtotal
  • Session 21: PivotTables
  • Session 22: Protecting Data
  • Session 23: Collaboration
  • Session 24: Printing
  • Session 25: Saving a Workbook
  • Session 26: Macros
Microsoft Powerpoint
  • Session 1: Introduction
  • Session 2: Entering, Editing and Formatting Data
  • Session 3: Formatting Numbers
  • Session 4: Managing Worksheets
  • Session 5: Modifying Rows and Columns
  • Session 6: Understanding Formulas
  • Session 7: Changing Views
  • Session 8: AutoFill and Custom Lists
  • Session 9: Conditional Formatting
  • Session 10: Tables
  • Session 11: Data Tools
  • Session 12: Referencing Formulas
  • Session 13: Ranges and Dates
  • Session 14: Lookups
  • Session 15: Conditional Logic
  • Session 16: Text Formulas
  • Session 17: Introduction to Charts
  • Session 18: Formatting Charts
  • Session 19: Adding Graphics to Spreadsheets
  • Session 20: Outline, Sort, Filter, and Subtotal
  • Session 21: PivotTables
  • Session 22: Protecting Data
  • Session 23: Collaboration
  • Session 24: Printing
  • Session 25: Saving a Workbook
  • Session 26: Macros
Microsoft Access
  • Session 1: Create and Modify Databases
  • Session 2: Manage Relationships and Keys
  • Session 3: Navigate through a Database
  • Session 4: Protect and Maintain Databases
  • Session 5: Print and Export Data
  • Session 6: Create Tables
  • Session 7: Manage Tables
  • Session 8: Manage Records in Tables
  • Session 9: Create and Modify Fields
  • Session 10: Create a Query
  • Session 11: Modify a Query
  • Session 12: Create Calculated Fields and Grouping within Queries
  • Session 13: Create a Form
  • Session 14: Configure Form Controls
  • Session 15: Format a Form
  • Session 16: Create a Report
  • Session 17: Configure Report Controls
  • Session 18: Format a Report


    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
Call Us Now
054-7727005 | 065464400