Microsoft Office Specialist – Expert

Overview

This training allow you to have advanced skills in key Office programs, Word 2013 and Excel 2013.

By earning a Microsoft Office Specialist Expert certification. Office 2013 combines cloud and web technologies to extend the way you create and consume information and introduces a new cloud app model for you to build secure and flexible apps, all discoverable from the familiar Office interface

Prerequisites

# Taking Microsoft Office Specialist training

# MOS: Microsoft Office Specialist certification

Related Certifications

# 71-425 and 71-426 Exams: Microsoft Word 2013 Expert

# 71-427 and 71-428 Exams: Microsoft Excel 2013 Expert

Outline

Microsoft Word

Manage and share documents

# Manage multiple documents

# Prepare documents for review

# Manage document changes

 

Design advanced documents

# Apply advanced formatting

# Apply advanced styles

# Apply advanced ordering and grouping

 

Create advanced references

# Manage Mathematical formulas

# Create and manage indexes

# Create and manage reference tables

# Manage forms, fields, and mail merge operations

 

Create custom Word elements

# Create and modify building blocks

# Create custom style sets and templates

# Prepare a document for internationalization and accessibility

 

Microsoft Excel

Manage and share workbooks

# Manage multiple workbooks

# Prepare workbooks for review

# Manage workbook changes

 

Apply custom formats and layouts

#Apply custom data formats

# Apply advanced conditional formatting and filtering

# Apply custom styles and templates

# Prepare workbooks for internationalization and accessibility

 

Create advanced formulas

# Apply functions in formulas

# Lookup data by using functions

# Apply advanced date and time functions

# Create scenarios

 

Create advanced charts and tables

# Create advanced chart elements

# Create and manage PivotTables

# Create and manage PivotCharts

Hands-On Labs

Microsoft Word

Manage and share documents

# Lab 1: Manage multiple documents

# Lab 2: Manage document changes

 

Design advanced documents

# Lab 3: Apply advanced formatting and styles

# Lab 4: Apply advanced ordering and grouping

 

Create advanced references

# Lab 5: Manage Mathematical formulas

# Lab 6: manage reference tables

# Lab 7: Realize a Mail Merge

 

Create custom Word elements

# Lab 8: Create and modify building blocks

# Lab 9: Create custom style sets and templates

 

Microsoft Excel

Manage and share workbooks

# Lab 10: Manage multiple workbooks

# Lab 11: Layout & printing of workbooks

 

Apply custom formats and layouts

# Lab 12: Apply advanced conditional formatting and filtering

 

Create advanced formulas

# Lab 13: Apply functions in formulas

# Lab 14: Lookup data by using functions

 

Create advanced charts and tables

# Lab 15: Create advanced chart elements

# Lab 16: Create and manage PivotTables and PivotCharts

Duration

# 5 Days / 35 Hours

Pricing

# Student Price: 18 000 DA

# Regular Price: 40 000 DA

 

Register Now