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 Specialist

microsoft office specialist pic

There are four specific reasons for which this course you can’t miss –
- First of all, at a professional level whatever functions and formula you need to work with, you will learn everything here and it includes not only basic functions but advanced functions as well.
- All you need to do this course is a computer/laptop and an internet connection. You can do this course at your pace, as per your convenience and as and when you would like to do it.
- This course is designed in such a way that you would get maximum retention after learning.
- You will also get lifetime access to the course materials. And you will also get verifiable certificate of completion for each course.

Course Covers

Core 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
Core 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
Core Microsoft Powerpoint
  • Session 1: Create a Presentation
  • Session 2: Insert and Format Slides
  • Session 3: Modify Slides, Handouts, and Notes
  • Session 4: Order and Group Slides
  • Session 5: Change Presentation Options and Views
  • Session 6: Configure a Presentation for Print
  • Session 7: Configure and Present a Slide Show
  • Session 8: Insert and Format Text
  • Session 9: Insert and Format Shapes and Text Boxes
  • Session 10: Insert and Format Images
  • Session 11: Order and Group Objects
  • Session 12: Insert and Format Tables
  • Session 13: Insert and Format Charts
  • Session 14: Insert and Format SmartArt graphics
  • Session 15: Insert and Manage Media
  • Session 16: Apply Slide Transitions
  • Session 17: Animate Slide Content
  • Session 18: Set Timing for Transitions and Animations
  • Session 19: Merge Content from Multiple Presentations
  • Session 20: Finalize Presentations
Core 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: Create a Presentation
  • 1.01 Create a new presentation
  • 1.02 Create a presentation based on a template
  • 1.03 Import Word document outlines
  • Session 2: Insert and Format Slides
  • 2.01 Insert specific slide layouts
  • 2.02 Duplicate existing slides
  • 2.03 Hide and unhide slides
  • 2.04 Delete slides
  • 2.05 Apply a different slide layout
  • 2.06 Modify individual slide backgrounds
  • 2.07 Inset slide headers, footers, and page numbers
  • Session 3: Modify Slides, Handouts, and Notes
  • 3.01 Change the slide master theme or background
  • 3.02 Modify slide master content
  • 3.03 Create a slide layout
  • 3.04 Modify a slide layout
  • 3.05 Modify the handout master
  • 3.06 Modify the notes master
  • Session 4: Order and Group Slides
  • 4.01 Create sections
  • 4.02 Modify slide order
  • 4.03 Rename sections
  • Session 5: Change Presentation Options and Views
  • 5.01 Change slide size
  • 5.02 Change views of a presentation
  • 5.03 Set file properties
  • Session 6: Configure a Presentation for Print
  • 6.01 Print all or part of a presentation
  • 6.02 Print notes pages
  • 6.03 Print handouts
  • 6.04 Print in color, grayscale, or black and white
  • Session 7: Configure and Present a Slide Show
  • 7.01 Create custom slide shows
  • 7.02 Configure slide show options
  • 7.03 Rehearse slide show timing
  • 7.04 Present a slide show by using Presenter View
  • Session 8: Insert and Format Text
  • 8.01 Insert text on a slide
  • 8.02 Apply formatting and styles to text
  • 8.03 Apply WordArt styles to text
  • 8.04 Format text in multiple columns
  • 8.05 Create bulleted and numbered lists
  • 8.06 Insert hyperlinks
  • Session 9: Insert and Format Shapes and Text Boxes
  • 9.01 Insert or replace shapes
  • 9.02 Insert text boxes
  • 9.03 Resize shapes and text boxes
  • 9.04 Format shapes and text boxes
  • 9.05 Apply styles to shapes and text boxes
  • Session 10: Insert and Format Images
  • 10.01 Insert images
  • 10.02 Resize and crop images
  • 10.03 Apply styles and effects
    Session 11: Order and Group Objects
  • 11.01 Order objects
  • 11.02 Align objects
  • 11.03 Group objects
  • 11.04 Display alignment tools
  • Session 12: Insert and Format Tables
  • 12.01 Create a table
  • 12.02 Insert and delete table rows and columns
  • 12.03 Apply table styles
  • 12.04 Import a table
  • Session 13: Insert and Format Charts
  • 13.01 Create a chart
  • 13.02 Import a chart
  • 13.03 Change the Chart Type
  • 13.04 Add a legend to a chart
  • 13.05 Change the chart style of a chart
  • Session 14: Insert and Format SmartArt graphics
  • 14.01 Create SmartArt graphics
  • 14.02 Convert lists to SmartArt graphics
  • 14.03 Add shapes to SmartArt graphics
  • 14.04 Reorder shapes in SmartArt graphics
  • 14.05 Change the color of SmartArt graphics
  • Session 15: Insert and Manage Media
  • 15.01 Insert audio and video clips
  • 15.02 Configure media playback options
  • 15.03 Adjust media window size
  • 15.04 Set the video start and stop time
  • 15.05 Set media timing options
  • Session 16: Apply Slide Transitions
  • 16.01 Insert slide transitions
  • 16.02 Set transition effect options
  • Session 17: Animate Slide Content
  • 17.01 Apply animations to objects
  • 17.02 Apply animations to text
  • 17.03 Set animation effect options
  • 17.04 Set animation paths
  • Session 18: Set Timing for Transitions and Animations
  • 18.01 Set transition effect duration
  • 18.02 Configure transition start and finish options
  • 18.03 Reorder animations on a slide
  • Session 19: Merge Content from Multiple Presentations
  • 19.01 Inset slides from another presentation
  • 19.02 Compare two presentations
  • 19.03 Insert comments
  • 19.4 Review comments
  • Session 20: Finalize Presentations
  • 20.01 Protect a presentation
  • 20.02 Inspect a presentation
  • 20.03 Proof a presentation
  • 20.04 Preserve presentation content
  • 20.05 Export presentations to other formats


    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