UAE | NZ +971 65464400 | +971 506016017 | +64 22 4563165

Office Address

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

Our Courses

Microsoft Office

Excel in MS Office : Expert-Led Training Program

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 pic

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.

United Excel Courses



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