Home - Courses - IT Training Courses - postTitle –


Microsoft Office Professional Training Course

Microsoft Office is an office suite of desktop applications, servers and services for the Microsoft Windows and OS X operating systems. Microsoft Office dominates the office suite market, but it has faced stronger competition recently in the form of open source office suites.

  • About the Course
  • Certification Body
  • Download Brochure

Overview of the course:

The suite of products developed by Microsoft Corporation that includes Microsoft Word, Excel, Access, Publisher, PowerPoint, and Outlook. Each program serves a different purpose and is compatible with other programs included in the package. The suite of programs is compatible with both the Windows and Macintosh operating system. Microsoft Office is the most common form of software used in the world.

microsoft office course

Learning Outcome:

Demonstrate your expertise in using Excel, Outlook, Word, and other Microsoft Office applications.

  • Learn core skills in Office applications
  • Learn advanced skills in Word and Excel
  • Master across Office applications

Who needs the course?

This Microsoft Office Professional Training is recommended for Students, Job seekers, Housewives, Office Goers

Detailed Course Content:

According to the office systems, this certificate valuates the important and the required information technology skills and it is available with two levels, primary level and advanced level. This program is considered a speed and active way to gain skills in the major of Information Technology. As it is built on advanced experience, its main objective is to increase the ability level use computer system

Session 1

  • Session 2
  • What is Microsoft Office?
  • What are the Versions in Microsoft Office?
  • Microsoft Office edition comparison.
  • What are the applications have in Microsoft Office?
  • Using and customizing the Microsoft Office interface.

Session 2

  • Microsoft Office Word document interface
  • Document Views and zooming, Multiple Document
  • Windows
  • Entering, editing, and formatting text
  • Entering and selecting text
  • Inserting special characters
  • Date and time
  • Entering Hyperlinks
  • Applying text formatting
  • Working with styles
  • Cut, Copy and Paste
  • Using the clipboard with office programs
  • Using office themes

Session 3

  • Finding and replacing text and formatting
  • Navigating document
  • Checking spelling
  • Using tabs
  • Working with Illustrations and pictures, and WordArt

Session 4

  • Adding Headers and Footers , and Page Numbers

Session 5

  • Advanced Documentation
  • Formatting Columns and Sections
  • Working with Tables
  • Inserting References to other Parts of a Document
  • Drop Cap

Session 6

  • Mail Merge
  • Print a Document
  • Using Building Block, Auto Text
  • Comments
  • Tracking and Highlighting Changes Made to Document
  • Protecting a Document

Session 7

  • Managing Office Files
  • Supported file formats in Word 2010
  • Checking for compatibility with earlier office versions
  • Open and saving document
  • Using templates to streamline document creation
  • Organizing Microsoft Office documents using file
  • properties and details
  • Backup and recovery option
  • Restoring previous versions saved be auto recover

Session 8

  • Microsoft Office Excel Document and interface
  • Entering and Filling in Data and Series and Custom
  • List
  • Inserting and Hiding rows, columns and sheets
  • Using Formulas and Functions
  • Define Name
  • Cell references
  • Formatting cells and ranges, applying styles
  • Number formatting

Session 9

  • Mastering excel's Built in factions
  • Text, logical, financial, and lookup etc

Session 10

  • Chart and Data Analysis
  • Creating and customizing chart
  • Advanced Chart formatting options
  • Using conditional formatting

Session 11

  • Managing Lists and Data
  • Sorting, Filtering and outlining data
  • Creating and formatting Table

Session 12

  • Creating and customizing PivotTable Reports
  • Importing, exporting and connecting data sources

Session 13

  • Finding, Editing, moving, copying and paste special
  • Data validation
  • Customizing the worksheet view
  • Arranging worksheet windows
  • Splitting, freezing and locking panes
  • Printing a Worksheet
  • Advanced Protection for the document
  • Supported file formats in Excel 2010
  • Microsoft Office Power Point and interface
  • Entering the presentation text
  • Presentation View Options
  • Adding action buttons
  • Master View

Session 14

  • Adding Graphics and video Clips
  • Applying Themes
  • Adding backgrounds

Session 15

  • Adding Animations
  • Setting Animation timing and options
  • Using Transitions Between slides
  • Recording Narrations
  • Navigating in slide show view

Session 16

  • Printing presentations
  • Creating notes and handouts
  • Printing notes and handouts
  • Creating photo albums
  • Creating video from presentation
  • Supported file formats in Power Point 2010
  • Save options and compressing file

Session 17

  • Microsoft Office outlook and interface
  • Outlook items
  • E-mail Messages, Appointments, Meeting, Contacts
  • Task, Notes, Personalizing interface
  • Customizing the navigation pane
  • Organizing To-Do bar, Setting up mail accounts
  • Sending and receiving Messages
  • Managing contacts and groups

Session 18

  • Managing your calendar
  • Adding and editing email signature
  • Managing outlook data file and folders
  • Managing data files
  • Mastering outlook search
  • Using rules to Manage Message Automatically

Session 19

  • Setting follow-up flags and reminders
  • Sharing contacts and calendars items via- email
  • Working with meeting invitations
  • Importing and exporting outlook data
  • Archiving outlook data
  • Changing default formatting for new e-mail message

To know more about MS Office Professional, click here.

To know more about other courses in IT Academy, click here.

About Certification and Awarding Body

KHDA Certificate :

Course completion certificate attested by KHDA(Knowledge and Human Development Authority, UAE)

The Knowledge and Human Development Authority (KHDA) is responsible for the growth and quality of private education in Dubai. We support schools, universities, parents, students, educators, investors and government partners to create a high quality education sector focused on happiness and wellbeing.


For application process, please contact us.

Kindly fill the below details to download the Brochure

    Quick Enquiry