Microsoft Office Specialist: Excel Expert

Demonstrate that you have the skills needed to get the most out of Excel by earning the Microsoft Office Specialist: Excel Expert Certification. This certification demonstrates competency in creating, managing, and distributing professional spreadsheets for a variety of specialized purposes and situations.

An individual earning this certification has approximately 150 hours of instruction and hands-on experience with the product, has proven competency at an industry expert-level and is ready to enter into the job market. They can demonstrate the correct application of the principal features of Excel at an expert-level and can complete tasks independently.

Skills measured

  • Manage workbook options and settings
  • Manage and format data
  • Create advanced formulas and macros
  • Manage advanced charts and tables

Required exams: MO-201

Important: See details from Microsoft’s Certification site

Go to Certification Dashboard

NOTE: The bullets that appear below each of the skills measured are intended to illustrate how
skills are assessed. This list is not definitive or exhaustive.
NOTE: Eident’s Excel Training Courses cover all these features, but attendance on our Excel courses is not a guarantee of a pass. Self study prior to any examination is strongly recommended.

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(),
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
· manipulate options in existing PivotCharts
· apply styles to PivotCharts
· drill down into PivotChart details