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

MS Excel Basic Training Course

MS Excel Basic Training Course in Ajman

In this course, you will learn the fundamentals of Excel and become an effective user. The course's target audience is those who have never used Excel before and those who are beginner-level users. You would need a copy of Microsoft Excel for Windows since you will be practicing along with the course.

MS Excel Basic-pic

As the course is targeting beginners, it has been developed to be very easy to follow. The course covers the topics that you would need to know to become a functional user. After this course, you will have mastered the most popular Excel tools and come out with the confidence to complete any Excel tasks with efficiency and grace.


Who this course is for:
• Never used Excel before
• Beginner level Excel user

What you’ll learn:
• Learn the fundamentals of Excel
• Become an effective user


United Excel Courses

Course Overview

    Session 1: Introduction:
  • 1.01 Introduction to Excel
  • 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 Number
  • 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 Copying Formula
  • 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: Tables
  • 9.01 Introduction
  • 9.02 Insert a Table and Style Options
  • 9.03 Add Rows and Columns
  • 9.04 Perform a Function in a Table
  • 9.05 Summarise With Pivot Table
  • Session 10: Introduction to Charts
  • 10.01 Introduction
  • 10.02 Chart Types
  • 10.03 Instant Chart
  • 10.04 Update Chart
  • 10.05 Column Chart
  • 10.06Picture Fill
  • 10.07 Adjust Chart Size
  • 10.08 Line Chart
  • 10.09 Scatter Chart
  • Session 11:Formatting Charts
  • 11.01 Introductions
  • 11.02 Chart Styles
  • 11.03 Chart Layouts
  • 11.04Add Labels
  • 11.05 Axis Options
  • 11.06 Chart Title
  • 11.07 Legends
  • 11.08 Data Labels
  • Session 12: Protecting Data
  • 12.01 Introductions
  • 12.02 Workbook Passwords
  • 12.03 Protecting Workbooks
  • 12.04 Unlocking Cells
  • Session 13: Printing
  • 13.01 Introductions
  • 13.02 Page Orientation
  • 13.03 Page Breaks
  • 13.04 Print Area
  • 13.05 Margins
  • 13.06 Print Titles
  • 13.07Headers and Footers
  • 13.08 Scaling
  • 13.09 Sheet Options
Call Us Now
054-7727005 | 065464400