Advanced Excel for Business
Master advanced Excel techniques in this hands-on training. Learn how to use the more advanced tools in Excel like What-If Analysis, INDEX-MATCH, macros, and more.
We are open! Classes are running in-person (socially distanced) and live online. Secure your seat today
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 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 course is part of our Excel Bootcamp. Enroll in our three-course package and save 15%.
Class Note: A PC or Mac will be provided for use during class. The instructor will present on a PC but will explain the differences for Mac students.
Great teacher! She was really helpful and moved at a solid pace. Answered all questions super well. She made the class.
A class was very helpful and the instructor made it worthwhile. Took the two-night excel class and will be back for powerpoint.
Had a one on one training with Garfield - he was patient, professional, and incredibly knowledgeable. Would highly recommend for anyone looking to expand their excel capabilities in business.
Great class! The content was well organized and the instructor was excellent. He was engaging, knew the material very well and was able to adjust to the various levels of ability of the students! Would definitely recommend!
The overall experience was great. I feel the instructor was well educated on the tools I needed in order to succeed in my current role. I would rate the preparation, use of time, knowledge of material and general kindness as one of the best training classes/sessions that I have ever attended. I have and will continue to recommend the folks at NYIM to others.
K. Burton of Microsoft
Patrick was extremely detailed and gave students time to keep up with understanding the work.
If you need a refresher course or if you need to brush up or learn, this is the place to learn.
Great way to learn more advanced functions of working with data in spreadsheets, easy to follow and a ton of information. You even get a workbook to follow along, enhancing the experience and creating a paper trail/reference sheet.
I highly recommend this class - the instructor managed to teach for 6 hours on zoom while perfectly explaining every single element at a perfect pace for everyone and was very attentive and had full expertise on all of Excel's functions.
This was an extremely helpful course and I'll be able to use so much of what we reviewed in my day to day at work. I'm excited to be able to re watch parts of the lessons through the recording as well! Once I master this, I'm definitely interested in the Macros class.
I learned a number of functions and procedures in Excel that will allow me to be more productive and more efficient with my daily tasks.
Great for business people looking to use advanced Excel features to improve productivity at work.
If you need to use Excel at work, this class will make your life easier and efficient.
An engaging, informative perfect way to learn or refresh your skills!
AgeWell New York
Never in a million years would've thought that an Excel training workshop would actually be enjoyable!
Love this class. Can use what I've learned at work.
Very good class. Trainer was very good, very patient.
Agewell New York
This was a great class, even if you know excel there are formulas/functions that can give you faster results then what you are doing now.
I definitely recommend this course for professional development in any field where MS Excel is used.
Mayor's Office of Immigrant Affairs
In this course, I learned a lot about Excel that I didn't know previously. I would certainly recommend it to those looking to learn more about the software.
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!
Work on projects proven to boost retention
Refined over many cohorts for an optimal learning experience
Great class! The content was well organized and the instructor was excellent.
— Rebecca H.
Experienced educators who are driven to help you succeed
Refresh the materials and gain additional practice
In addition to 7 Hours of live training, you’ll receive lifetime access to self-paced training videos, a $95 value.
As one of our smaller courses, tuition for this course is due in full before the start date. The best way to save on this course is to take it as part of a certificate program.
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.
We don’t currently offer discounts as we do our best to affordably prices our courses.
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 Advanced Excel for Business 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.
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.
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.
Purchase group class vouchers at a discount for our regularly-scheduled group classes in NYC, or create a custom training program at your offices.
Are you an Excel power user with knowledge of Pivot Tables and VLOOKUP? Do you use Excel daily for work and professional needs? If so, NYIM’s Advanced Excel Course will help you take your skills to the next level. In the advanced Microsoft Excel course, you will learn how to:
Apply pre-assigned shortcuts to accelerate your workflow
Build upon your knowledge of Pivot Tables with Pivot Charts
Implement the MATCH function with VLOOKUP and INDEX
Automate formatting and calculations tasks with macros
In Advanced Excel for Business, you’ll learn automation and shortcut techniques to apply to Excel’s most advanced features like Pivot Tables. The course includes training on recording macros to perform repetitive Excel tasks in a single click. At the end of the course, you’ll complete a course project that you can demo to current and prospective employers to demonstrate your new skill set.
Our advanced classes are perfect for those with knowledge of basic techniques including formatting, charts, basic formulas and functions, and absolute cell references, as well as intermediate-level concepts, including VLOOKUP, Pivot Tables, and intermediated functions such as SUMIFS and IF. For more information on the required prerequisite knowledge, see our Excel Fundamentals and Intermediate Excel course pages.
Don’t quite meet the prerequisites but want to become an advanced Excel user? Did you forget how to use core Excel functions like Pivot Tables and VLOOKUP? Get a refresher on Microsoft Excel functions and gain master Advanced Excel in our Excel bootcamp. The Advanced MS Excel class is part of our Excel for Business Bootcamp. Take our three Excel for Business classes and get a 15% package discount. Sign up for the Excel Bootcamp!
We offer a handful of advanced Excel courses to suit different needs.
Advanced Excel for Business builds off Intermediate Excel and teaches the advanced Excel features most commonly used by business professions today. Make your lookup functions more flexible by adding MATCH to VLOOKUP and using INDEX and MATCH together; expand Pivot Tables with Pivot Charts and other advanced features; create nested functions including nested IFS and IF with AND/OR; utilize advanced analytical tools; and write basic macros with the macro recorder to automate repetitive tasks.
For those looking to further automate tasks and create custom commands, enroll in our Excel Programming with VBA course. This two-day bootcamp covers the essentials of Excel’s programming language.
Gain real-world value that you can apply on the job
Reinforce learning with practice exercises after each course section
Solidify your new skills with a cumulative project at the end of class
Get free access to our premium Advanced Excel video suite
Retake the course free within six months