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.

  • icon for small classesSmall classes
  • icon for small classesComputer provided
  • icon for small classesBook included
  • icon for small classesFree retake

Register for a Package 

$627 $1099 26 Hours PC provided 185 Madison Avenue, NYC In-person classroom training

Corporate training available

Email us for information

Custom Schedule
Register

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

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

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

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

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

Excel for Business Fundamentals

Wednesday, Sep 4, 10am–5pm

Intermediate Excel for Business

Wednesday, Sep 11, 10am–5pm

Advanced Excel for Business

Tuesday, Sep 24, 10am–5pm

Excel for Business Fundamentals

Tuesday, Sep 10, 10am–5pm

Intermediate Excel for Business

Wednesday, Sep 11, 10am–5pm

Advanced Excel for Business

Thursday, Sep 12, 10am–5pm

Excel for Business Fundamentals

Tuesday, Sep 10, 10am–5pm

Intermediate Excel for Business

Tuesday, Sep 17, 10am–5pm

Advanced Excel for Business

Tuesday, Sep 24, 10am–5pm

Excel for Business Fundamentals

Monday, Sep 16, 10am–5pm

Intermediate Excel for Business

Tuesday, Sep 17, 10am–5pm

Advanced Excel for Business

Tuesday, Sep 24, 10am–5pm

Excel for Business Fundamentals

Monday, Sep 16, 10am–5pm

Intermediate Excel for Business

Monday, Sep 23, 10am–5pm

Advanced Excel for Business

Tuesday, Sep 24, 10am–5pm

Excel for Business Fundamentals

Friday, Sep 20, 10am–5pm

Intermediate Excel for Business

Monday, Sep 23, 10am–5pm

Advanced Excel for Business

Tuesday, Sep 24, 10am–5pm

Excel for Business Fundamentals

Friday, Sep 20, 10am–5pm

Intermediate Excel for Business

Friday, Sep 27, 10am–5pm

Advanced Excel for Business

Friday, Oct 4, 10am–5pm

Excel for Business Fundamentals

Sunday, Sep 22, 10am–5pm

Intermediate Excel for Business

Sunday, Oct 6, 10am–5pm

Advanced Excel for Business

Sunday, Oct 13, 10am–5pm

Excel for Business Fundamentals

Mon–Tue, Sep 23–24, 6–9pm

Intermediate Excel for Business

Wed–Thu, Sep 25–26, 6–9pm

Advanced Excel for Business

Mon–Tue, Oct 7–8, 6–9pm

Excel for Business Fundamentals

Wednesday, Oct 2, 10am–5pm

Intermediate Excel for Business

Thursday, Oct 3, 10am–5pm

Advanced Excel for Business

Friday, Oct 4, 10am–5pm

Excel for Business Fundamentals

Saturday, Oct 5, 10am–5pm

Intermediate Excel for Business

Sunday, Oct 6, 10am–5pm

Advanced Excel for Business

Sunday, Oct 13, 10am–5pm

Excel for Business Fundamentals

Saturday, Oct 5, 10am–5pm

Intermediate Excel for Business

Saturday, Oct 19, 10am–5pm

Advanced Excel for Business

Saturday, Nov 9, 10am–5pm

Excel for Business Fundamentals

Tuesday, Oct 8, 10am–5pm

Intermediate Excel for Business

Thursday, Oct 10, 10am–5pm

Advanced Excel for Business

Wednesday, Oct 16, 10am–5pm

Excel for Business Fundamentals

Monday, Oct 14, 10am–5pm

Intermediate Excel for Business

Tuesday, Oct 15, 10am–5pm

Advanced Excel for Business

Wednesday, Oct 16, 10am–5pm

Excel for Business Fundamentals

Wed–Thu, Oct 16–17, 6–9pm

Intermediate Excel for Business

Wed–Thu, Oct 30–31, 6–9pm

Advanced Excel for Business

Wed–Thu, Nov 6–7, 6–9pm

Excel for Business Fundamentals

Friday, Oct 18, 10am–5pm

Intermediate Excel for Business

Monday, Oct 21, 10am–5pm

Advanced Excel for Business

Monday, Oct 28, 10am–5pm

Excel for Business Fundamentals

Sunday, Oct 20, 10am–5pm

Intermediate Excel for Business

Sunday, Nov 3, 10am–5pm

Advanced Excel for Business

Sunday, Dec 15, 10am–5pm

Excel for Business Fundamentals

Sunday, Oct 20, 10am–5pm

Intermediate Excel for Business

Sunday, Nov 3, 10am–5pm

Advanced Excel for Business

Saturday, Nov 9, 10am–5pm

Excel for Business Fundamentals

Thursday, Oct 24, 10am–5pm

Intermediate Excel for Business

Friday, Oct 25, 10am–5pm

Advanced Excel for Business

Monday, Oct 28, 10am–5pm

Excel for Business Fundamentals

Mon–Tue, Oct 28–29, 6–9pm

Intermediate Excel for Business

Mon–Tue, Nov 11–12, 6–9pm

Advanced Excel for Business

Mon–Tue, Dec 9–10, 6–9pm

Excel for Business Fundamentals

Mon–Tue, Oct 28–29, 6–9pm

Intermediate Excel for Business

Wed–Thu, Oct 30–31, 6–9pm

Advanced Excel for Business

Wed–Thu, Nov 6–7, 6–9pm

Excel for Business Fundamentals

Wednesday, Oct 30, 10am–5pm

Intermediate Excel for Business

Thursday, Oct 31, 10am–5pm

Advanced Excel for Business

Thursday, Nov 7, 10am–5pm

Excel for Business Fundamentals

Saturday, Nov 2, 10am–5pm

Intermediate Excel for Business

Saturday, Nov 16, 10am–5pm

Advanced Excel for Business

Sunday, Dec 15, 10am–5pm

Excel for Business Fundamentals

Saturday, Nov 2, 10am–5pm

Intermediate Excel for Business

Sunday, Nov 3, 10am–5pm

Advanced Excel for Business

Saturday, Nov 9, 10am–5pm

Excel for Business Fundamentals

Tuesday, Nov 5, 10am–5pm

Intermediate Excel for Business

Wednesday, Nov 6, 10am–5pm

Advanced Excel for Business

Thursday, Nov 7, 10am–5pm

Excel for Business Fundamentals

Monday, Nov 11, 10am–5pm

Intermediate Excel for Business

Tuesday, Nov 12, 10am–5pm

Advanced Excel for Business

Tuesday, Nov 19, 10am–5pm

Excel for Business Fundamentals

Wed–Thu, Nov 13–14, 6–9pm

Intermediate Excel for Business

Mon–Tue, Dec 2–3, 6–9pm

Advanced Excel for Business

Mon–Tue, Dec 9–10, 6–9pm

Excel for Business Fundamentals

Friday, Nov 15, 10am–5pm

Intermediate Excel for Business

Monday, Nov 18, 10am–5pm

Advanced Excel for Business

Tuesday, Nov 19, 10am–5pm

Excel for Business Fundamentals

Sunday, Nov 17, 10am–5pm

Intermediate Excel for Business

Sunday, Dec 8, 10am–5pm

Advanced Excel for Business

Sunday, Dec 15, 10am–5pm

Excel for Business Fundamentals

Wednesday, Nov 20, 10am–5pm

Intermediate Excel for Business

Thursday, Nov 21, 10am–5pm

Advanced Excel for Business

Wednesday, Dec 4, 10am–5pm

Excel for Business Fundamentals

Tuesday, Nov 26, 10am–5pm

Intermediate Excel for Business

Wednesday, Nov 27, 10am–5pm

Advanced Excel for Business

Wednesday, Dec 4, 10am–5pm

Excel for Business Fundamentals

Monday, Dec 2, 10am–5pm

Intermediate Excel for Business

Tuesday, Dec 3, 10am–5pm

Advanced Excel for Business

Wednesday, Dec 4, 10am–5pm

Excel for Business Fundamentals

Friday, Dec 6, 10am–5pm

Intermediate Excel for Business

Monday, Dec 9, 10am–5pm

Advanced Excel for Business

Monday, Dec 16, 10am–5pm

Excel for Business Fundamentals

Saturday, Dec 7, 10am–5pm

Intermediate Excel for Business

Sunday, Dec 8, 10am–5pm

Advanced Excel for Business

Sunday, Dec 15, 10am–5pm

Excel for Business Fundamentals

Thursday, Dec 12, 10am–5pm

Intermediate Excel for Business

Friday, Dec 13, 10am–5pm

Advanced Excel for Business

Monday, Dec 16, 10am–5pm

Excel for Business Fundamentals

Wednesday, Dec 18, 10am–5pm

Intermediate Excel for Business

Thursday, Dec 19, 10am–5pm

Advanced Excel for Business

Friday, Jan 3, 10am–5pm

Excel for Business Fundamentals

Monday, Dec 23, 10am–5pm

Intermediate Excel for Business

Friday, Dec 27, 10am–5pm

Advanced Excel for Business

Friday, Jan 3, 10am–5pm

Excel for Business Fundamentals

Monday, Dec 30, 10am–5pm

Intermediate Excel for Business

Thursday, Jan 2, 10am–5pm

Advanced Excel for Business

Friday, Jan 3, 10am–5pm

Show more packages

The Excel Expert Certification Program includes

Excel for Business Fundamentals

Master the core Microsoft Excel functions in this one-day course. Automate calculations and data entry. Apply formatting to text and cells to make your spreadsheet scannable and visually appealing. In this hands-on training, you will learn all the basics to use Excel as your primary data processing tool. You'll produce polished and print ready spreadsheets while learning tricks to accelerate your workflow.

Intermediate Excel for Business

Go from beginner to experienced professional: summarize data with Pivot Tables, write advanced functions including VLOOKUP, and learn techniques to expedite your workflow. Use tools and formulas to format text. Manipulate data visuals with advanced charting skills. Use statistical formulas like COUNTIFS and SUMIFS to learn more about your data. At the end of intermediate Excel, you'll unlock powerful techniques that will help you complete tasks more quickly.

Advanced Excel for Business

Advance your career with this essential course for professionals that use Excel daily. You'll make functions more flexible, take Pivot Tables to the next level, and automate tasks with macros. Utilize Excel's most important tools with training in core database functions. If you have a strong working knowledge in Excel and want to save even more time with custom shortcuts and advanced features, this is the perfect course for you. 

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