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

Leave a Reply

Your email address will not be published. Required fields are marked *