Excel Expert Certification Program
Excel Training & Expert Certification Exam in NYC
- $627 $1099
- 26 Hours
-
PC provided
We provide computers to use during class. This course is available on PC only.
- Small in-person class
-
Free retake
Students may retake the course once within six months if there is an available seat.
- 185 Madison Avenue, NYC
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
Customize your own schedule (choose dates at checkout), or choose a preset package track by expanding the dates below.
-
Custom Schedule
-
Aug 29–Sep 12
-
Beginner Microsoft Excel
Thu, Aug 29, 10am–5pm
-
Intermediate Microsoft Excel
Thu, Sep 5, 10am–5pm
-
Advanced Microsoft Excel
Thu, Sep 12, 10am–5pm
-
-
Aug 29–Sep 3
-
Beginner Microsoft Excel
Thu, Aug 29, 10am–5pm
-
Intermediate Microsoft Excel
Fri, Aug 30, 10am–5pm
-
Advanced Microsoft Excel
Tue, Sep 3, 10am–5pm
-
-
Sep 4–12
-
Beginner Microsoft Excel
Wed, Sep 4, 10am–5pm
-
Intermediate Microsoft Excel
Thu, Sep 5, 10am–5pm
-
Advanced Microsoft Excel
Thu, Sep 12, 10am–5pm
-
-
Sep 4–24
-
Beginner Microsoft Excel
Wed, Sep 4, 10am–5pm
-
Intermediate Microsoft Excel
Wed, Sep 11, 10am–5pm
-
Advanced Microsoft Excel
Tue, Sep 24, 10am–5pm
-
-
Sep 10–12
-
Beginner Microsoft Excel
Tue, Sep 10, 10am–5pm
-
Intermediate Microsoft Excel
Wed, Sep 11, 10am–5pm
-
Advanced Microsoft Excel
Thu, Sep 12, 10am–5pm
-
-
Sep 10–24
-
Beginner Microsoft Excel
Tue, Sep 10, 10am–5pm
-
Intermediate Microsoft Excel
Tue, Sep 17, 10am–5pm
-
Advanced Microsoft Excel
Tue, Sep 24, 10am–5pm
-
-
Sep 16–24
-
Beginner Microsoft Excel
Mon, Sep 16, 10am–5pm
-
Intermediate Microsoft Excel
Tue, Sep 17, 10am–5pm
-
Advanced Microsoft Excel
Tue, Sep 24, 10am–5pm
-
-
Sep 16–24
-
Beginner Microsoft Excel
Mon, Sep 16, 10am–5pm
-
Intermediate Microsoft Excel
Mon, Sep 23, 10am–5pm
-
Advanced Microsoft Excel
Tue, Sep 24, 10am–5pm
-
-
Sep 20–Oct 4
-
Beginner Microsoft Excel
Fri, Sep 20, 10am–5pm
-
Intermediate Microsoft Excel
Fri, Sep 27, 10am–5pm
-
Advanced Microsoft Excel
Fri, Oct 4, 10am–5pm
-
-
Sep 20–24
-
Beginner Microsoft Excel
Fri, Sep 20, 10am–5pm
-
Intermediate Microsoft Excel
Mon, Sep 23, 10am–5pm
-
Advanced Microsoft Excel
Tue, Sep 24, 10am–5pm
-
-
Sep 22–Oct 13
-
Beginner Microsoft Excel
Sun, Sep 22, 10am–5pm
-
Intermediate Microsoft Excel
Sun, Oct 6, 10am–5pm
-
Advanced Microsoft Excel
Sun, Oct 13, 10am–5pm
-
-
Sep 23–Oct 8
-
Beginner Microsoft Excel
Mon–Tue, Sep 23–24, 6–9pm
-
Intermediate Microsoft Excel
Wed–Thu, Sep 25–26, 6–9pm
-
Advanced Microsoft Excel
Mon–Tue, Oct 7–8, 6–9pm
-
-
Oct 2–4
-
Beginner Microsoft Excel
Wed, Oct 2, 10am–5pm
-
Intermediate Microsoft Excel
Thu, Oct 3, 10am–5pm
-
Advanced Microsoft Excel
Fri, Oct 4, 10am–5pm
-
-
Oct 5–Nov 9
-
Beginner Microsoft Excel
Sat, Oct 5, 10am–5pm
-
Intermediate Microsoft Excel
Sat, Oct 19, 10am–5pm
-
Advanced Microsoft Excel
Sat, Nov 9, 10am–5pm
-
-
Oct 5–13
-
Beginner Microsoft Excel
Sat, Oct 5, 10am–5pm
-
Intermediate Microsoft Excel
Sun, Oct 6, 10am–5pm
-
Advanced Microsoft Excel
Sun, Oct 13, 10am–5pm
-
-
Oct 8–16
-
Beginner Microsoft Excel
Tue, Oct 8, 10am–5pm
-
Intermediate Microsoft Excel
Thu, Oct 10, 10am–5pm
-
Advanced Microsoft Excel
Wed, Oct 16, 10am–5pm
-
-
Oct 14–16
-
Beginner Microsoft Excel
Mon, Oct 14, 10am–5pm
-
Intermediate Microsoft Excel
Tue, Oct 15, 10am–5pm
-
Advanced Microsoft Excel
Wed, Oct 16, 10am–5pm
-
-
Oct 16–Nov 7
-
Beginner Microsoft Excel
Wed–Thu, Oct 16–17, 6–9pm
-
Intermediate Microsoft Excel
Wed–Thu, Oct 30–31, 6–9pm
-
Advanced Microsoft Excel
Wed–Thu, Nov 6–7, 6–9pm
-
-
Oct 18–28
-
Beginner Microsoft Excel
Fri, Oct 18, 10am–5pm
-
Intermediate Microsoft Excel
Mon, Oct 21, 10am–5pm
-
Advanced Microsoft Excel
Mon, Oct 28, 10am–5pm
-
-
Oct 20–Dec 15
-
Beginner Microsoft Excel
Sun, Oct 20, 10am–5pm
-
Intermediate Microsoft Excel
Sun, Nov 3, 10am–5pm
-
Advanced Microsoft Excel
Sun, Dec 15, 10am–5pm
-
-
Custom Schedule
-
Aug 29–Sep 12
-
Beginner Microsoft Excel
Thu, Aug 29, 10am–5pm
-
Intermediate Microsoft Excel
Thu, Sep 5, 10am–5pm
-
Advanced Microsoft Excel
Thu, Sep 12, 10am–5pm
-
-
Aug 29–Sep 3
-
Beginner Microsoft Excel
Thu, Aug 29, 10am–5pm
-
Intermediate Microsoft Excel
Fri, Aug 30, 10am–5pm
-
Advanced Microsoft Excel
Tue, Sep 3, 10am–5pm
-
-
Sep 4–12
-
Beginner Microsoft Excel
Wed, Sep 4, 10am–5pm
-
Intermediate Microsoft Excel
Thu, Sep 5, 10am–5pm
-
Advanced Microsoft Excel
Thu, Sep 12, 10am–5pm
-
-
Sep 4–24
-
Beginner Microsoft Excel
Wed, Sep 4, 10am–5pm
-
Intermediate Microsoft Excel
Wed, Sep 11, 10am–5pm
-
Advanced Microsoft Excel
Tue, Sep 24, 10am–5pm
-
-
Sep 10–12
-
Beginner Microsoft Excel
Tue, Sep 10, 10am–5pm
-
Intermediate Microsoft Excel
Wed, Sep 11, 10am–5pm
-
Advanced Microsoft Excel
Thu, Sep 12, 10am–5pm
-
-
Sep 10–24
-
Beginner Microsoft Excel
Tue, Sep 10, 10am–5pm
-
Intermediate Microsoft Excel
Tue, Sep 17, 10am–5pm
-
Advanced Microsoft Excel
Tue, Sep 24, 10am–5pm
-
-
Sep 16–24
-
Beginner Microsoft Excel
Mon, Sep 16, 10am–5pm
-
Intermediate Microsoft Excel
Tue, Sep 17, 10am–5pm
-
Advanced Microsoft Excel
Tue, Sep 24, 10am–5pm
-
-
Sep 16–24
-
Beginner Microsoft Excel
Mon, Sep 16, 10am–5pm
-
Intermediate Microsoft Excel
Mon, Sep 23, 10am–5pm
-
Advanced Microsoft Excel
Tue, Sep 24, 10am–5pm
-
-
Sep 20–Oct 4
-
Beginner Microsoft Excel
Fri, Sep 20, 10am–5pm
-
Intermediate Microsoft Excel
Fri, Sep 27, 10am–5pm
-
Advanced Microsoft Excel
Fri, Oct 4, 10am–5pm
-
-
Sep 20–24
-
Beginner Microsoft Excel
Fri, Sep 20, 10am–5pm
-
Intermediate Microsoft Excel
Mon, Sep 23, 10am–5pm
-
Advanced Microsoft Excel
Tue, Sep 24, 10am–5pm
-
-
Oct 2–4
-
Beginner Microsoft Excel
Wed, Oct 2, 10am–5pm
-
Intermediate Microsoft Excel
Thu, Oct 3, 10am–5pm
-
Advanced Microsoft Excel
Fri, Oct 4, 10am–5pm
-
-
Oct 8–16
-
Beginner Microsoft Excel
Tue, Oct 8, 10am–5pm
-
Intermediate Microsoft Excel
Thu, Oct 10, 10am–5pm
-
Advanced Microsoft Excel
Wed, Oct 16, 10am–5pm
-
-
Oct 14–16
-
Beginner Microsoft Excel
Mon, Oct 14, 10am–5pm
-
Intermediate Microsoft Excel
Tue, Oct 15, 10am–5pm
-
Advanced Microsoft Excel
Wed, Oct 16, 10am–5pm
-
-
Oct 18–28
-
Beginner Microsoft Excel
Fri, Oct 18, 10am–5pm
-
Intermediate Microsoft Excel
Mon, Oct 21, 10am–5pm
-
Advanced Microsoft Excel
Mon, Oct 28, 10am–5pm
-
-
Oct 24–28
-
Beginner Microsoft Excel
Thu, Oct 24, 10am–5pm
-
Intermediate Microsoft Excel
Fri, Oct 25, 10am–5pm
-
Advanced Microsoft Excel
Mon, Oct 28, 10am–5pm
-
-
Oct 30–Nov 7
-
Beginner Microsoft Excel
Wed, Oct 30, 10am–5pm
-
Intermediate Microsoft Excel
Thu, Oct 31, 10am–5pm
-
Advanced Microsoft Excel
Thu, Nov 7, 10am–5pm
-
-
Nov 5–7
-
Beginner Microsoft Excel
Tue, Nov 5, 10am–5pm
-
Intermediate Microsoft Excel
Wed, Nov 6, 10am–5pm
-
Advanced Microsoft Excel
Thu, Nov 7, 10am–5pm
-
-
Nov 11–19
-
Beginner Microsoft Excel
Mon, Nov 11, 10am–5pm
-
Intermediate Microsoft Excel
Tue, Nov 12, 10am–5pm
-
Advanced Microsoft Excel
Tue, Nov 19, 10am–5pm
-
-
Nov 15–19
-
Beginner Microsoft Excel
Fri, Nov 15, 10am–5pm
-
Intermediate Microsoft Excel
Mon, Nov 18, 10am–5pm
-
Advanced Microsoft Excel
Tue, Nov 19, 10am–5pm
-
-
Nov 20–Dec 4
-
Beginner Microsoft Excel
Wed, Nov 20, 10am–5pm
-
Intermediate Microsoft Excel
Thu, Nov 21, 10am–5pm
-
Advanced Microsoft Excel
Wed, Dec 4, 10am–5pm
-
-
Custom Schedule
-
Sep 23–Oct 8
-
Beginner Microsoft Excel
Mon–Tue, Sep 23–24, 6–9pm
-
Intermediate Microsoft Excel
Wed–Thu, Sep 25–26, 6–9pm
-
Advanced Microsoft Excel
Mon–Tue, Oct 7–8, 6–9pm
-
-
Oct 16–Nov 7
-
Beginner Microsoft Excel
Wed–Thu, Oct 16–17, 6–9pm
-
Intermediate Microsoft Excel
Wed–Thu, Oct 30–31, 6–9pm
-
Advanced Microsoft Excel
Wed–Thu, Nov 6–7, 6–9pm
-
-
Oct 28–Nov 7
-
Beginner Microsoft Excel
Mon–Tue, Oct 28–29, 6–9pm
-
Intermediate Microsoft Excel
Wed–Thu, Oct 30–31, 6–9pm
-
Advanced Microsoft Excel
Wed–Thu, Nov 6–7, 6–9pm
-
-
Oct 28–Dec 10
-
Beginner Microsoft Excel
Mon–Tue, Oct 28–29, 6–9pm
-
Intermediate Microsoft Excel
Mon–Tue, Nov 11–12, 6–9pm
-
Advanced Microsoft Excel
Mon–Tue, Dec 9–10, 6–9pm
-
-
Nov 13–Dec 10
-
Beginner Microsoft Excel
Wed–Thu, Nov 13–14, 6–9pm
-
Intermediate Microsoft Excel
Mon–Tue, Dec 2–3, 6–9pm
-
Advanced Microsoft Excel
Mon–Tue, Dec 9–10, 6–9pm
-
-
Custom Schedule
-
Sep 22–Oct 13
-
Beginner Microsoft Excel
Sun, Sep 22, 10am–5pm
-
Intermediate Microsoft Excel
Sun, Oct 6, 10am–5pm
-
Advanced Microsoft Excel
Sun, Oct 13, 10am–5pm
-
-
Oct 5–13
-
Beginner Microsoft Excel
Sat, Oct 5, 10am–5pm
-
Intermediate Microsoft Excel
Sun, Oct 6, 10am–5pm
-
Advanced Microsoft Excel
Sun, Oct 13, 10am–5pm
-
-
Oct 5–Nov 9
-
Beginner Microsoft Excel
Sat, Oct 5, 10am–5pm
-
Intermediate Microsoft Excel
Sat, Oct 19, 10am–5pm
-
Advanced Microsoft Excel
Sat, Nov 9, 10am–5pm
-
-
Oct 20–Nov 9
-
Beginner Microsoft Excel
Sun, Oct 20, 10am–5pm
-
Intermediate Microsoft Excel
Sun, Nov 3, 10am–5pm
-
Advanced Microsoft Excel
Sat, Nov 9, 10am–5pm
-
-
Oct 20–Dec 15
-
Beginner Microsoft Excel
Sun, Oct 20, 10am–5pm
-
Intermediate Microsoft Excel
Sun, Nov 3, 10am–5pm
-
Advanced Microsoft Excel
Sun, Dec 15, 10am–5pm
-
-
Nov 2–9
-
Beginner Microsoft Excel
Sat, Nov 2, 10am–5pm
-
Intermediate Microsoft Excel
Sun, Nov 3, 10am–5pm
-
Advanced Microsoft Excel
Sat, Nov 9, 10am–5pm
-
-
Nov 2–Dec 15
-
Beginner Microsoft Excel
Sat, Nov 2, 10am–5pm
-
Intermediate Microsoft Excel
Sat, Nov 16, 10am–5pm
-
Advanced Microsoft Excel
Sun, Dec 15, 10am–5pm
-
-
Nov 17–Dec 15
-
Beginner Microsoft Excel
Sun, Nov 17, 10am–5pm
-
Intermediate Microsoft Excel
Sun, Dec 8, 10am–5pm
-
Advanced Microsoft Excel
Sun, Dec 15, 10am–5pm
-
-
Dec 7–15
-
Beginner Microsoft Excel
Sat, Dec 7, 10am–5pm
-
Intermediate Microsoft Excel
Sun, Dec 8, 10am–5pm
-
Advanced Microsoft Excel
Sun, Dec 15, 10am–5pm
-
Looking for corporate training?
We offer custom onsite training and discounted class vouchers.
The Excel Expert Certification Program Includes
Beginner Microsoft Excel
Intermediate Microsoft Excel
Advanced Microsoft Excel
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