Excel Expert Certification Program

This Excel certification program will prepare you for the Microsoft Excel exam "Excel 2016 Expert: Interpreting Data for Insights." Learn formulas, functions, Pivot Tables, charts, and more, and ace the Microsoft Excel Expert exam.

Check out using "Flexible Scheduling" on the right. 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.

The Excel Expert Certification Program Includes

Beginner Microsoft Excel
Get going with the basics of Excel and start working on projects in Excel. Get practice with calculations and formulas, charts and tables, worksheet and workbook formatting, and basic hotkeys to accelerate your workflow.

Intermediate Microsoft Excel
Take your Excel skills up a level with this Intermediate Excel course. Learn important Excel functions like VLOOKUP, SUMIFs, and Pivot Tables in this hands-on training. You'll also learn crucial text-related features like splitting and joining text, removing duplicates, and data validation.

Advanced Microsoft Excel
Become an expert Excel user with this Advanced Excel course. Learn powerful functions like INDEX-MATCH, work with advanced Pivot Table functions, and start recording macros to automate workflows. Prepare yourself for any Excel challenge with this advanced Excel course.

Additional Items
This package also includes four hours of private training, the Microsoft Excel Expert Exam (with a free retake), and proctoring for the exam. Schedule the private training and exam after you complete the group classes.

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 encrypting 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

Learn more about Excel Expert Certification Program at NYC Career Centers.