asterisk-solid Coronavirus Update

window-close-line

Excel Expert Certification Program in NYC or Live Online

Get certified as an Excel Expert with this 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.

We also offer an Excel Specialist Certification Program.

Register for a Package  help-solid

tag-solid $1099 clock-solid 26 Hours map-marker-solid In-person: 185 Madison Ave, NYC cloud-line Also available live online

Corporate training available

Email us for information

  • Custom Schedule

  • Apr 9–23

    • Excel for Business Fundamentals

      Wednesday, Apr 8, 9am–4pm

    • Intermediate Excel for Business

      Thursday, Apr 16, 10am–5pm

    • Advanced Excel for Business

      Thursday, Apr 23, 10am–5pm

  • Apr 9–13

    • Excel for Business Fundamentals

      Wednesday, Apr 8, 9am–4pm

    • Intermediate Excel for Business

      Monday, Apr 13, 10am–5pm

    • Advanced Excel for Business

      Tuesday, Apr 14, 10am–5pm

  • Apr 15–23

    • Excel for Business Fundamentals

      Wednesday, Apr 15, 10am–5pm

    • Intermediate Excel for Business

      Thursday, Apr 16, 10am–5pm

    • Advanced Excel for Business

      Thursday, Apr 23, 10am–5pm

  • Apr 15–May 5

    • Excel for Business Fundamentals

      Wednesday, Apr 15, 10am–5pm

    • Intermediate Excel for Business

      Wednesday, Apr 22, 10am–5pm

    • Advanced Excel for Business

      Tuesday, May 5, 10am–5pm

  • Apr 21–23

    • Excel for Business Fundamentals

      Tuesday, Apr 21, 10am–5pm

    • Intermediate Excel for Business

      Wednesday, Apr 22, 10am–5pm

    • Advanced Excel for Business

      Thursday, Apr 23, 10am–5pm

Show more dates angle-line
Teacher helping student
Student reading workbook
Teacher pointing at whiteboard
  • book-solid

    Workbook Included

    Students get a custom workbook with step-by-step instructions.

  • display-solid

    Computer Provided

    Modern computer classroom with a PC for each student to work on.

  • users-solid

    Small In-Person Classes

    Get personalized attention in small groups with an expert instructor in the classroom.

  • redo-line

    Free Retake

    Refresh the course materials within six months for free as long as there's space in the class.

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.
help-solid

Frequently Asked Questions

  • Does this course require any prior knowledge or experience?

    Students must be comfortable using a computer. No other prior knowledge is required.

  • Do I need to bring a computer?

    No. We provide a computer with the necessary software for each attendee. This course is available on Windows PC only.

  • Are discounts available for this course?

    This program is a discounted package of classes that is 15–25% off the individual class prices.

  • Does this course come with a book?

    Yes. This course includes a complimentary book or manual at no additional cost.

  • What if I need to retake this course? May I retake it for free?

    Yes. You may retake this course for free once within six months, provided that the class is running with an available seat. For more information, visit our policies page.

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

Related Classes

Excel for Business Bootcamp

$549 21 Hours Apr 8–Apr 14

Excel Specialist Certification Program

$899 24 Hours Apr 9–Apr 13

Excel for Business Fundamentals

$219 7 Hours Apr 8, 9–4pm

Intermediate Excel for Business

$219 7 Hours Apr 13, 10–5pm
See all Excel classes