Excel Expert Certification

Boost your credentials today and achieve the Excel Expert Certification. NYIM offers the perfect Excel Expert Certification bundle which includes three Excel courses (fundamentals, intermediate, and advanced), four hours of private training, and the Expert Exam with a free retake. You'll also receive access to our premium video suite, the perfect resource to prepare for the exam.

1. Excel for Business Fundamentals group class with a Free Retake & revolutionary Beginner Excel video suite
2. Intermediate Excel for Business group class with a Free Retake & revolutionary Intermediate Excel video suite
3. Advanced Excel for Business group class with a Free Retake & revolutionary Advanced Excel video suite
4. Four hours of private training
5. Proctored Expert Certification exam with a free retake

Excel Expert Exam Topics

Our program will train you for the Microsoft Excel exam: 

Excel 2016 Expert: Interpreting Data for Insights

Here are the topics covered on the exam, from the Microsoft Excel Expert Certification page:

• Manage workbook options and settings:
  • Manage workbooks: Saving workbooks as templates, copying macros between workbooks, referencing data in other workbooks, structured references, enabling macros, displaying hidden ribbon tabs
  • Manage workbook review: Restrict editing, protecting worksheets, configuring formula calculation options, protecting workbook structure, managing versions, and encryting with passwords
• Apply custom data formats and layouts
  • Apply custom data formats and validation
  • Apply advanced conditional formatting and filtering
  • Create and modify custom workbook elements
  • Prepare a workbook for internalization
• Advanced Formulas
  • Logical operations including AND, OR, NOT, SUMIFS, AVERAGEIFS, and COUNTIFS
  • Lookup functions including VLOOKUP, HLOOKUP, INDEX and MATCH
  • What-if analysis using Goal Seek and Scenario Manager
  • Date and time functions
  • Financial functions
  • Troubleshoot formulas: trace precedents and dependents, monitor cells using the Watch Window, error checking, evaluate formulas
  • Defined named ranges: naming cells and ranges, managing names
• Advanced Charts & Tables
  • Add trendlines to charts, creating dual-axis charts, and saving chart templates
  • PivotTables: Creating PivotTables, modifying field selections and options, creating slicers, grouping PivotTable data, referencing data using GETPIVOTDATA, calculated field, and formatting data
  • PivotCharts: Creating PivotCharts, manipulating options, applying styles, and drilling down into details

How to register

Check out using the December 31st date. Once you've signed up, email us to schedule your three group classes, private training, and exam date. We offer weekday, weeknight, and weekend group classes and private training options, so you can work on your own schedule.

Email us for more information

© NYIM Training 2018