Excel Expert Certification Program
Get certified as an Excel Expert with this certification program.
Choose another date
We are open! Classes are running in-person (socially distanced) and live online. Secure your seat today
Get certified as an Excel Expert with this certification program.
May 18–Jun 3
Weekdays
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.
Upon completion of this course, you’ll receive an official certificate testifying to your mastery of the curriculum. We’ll send you a link where you can download your certificate, share it online with your friends, post it to your professional network on LinkedIn, and view all your earned certificates. Congratulations on your achievement!
Shareable on
Learn the concepts and skills covered in this true or your tuition is on us. See details and terms & conditions.
Work on projects proven to boost retention
Refined over many cohorts for an optimal learning experience
Excellent classes and excellent venue! It has just the right level of personal attention and class participation. I would highly recommend NYIM and look forward to taking future classes there. – Hazel S.
Experienced educators who are driven to help you succeed
Refresh the materials and gain additional practice
Course times are listed in Eastern Time.
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.
As one of our smaller courses, tuition for this course is due in full before the start date.
There are no extra fees or taxes for our courses. The price you see on this page is the maximum you’ll pay us.
However, if you plan to take the course live online, you may need to obtain required software. We’ll help you get set up with a free trial of paid software prior to the class. Most of our coding classes utilize freely-available open-source software. For most of our design and motion graphics courses, we will help you get set up with a free trial of Adobe Creative Cloud. If you attend the course in-person, we will have a computer already set up for you with all of the required software for no additional cost.
This program is a discounted package of classes that is 15–25% off the individual class prices.
Get face-to-face interaction with an instructor and other students when you learn at our NYC campus. Courses are hands-on with a computer and software provided.
Get the same interactivity and access to the instructor as in-person students. There are no extra fees and we’ll work with you to ensure your remote setup is perfect.
This is the recommended order, but some courses may be taken in a different order.
Unit 1 7 Hours
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.
Unit 2 7 Hours
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.
Unit 3 7 Hours
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.
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.
Students must be comfortable using a computer. No other prior knowledge is required.
This course does not qualify for payments plans or student financing. See our Payment Plan FAQ to find related programs that qualify.
You may attend this training virtually (online) at the scheduled time the course is offered (New York, Eastern Time).
Select up to two courses and tap Compare selected courses to view a side-by-side comparison of Excel Expert Certification Program with your selected courses.
Become an advanced Microsoft Excel user in just three days. This Excel Bootcamp includes 21 hours of hands-on training in formulas, functions, Pivot Tables, macros & more.
The Excel Specialist Certification program includes our three Excel courses (Fundamentals, Intermediate, and Advanced), two hours of private training, and the Excel Specialist Exam fee with a free retake.
Learn all the basics to use Excel as your primary data processing tool. Create charts and tables, get started with formulas and functions, and format and print your output.
Go from beginner to experienced professional: summarize data with Pivot Tables, write advanced functions including VLOOKUP, and learn techniques to expedite your workflow.
Purchase group class vouchers at a discount for our regularly-scheduled group classes in NYC, or create a custom training program at your offices.
We’ve trained thousands of companies!
Let us create the perfect program for your team.
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