Excel Expert Certification Program
Excel Expert Certification Classes & Exam
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.
We also offer an Excel Specialist Certification Program.
Small classes
Computer provided
Book included
Free retake
Register for a Package
Customize your own schedule (choose dates at checkout), or choose a preset package track by expanding the start dates below.
We provide computers to use during class. This course is available on PC only.
Custom Schedule
August 23
Excel for Business Fundamentals
Friday, Aug 23, 10am–5pm
Intermediate Excel for Business
Friday, Aug 30, 10am–5pm
Advanced Excel for Business
Tuesday, Sep 3, 10am–5pm
August 23
Excel for Business Fundamentals
Friday, Aug 23, 10am–5pm
Intermediate Excel for Business
Monday, Aug 26, 10am–5pm
Advanced Excel for Business
Tuesday, Sep 3, 10am–5pm
August 29
Excel for Business Fundamentals
Thursday, Aug 29, 10am–5pm
Intermediate Excel for Business
Friday, Aug 30, 10am–5pm
Advanced Excel for Business
Tuesday, Sep 3, 10am–5pm
August 29
Excel for Business Fundamentals
Thursday, Aug 29, 10am–5pm
Intermediate Excel for Business
Thursday, Sep 5, 10am–5pm
Advanced Excel for Business
Thursday, Sep 12, 10am–5pm
September 4
Excel for Business Fundamentals
Wednesday, Sep 4, 10am–5pm
Intermediate Excel for Business
Thursday, Sep 5, 10am–5pm
Advanced Excel for Business
Thursday, Sep 12, 10am–5pm
The Excel Expert Certification Program includes
Excel for Business Fundamentals
Intermediate Excel for Business
Advanced Excel for Business
Additional Items
Excel Expert Certification in NYC
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