Excel Expert Certification Bundle
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 Bundle.
Excel Expert Certification Bundle
Register for a Package
Customize your own schedule or expand the start dates below to see the full schedule.
Custom Schedule
December 20
Excel for Business Fundamentals
Thu, Dec 20, 10am–5pm
Intermediate Excel for Business
Fri, Dec 28, 10am–5pm
Advanced Excel for Business
Fri, Jan 11, 10am–5pm
December 27
Excel for Business Fundamentals
Thu, Dec 27, 10am–5pm
Intermediate Excel for Business
Fri, Dec 28, 10am–5pm
Advanced Excel for Business
Fri, Jan 11, 10am–5pm
December 29
Excel for Business Fundamentals
Sat, Dec 29, 10am–5pm
Intermediate Excel for Business
Sun, Dec 30, 10am–5pm
Advanced Excel for Business
Sun, Jan 6, 10am–5pm
January 3
Excel for Business Fundamentals
Thu, Jan 3, 10am–5pm
Intermediate Excel for Business
Fri, Jan 4, 10am–5pm
Advanced Excel for Business
Fri, Jan 11, 10am–5pm
January 9
Excel for Business Fundamentals
Wed, Jan 9, 10am–5pm
Intermediate Excel for Business
Thu, Jan 10, 10am–5pm
Advanced Excel for Business
Fri, Jan 11, 10am–5pm
January 9
Excel for Business Fundamentals
Wed, Jan 9, 10am–5pm
Intermediate Excel for Business
Wed, Jan 16, 10am–5pm
Advanced Excel for Business
Wed, Jan 23, 10am–5pm
The Excel Expert Certification Bundle includes
Excel for Business Fundamentals
Intermediate Excel for Business
Advanced Excel for Business
Additional Items
Small classes
Computer provided
Book included
Free retake
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