Advanced Excel Courses in NYC or Live Online

Advanced Excel Classroom Training

Become an advanced Excel user. Master advanced functions, macros, VBA programming, PowerPivot, financial modeling, and more.

  • In-person courses
  • Flexible training solutions
  • Small class sizes
  • Hands-on & interactive

Small Group Advanced Excel Classes

Our Advanced Excel Courses courses are instructor-led in our Manhattan classrooms or live online (virtual learning).

Show All Advanced Excel Courses

Corporate Training

Drive team performance and efficiency with NYIM’s industry-leading training. Send employees to our group classes or create a custom training program onsite.

Get a Free Quote

Why Learn at NYIM

Highly Reviewed by Our Alumni

From our hands-on training style to world-class instructors and proprietary curriculum, we deliver a learning experience our alumni can be proud of.

Our Advanced Excel Courses are rated 5.0 stars

in the past 24 months

This was a great refresher course for some of the deeper financial concepts I have not used since undergrad. I think this course is phenomenal for recent college grads starting off their careers in finance or budget. It's a great intro for learning to navigate excel shortcuts. I am 5 years in my career now and have never had the investment banking background but still have been a financial analyst and been involved in raising capital so the concepts covered were a great refresher for me. Additionally the instructor did a great job with playing to the students in the course and our backgrounds and what subjects to go more in-depth with and vice versa.

Alexandria B.

This financial modeling bootcamp helped me round off my excel shortcut skills. All of the excel shortcuts I didn't already know; I learned in this course. This will help me work fast and smarter. I also appreciated the applicability of the financial analysis we conducted. We moved in a very timely fashion and this was a very productive course that will help me as I start off as an investment analyst.

John C.

The financial modeling boot-camp class was a great review for everything I have learned during my undergraduate studies and was also very relevant to my working experience. I also liked that the size of the classes were not too big; this allowed the participants to be actively engaged. As I work in fixed income and while this boot-camp focused on projecting stock price, the research and excel model/setup is very similar so there was very relevant crossover. All in all, I wish I had taken this class earlier this year. Great class.

Nico S.

I don't even know what else Saba could have done to make the class better - she was so on point and really interesting.

L.P.

Thank you for the session! It was really helpful and I've learned a lot from Joe.

N.N.

Great teacher! She was really helpful and moved at a solid pace. Answered all questions super well. She made the class.

Ariel O.

This course exceeded my expectations.Saba is a great instructor! She answered all my questions and went beyond to link it to real life examples.

Laura H.

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.

I took the Financial Modeling Bootcamp. The instructors are very knowledgeable about what they teach and encourage questions throughout the workshop.

Kelvin L.

Saba really knows her stuff! Lively attitude kept things interesting. She was very interactive and engaging us in the class.

V.B.

I had an amazing experience doing private training for Excel for Finance. I learned all the practical applications for the formulas I'm expected to know at my new job - I feel great and super confident at work with my new skills! Very patient and knowledgeable instructor too.

Max D.

Saba made the class non- intimidating and informative due to her casual approach, teaching from the basics forward and her helpfulness with every little question. I did like that the class was small and hands on with computers.

N.B.

I took a private Excel class at NYIM, and it was excellent. The trainer, Mourad, prepared a very good class outline that taught me many useful tools. During our time together, Mourad was patient and changed the direction as he determined what my greatest needs were. I will be taking more classes with NYIM and highly recommend them.

Kevin D.

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.

I'm enrolled in the Excel for Business three part series of courses. The first course was informative and very helpful! Everything is very easy to understand and the instructor works with students to make sure they are following the main concepts. The first class is a general overview of shortcuts, basic formulas, and the most useful concepts of Excel that are most applicable to the world of business and general office management. This is an all-day class and yes there is a lot of information thrown at you, but even someone with no Excel experience should not find this hard to grasp because of how it is organized.

Ryan B.

Great experience, I highly recommend for anyone looking to break into consulting/banking!

Thomas P.

Took the two day Financial Modeling Bootcamp. Extremely informative and useful. Smaller class size allows for one on one help and enables you to really understand the material you are working through. Additionally you build out a model on an actual company during the course, allowing you to perform the same kind of analysis you would use in a real office setting, as opposed to looking at generic accounting problems. Office itself is very nice, and the professors are extremely well informed. 10/10 would recommend to anyone looking to develop, sharpen, or reestablish their financial modeling skills.

Robert F.

I recently took an excel VBA Class here and it was extremely helpful! The first day was a bit of a refresher, but then the class really picked up! The instructor was extensively knowledgeable and passionate about the subject! Additionally, they were ready and willing to answer all student questions and emphasized the importance of us all being on the same page, so no one felt left out. The location is also very close to Penn station, which is a definite plus if you are traveling by train!

David C.

High-quality VBA training in Excel--I've taken a couple of classes, and this was by far the best--Garfield was an excellent instructor--patient, clear, and helpful. Course content felt well thought out and organized-- a nice mix of working on mapped exercises to work on discrete skills with some room to work on any problems or concerns or thoughts you might have brought to class. The supplement files/exercises provided for post-class work are solid as well. I've received a greater amount of content from some places, but the files and materials here were much more workable and better-organized.

Rob W.

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

Whether you want a quick refresher or crash course, Financial Modeling in Excel will benefit anyone in the M&A field looking to expand their skills.

Charles K.
Element 78 Advisors

Gives a pretty good foundation for those who are a long way from ever being a programmer!

Ali G.
Weil, Gotshal and Manges LLP

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.

This class was absolutely great. I've been in Finance for 5 years and learned things today!

John A.
Owl Ventures

Super helpful and affordable. Will be helpful in my career in growth equity.

John A.
Owl Ventures

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.

Upcoming Advanced Excel Classes in NYC

All times are listed in Eastern Time unless otherwise specified.

May 2024
May 1–3
Weekdays 10–5pm
$1,099
21 Hours
NYC or Live Online

This certification program will prepare you for the Excel Expert Exams. This program includes three group classes, four hours of private training, and the Excel Expert Exam with a free retake.

May 1–3
Weekdays 10–5pm
$899
19 Hours
NYC or Live Online

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.

May 2 & 7
Thursday & Tuesday 6–9pm
$249
6 Hours
NYC or Live Online

Become an Excel guru in this hands-on advanced training. You'll make functions more flexible, take Pivot Tables to the next level, automate tasks with macros, and learn advanced analytical tools.

May 3
Friday 10–5pm
$249
6 Hours
NYC or Live Online

Become an Excel guru in this hands-on advanced training. You'll make functions more flexible, take Pivot Tables to the next level, automate tasks with macros, and learn advanced analytical tools.

May 5
Sunday 10–5pm
$249
6 Hours
NYC or Live Online

Become an Excel guru in this hands-on advanced training. You'll make functions more flexible, take Pivot Tables to the next level, automate tasks with macros, and learn advanced analytical tools.

showing 5 of 67 courses

Become an Excel Guru in our Advanced Classes

These advanced Excel courses are perfect for those with beginner-to-intermediate knowledge of Excel, including calculations, printing, formatting, VLOOKUPs, and Pivot Tables basics. Participants should be familiar with the concepts covered in our Excel Fundamentals and Intermediate Excel courses. 

Which Advanced Excel Training should I attend?

Are you familiar with VLOOKUPs and Pivot Tables but want to take your skillset to the next level? Do you spend hours each day and want to master shortcuts and advanced techniques?

Our Advanced Excel for Business course covers the most commonly-used advanced features business professionals use day-to-day. You'll learn

  • Add the MATCH function to VLOOKUP to calculate the column number
  • Use INDEX & MATCH together to create a more flexible lookup function
  • Expand on IF statements by learning nested IFs and IF with AND / OR
  • Use mixed cell references to build dynamic formulas
  • Utilize advanced data tools including Goal Seek and Data Tables to show outputs based on different scenarios
  • Record macros to automate tasks
  • Use advanced Pivot Tables techniques: Pivot Charts, linking multiple Pivot Tables

Are you an advanced Excel user who wants to automate workflow, create custom commands, and learn to program in Excel?

Take our Excel Programming with VBA course to automate daily workflow and create custom functions. This advanced training covers the essentials of Visual Basic programming through hands-on exercises. 

Are you currently working in finance or starting a position as a financial analyst? Do you want to sharpen your skills ahead of job interviews in investment banking, private equity, hedge fund, or real estate?

Attend of Advanced Excel for Finance training where you'll master financial functions and advanced applications of Excel used in the financial field. 

Yelp Facebook LinkedIn YouTube Twitter Instagram