MS Excel Specialist® 2019 (Certified by Microsoft)

Course overview

MS Excel Specialist® 2019 (Certified by Microsoft) demonstrates competency in creating, managing, and distributing professional spreadsheets for a variety of specialized purposes and situations. The exam covers the ability to customize Excel environments to meet project needs and to enhance productivity. Expert workbook examples include custom business templates, multiple-axis financial charts, amortization tables, and inventory schedules.

Table of content

Manage Worksheets and Workbooks

Import data into workbooks
Navigate within workbooks
Format worksheets and workbooks
Customize options and views
Configure content for collaboration

Manage Data Cells and Ranges

Manipulate data in worksheets
Format cells and ranges
Define and reference named ranges
Summarize data visually

Manage Table and Table Data

Create and format tables
Modify tables
Filter and sort table data

Perform Operations by using Formulas and Functions

Insert references
Calculate and transform data
Format and modify the text

Manage Charts

Create charts
Modify charts
Format charts

What you will learn?

Create, configure and save Excel worksheets and workbooks
Navigate through and format worksheets and workbooks
Customize options and views for worksheets and workbooks
Configure Excel worksheets and workbooks to print (e.g. page setup)
Insert data into and format cells and ranges, and create and modify tables
Highlight, filter, sort and group cells, ranges and tables
Create and format Excel charts
Insert and format objects, including modifying images
Create formulas in Excel, including using conditional logic and modifying text

Requirements

You should have the latest version of MS Excel installed on your computer.
Some prior knowledge of Excel will be helpful.

The Trainer:

Mr. Sarm Abbas is a Microsoft Office Specialist, Certified Master Trainer with more than 15 years of experience in IT training. Known for his creative and engaging teaching style, Mr. Sarm has multiple advanced certifications from Microsoft, COMP TIA, Certiport, and ITIL. He is a native Kurdish speaker, and fluent in both Arabic and English languages. He has offered IT courses to major oil companies and international organizations in Erbil and Sulaymaniyah.

What is the cost?

The cost will be $350 including the training sessions and preparation exam, final certification exam and refreshment.

When and where is the course being held?

Location: Erbil, mselect Office
Time: 14:00 - 19:00 pm

Payment:

Must be made 7 working days before the start of the course. Payment can be made in cash, by bank transfer or through exchange offices.

How do I register?

You can register by emailing training@mselect.com with the following details:

Full Name:
City/Town:
Email Address:
Phone number:
Name of course:

For more information, please call 066 261 4455 or 0771 842 2380.