Microsoft Office Specialist (MOS)

Reviews:

Training Program Description Training Course

Price:

1800 AED

Number of students:

300 students

Number of hours:

60 hours

Number of lessons:

20 lesson

Unit 1: Microsoft Word (MOS Word Associate / Expert)

Objective: Mastering the creation, editing, and professional formatting of text documents.

Basics Word:

Creating, opening, and saving documents.
User interface (Ribbon, Quick Access Toolbar).
Entering and editing text.

Text and Paragraph Formatting:

Changing fonts, sizes, colors, and effects.
Paragraph formatting (alignment, line and paragraph spacing, indents).
Using styles for consistent formatting.
Working with bulleted and numbered lists (Bullets & Numbering).

Inserting Objects:

Inserting pictures, shapes, symbols, and SmartArt.
Working with tables (creating, formatting, modifying).
Inserting headers and footers, and page numbers (Headers & Footers).

Page Layout and Printing:

Setting margins, orientation (portrait/landscape), and paper size.
Working with columns and breaks.
Previewing the document before printing and print options.

Advanced Features (Expert Level):

Working with long documents (indexes, tables of contents).
Mail Merge.
Track Changes and Comments.
Document protection (passwords, restrictions).
Document forms and content control.

Unit 2: Microsoft Excel (MOS Excel Associate / Expert)

Objective: Mastering data organization and analysis, and creating charts.

Excel Basics:

Creating, opening, and saving workbooks.
User interface (cells, sheets, ribbon).
Entering data (text, numbers, dates).

Working with Cells and Sheets:

Copying, cutting, and pasting data (with special paste options).
Formatting cells (numbers, dates, currencies).
Managing sheets (adding, deleting, renaming).

Basic Formulas and Functions:

Creating simple formulas (addition, subtraction, multiplication, division).
Using common functions (SUM, AVERAGE, MIN, MAX, COUNT).
Relative, absolute, and mixed references.

Data Analysis:

Sorting and filtering data (Sort & Filter).
Conditional Formatting.
Data Validation.

(Charts):

Creating different types of charts (bar, pie, line).
Formatting and customizing charts.

Advanced Features (Expert Level):

Logical functions (IF, AND, OR).
Lookup functions (VLOOKUP, HLOOKUP, XLOOKUP).
Working with large datasets (PivotTables & PivotCharts).
Data analysis using What-If Analysis.
Collaborating on workbooks and protecting them.
Creating simple macros using the recorder.

Unit 3: Microsoft PowerPoint (MOS PowerPoint Associate)

Objective: Mastering the creation and design of professional presentations.

PowerPoint Basics:

Creating, opening, and saving presentations.
User interface and slide management (Slides).

Entering and Formatting Content:

Adding and formatting text in slides.
Inserting pictures, shapes, and charts.
Working with SmartArt objects.

Presentation Design:

Applying templates and themes.
Customizing backgrounds.
Working with Slide Master to apply consistent design.

Animations and Transitions:

Applying animations to objects.
Applying transitions between slides.

Preparing the Presentation:

Slide Show setup.
Previewing the presentation.
Printing slides and handouts.

unit 4: Microsoft Outlook (MOS Outlook Associate)

Objective: Mastering email, calendar, and contacts management.

Outlook Basics:

Setting up email accounts.
User interface (Inbox, Calendar, Contacts).

Email Management:

Creating, sending, and receiving emails.
Managing attachments.
Organizing mail (folders, rules).
Using search.

(Calendar):

Creating appointments and meetings.
Managing and sharing calendars.
Setting reminders.

(Contacts):

Creating and editing contacts.
Organizing contacts into groups.

(Tasks & Notes):

Creating and managing tasks.
Using notes.

Unit 4: Microsoft Outlook (MOS Outlook Associate)

Objective: Mastering database design, creation, and data extraction.

Access Basics:

Database concepts (tables, relationships, forms, queries, reports).
Creating a new database.
User interface.

Creating Tables:

Designing tables and fields (Field Types, Primary Key).
Entering and editing data.

Working with Relationships:

Creating relationships between tables (One-to-Many, Many-to-Many).
Enforcing referential integrity.

(Forms):

Creating forms for data entry.
Customizing forms.

(Reports):

Create reports to display data.
Format the reports.