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.
United Excel Courses
1
Basic MS Office
16 Hours
400 AED
2
Advanced MS Office
24 Hours
600 AED
3
Basic Excel Training Course
32 Hours
800 AED
4
Intermediate Excel Training Course
48 Hours
1200 AED
5
Advanced Excel Training Course
40 Hours
1000 AED
6
MS Excel Statistical Analysis Training Course
50 Hours
1500 AED
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
