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.
Choose another date
We are open! Classes are running in-person (socially distanced) and live online. Secure your seat today
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.
Feb 13
Monday, 10–5pm
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.
Attendees must have Excel proficiency equivalent to our Intermediate Excel course, including VLOOKUP, Pivot Tables, and IF statements.
From our hands-on training style to world-class instructors and custom-crafted curriculum, we deliver results our alumni are proud of.
Advanced Excel for Business is rated 5.0 stars
in the past 24 months
Great teacher! She was really helpful and moved at a solid pace. Answered all questions super well. She made the class.
Ariel O.
A class was very helpful and the instructor made it worthwhile. Took the two-night excel class and will be back for powerpoint.
Tommy M.
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.
Alexandria A.
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!
Rebecca H.
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.
Quinn B.
NYC DDC
If you need a refresher course or if you need to brush up or learn, this is the place to learn.
Eugene P.
Columbia University
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.
Mark V.
Neuberger Berman
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.
Lyubitsa G.
Lukoil
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.
Kaitie O.
Natixis
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.
Bruce T.
Dabur Limited
Great for business people looking to use advanced Excel features to improve productivity at work.
Melissa G.
Industrial Communications
If you need to use Excel at work, this class will make your life easier and efficient.
Stella A.
An engaging, informative perfect way to learn or refresh your skills!
Ellen F.
AgeWell New York
Never in a million years would've thought that an Excel training workshop would actually be enjoyable!
Aaron B.
Kipp NYC
Love this class. Can use what I've learned at work.
Maricruz M.
UJCHASC
Very good class. Trainer was very good, very patient.
Pierre M.
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.
Stephy V.
Agewell
I definitely recommend this course for professional development in any field where MS Excel is used.
Touhidul C.
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.
Ryan Z.
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.
Learn the concepts and skills covered in this course 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
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
Attend this course in-person in NYC or Live Online via Zoom. Engage with expert instructors, ask questions, and get feedback on your exercises and projects. Switch between live-online and in-person as needed, even after the course has started.
Unlike other providers, these are not mass open-enrollment classes. At NYIM Training, you’ll learn in small groups (typically 8-15 students) and receive personalized attention.
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.
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
We offer a single free retake of the the class within a year.
You can also access recordings of each session in your student portal within one business day of the session’s end. Recordings are available for one month after the session.
The instructors typically present using Excel 2019 or Office 365. However, you can also use Excel 2013 or 2016; the exercises and interface are compatible with what we teach (with some minor differences that the instructor will explain).
Attendees must have Excel proficiency equivalent to our Intermediate Excel course, including VLOOKUP, Pivot Tables, and IF statements.
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).
You have some options:
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 18 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.
We’ve trained thousands of companies!
Let us create the perfect program for your team.
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.
Working in finance or starting a position as a financial analyst? We offer two advanced Excel courses, Advanced Excel for Finance and our Financial Modeling Bootcamp.
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