Close
You are not logged in
Close
This Month Specials
 

Special Promotion

$209 Excel or $199 PowerPoint for Business Blowout! (Normally $299/ea)

PowerPivot Fundamentals $199 (Normally $299)

$199 QuickBooks Level 1 or Level 2 for PC, Mac, or Online Classes (Normally $299/ea)

Now $545-Excel Power Programming with VBA (Normally $659)

Now $649-Photoshop Essentials 2 Day Course (Normally $749)

GIFT CERTIFICATES AVAILABLE

Current Sales Packages

Close
185 Madison Ave, 11th Floor, New York, NY 10016 212.658.1918

Excel Expert Certification Bundle

$1099

SessionPriceSeatsLocation
Flexible Scheduling$10993185 Madison Avenue, NYC

Call 212.658.1918 or email us

Excel Expert Certification

Boost your credentials today and achieve the Excel Expert Certification. NYIM offers the perfect Excel Expert Certification bundle which includes three Excel courses (fundamentals, intermediate, and advanced), four hours of private training, and the Expert Exam with a free retake. You'll also receive access to our premium video suite, the perfect resource to prepare for the exam.

  1. Excel for Business Fundamentals group class with a Free Retake & revolutionary Beginner Excel video suite
  2. Intermediate Excel for Business group class with a Free Retake & revolutionary Intermediate Excel video suite
  3. Advanced Excel for Business group class with a Free Retake & revolutionary Advanced Excel video suite
  4. Four hours of private training
  5. Proctored Expert Certification exam with a free retake

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

How to register

Check out using the December 31st date. 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.

Email us for more information

© NYIM Training 2018

Client Testimonials