Course overview

Earn official Microsoft Office Specialist (MOS) certification in Excel Expert to differentiate yourself in today's competitive job market.

The course covers the ability to customize Excel environments to meet project needs and to enhance productivity. As a candidate for this certification, you showcase your proficiency in utilizing the advanced features of Excel (Microsoft 365 Apps). This includes creating, managing, and distributing professional spreadsheets and workbooks tailored for various specialized tasks and scenarios. Additionally, you demonstrate the ability to customize Excel environments to optimize project requirements and boost productivity.

Expert workbook examples include:

• Custom business templates

• Multiple-axis financial charts

• Amortization tables

• Inventory schedules

​

Table of content

​

​Manage workbook options and settings

​

Manage workbooks

• Copy macros between workbooks

• Reference data in other workbooks

• Enable macros in a workbook

• Manage workbook versions

Prepare workbooks for collaboration

• Restrict editing

• Protect worksheets and cell ranges

• Protect workbook structure

• Configure formula calculation options

​

Manage and format data

• Fill cells based on existing data

• Fill cells by using Flash Fill

• Fill cells by using advanced Fill Series options

• Generate numeric data by using RANDARRAY()

Format and validate data

• Create custom number formats

• Configure data validation

• Group and ungroup data

• Calculate data by inserting subtotals and totals

• Remove duplicate records

Apply advanced conditional formatting and filtering

• Create custom conditional formatting rules

• Create conditional formatting rules that use formulas

• Manage conditional formatting rules

​

Create advanced formulas and macros

Perform logical operations in formulas

• Perform logical operations by using nested functions

Look up data by using functions

• Look up data by using the functions

• Use advanced date and time functions

• Reference date and time

• Calculate dates

Perform data analysis

• Summarize data from multiple ranges by using the Consolidate feature

• Perform what-if analysis by using Goal Seek and Scenario Manager

• Forecast data

• Calculate financial data

• Filter data

• Sort data

Troubleshoot formulas

• Trace precedence and dependence

• Monitor cells and formulas by using the Watch Window

• Validate formulas by using error checking rules

• Evaluate formulas

Create and modify simple macros

• Record simple macros

• Name simple macros

• Edit simple macros

Manage advanced charts and tables

Create and modify advanced charts

• Create and modify dual-axis charts

• Create and modify charts including Box & Whisker, Combo, Funnel, Histogram, Sunburst, and Waterfall charts

Create and modify PivotTables

• Create PivotTables

• Modify field selections and options

• Create slicers

• Group PivotTable data

• Add calculated fields

• Configure value field settings

Create and modify PivotCharts

• Create PivotCharts

• Manipulate options in existing PivotCharts

• Apply styles to PivotCharts

• Drill down into PivotChart details

​

Why get certified as a Microsoft Excel Expert?

• Build powerful and practical skills to launch or accelerate your career

• Strengthen your resume and market yourself to potential employers

• Earn a highly coveted and prestigious credential, certified by Microsoft

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 $425 including the training sessions and preparation exam, final certification exam,& refreshment.

​

When and where is the course being held?

• Location: Erbil, mselect Office

• Time: 14:00 - 19:00

• Refreshments - included

• Duration: 5 days

​

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

​