Blank

MS Excel Expert® 2019 (Certified by Microsoft)

Fee 425

Start

Sunday, 11 December 2022

End

Thursday, 15 December 2022

MS Excel Expert® 2019 (Certified by Microsoft)

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. The Expert workbook examples include custom business templates, multiple-axis financial charts, amortization tables, and inventory schedules. Candidates are expected to demonstrate the correct application of the principal features of Excel at an expert-level and complete tasks independently.

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 comments

Use and configure language options

  • configure editing and display languages

  • use language-specific features

Manage and format data

Fill cells based on existing data

  • fill cells by using Flash Fill

  • fill cells by using advanced Fill Series options

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 including the IF(), IFS(), SWITCH(), SUMIF(), AVERAGEIF(), COUNTIF(), SUMIFS(), AVERAGEIFS(), COUNTIFS(), MAXIFS(), MINIFS(), AND(), OR(), and NOT() functions

Look up data by using functions

  • look up data by using the VLOOKUP(), HLOOKUP(), MATCH(), and INDEX() functions

Use advanced date and time functions

  • reference date and time by using the NOW() and TODAY() functions

  • calculate dates by using the WEEKDAY() and WORKDAY() functions

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 by using the AND(), IF(), and NPER() functions

  • calculate financial data by using the PMT() function

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, Map, Sunburst, and Waterfall charts

Create and modify PivotTables

  • create PivotTables

  • modify field selections and options

  • create slicers

  • group PivotTable data

  • add calculated fields

  • format data

Create and modify PivotCharts

  • create PivotCharts

Learning objectives

  • Copying macros between workbooks

  • Protect worksheets and cell ranges

  • Configuring formula calculation options

  • Using advanced fill options

  • Configuring Data Validation

  • Creating custom conditional formatting rules

  • Troubleshooting formulas

  • Creating advanced charts

  • Creating and modifying PivotTables and PivotCharts

  • Analyze data with advanced formulas, including logical operators, lookups, date/time functions

  • Manage and format data with custom formats, autofill & flash fill, data validation, and conditional formatting

  • Explore data on the fly with PivotTables, Pivot Charts, slicers and timelines Customize workbook settings like protection & encryption, calculation modes, comments, and language

Why get certified as a Microsoft Excel Expert?

  1. Build powerful and practical skills to launch or accelerate your career

  2. Strengthen your resume and market yourself to potential employers

  3. 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, lunch & refreshment.

When and where is the course being held?

Location: Erbil, MSELECT Office

Time: 14:00 - 20:00

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:

  1. Full Name:

  2. City/Town:

  3. Email Address:

  4. Phone number:

  5. Name of course:

For more information, please call 066 261 4455