Excel Expert Certification Program

Excel Training & Expert Certification Exam in NYC

  • tag-solid $1099
  • clock-solid 26 Hours
  • display-solid PC provided help-solid
  • users-solid Small in-person class
  • repeat-line Free retake help-solid
  • map-marker-solid 185 Madison Avenue, NYC
All Microsoft Excel Courses 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.

We also offer an Excel Specialist Certification Program.

Upcoming Class Dates help-solid

  • Custom Schedule

  • Feb 29–Apr 4

    • Beginner Microsoft Excel

      Sat, Feb 29, 10am–5pm

    • Intermediate Microsoft Excel

      Sat, Mar 14, 10am–5pm

    • Advanced Microsoft Excel

      Sat, Apr 4, 10am–5pm

  • Feb 29–Mar 8

    • Beginner Microsoft Excel

      Sat, Feb 29, 10am–5pm

    • Intermediate Microsoft Excel

      Sun, Mar 1, 10am–5pm

    • Advanced Microsoft Excel

      Sun, Mar 8, 10am–5pm

  • Mar 2–20

    • Beginner Microsoft Excel

      Mon, Mar 2, 10am–5pm

    • Intermediate Microsoft Excel

      Mon, Mar 9, 10am–5pm

    • Advanced Microsoft Excel

      Fri, Mar 20, 10am–5pm

  • Mar 2–10

    • Beginner Microsoft Excel

      Mon, Mar 2, 10am–5pm

    • Intermediate Microsoft Excel

      Tue, Mar 3, 10am–5pm

    • Advanced Microsoft Excel

      Tue, Mar 10, 10am–5pm

  • Mar 2–Apr 9

    • Beginner Microsoft Excel

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

    • Intermediate Microsoft Excel

      Mon–Tue, Mar 16–17, 6–9pm

    • Advanced Microsoft Excel

      Mon–Tue, Apr 6–7, 6–9pm

  • Mar 2–10

    • Beginner Microsoft Excel

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

    • Intermediate Microsoft Excel

      Wed–Thu, Mar 4–5, 6–9pm

    • Advanced Microsoft Excel

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

  • Mar 6–10

    • Beginner Microsoft Excel

      Fri, Mar 6, 10am–5pm

    • Intermediate Microsoft Excel

      Mon, Mar 9, 10am–5pm

    • Advanced Microsoft Excel

      Tue, Mar 10, 10am–5pm

  • Mar 12–20

    • Beginner Microsoft Excel

      Thu, Mar 12, 10am–5pm

    • Intermediate Microsoft Excel

      Fri, Mar 13, 10am–5pm

    • Advanced Microsoft Excel

      Fri, Mar 20, 10am–5pm

  • Mar 15–Apr 4

    • Beginner Microsoft Excel

      Sun, Mar 15, 10am–5pm

    • Intermediate Microsoft Excel

      Sun, Mar 29, 10am–5pm

    • Advanced Microsoft Excel

      Sat, Apr 4, 10am–5pm

  • Mar 18–20

    • Beginner Microsoft Excel

      Wed, Mar 18, 10am–5pm

    • Intermediate Microsoft Excel

      Thu, Mar 19, 10am–5pm

    • Advanced Microsoft Excel

      Fri, Mar 20, 10am–5pm

Show more dates angle-line
Corporate training classroom
Career Centers teacher helping a student

Looking for corporate training?

We offer custom onsite training and discounted class vouchers.

envelope-solid nyc@careercenters.com
phone-handset-solid 212 • 684 • 5151

The Excel Expert Certification Program Includes

Beginner Microsoft Excel

Complete beginners and novice users will learn Excel basics in this course. Get practice with calculations and formulas, charts and tables, worksheet and workbook formatting, and basic hotkeys to accelerate your workflow. You'll be well-versed in Excel fundamentals by the end of this course.

Intermediate Microsoft Excel

Excel beginners will accelerate their skills quickly in Intermediate Excel. Learn how to navigate the workbook with your keyboard, create dropdowns, and merge/split the text into new cells.  By the end of the course, you’ll know the most crucial Excel features like Pivot Tables, Data Validation, and VLOOKUP. 

Advanced Microsoft Excel

Experienced Excel users will go from average to expert by the end of this class. Discover INDEX-MATCH, advanced Pivot Table functions, recording macros to automate tasks, and advanced database functions and analysis tools to be prepared for any Excel challenge on the job.

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