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.
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. Zabeel Institute is considered as the best training institute in Dubai for Microsoft Office Professional 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.
Zabeel international institute of management technology Offer High Demand in IT Courses and technology management industry. We are one of the Top ranking training institute in Dubai .
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