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
Group Classes Corporate Training

Small Group Advanced Excel Classes

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

  • Excel Programming with VBA

    • Weekdays only
    • 12 Hours
    • Prerequisites required

    Learn the fundamentals of VBA, Excel's programming language, in project-based training. This VBA course concentrates on the automation of repetitious Excel tasks and reports.

  • Advanced Excel for Business

    • Sundays, weekdays, or evenings
    • 6 Hours
    • Prerequisites required

    Level up your Excel skills by mastering sophisticated techniques like advanced Pivot Tables, task automation through macros, and analytical tools. You'll also learn to write nested IF statements, apply arrays, and use conditional formatting with custom formulas.

  • Excel for Power Users

    • Not currently scheduled
    • 7 Hours
    • Prerequisites required

    Learn to solve challenging problems in Excel by applying and nesting various functions. You'll get an introduction to VBA, Excel's programming language, to automate workflow and repetitive tasks.

  • Excel Expert Certification Program

    • Weekdays only
    • 21 Hours
    • Open to beginners

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

  • Advanced Excel for Financial Modeling

    • Weekdays only
    • 6 Hours
    • Prerequisites required

    Master the advanced Excel tricks, techniques, and tools financial analysts use to build and audit financial models. By the end of this course, you will know how to write efficient and flexible formulas, create sensitivity analysis, and master Excel's features for finance.

  • Financial Modeling Bootcamp

    • Weekdays only
    • 18 Hours
    • Prerequisites required

    Learn the skills you need to become a top financial analyst: advanced Excel, financial modeling, corporate finance, and accounting. Build a financial model to value a public company, and learn industry best practices from experienced investment bankers and analysts.

Show All Advanced Excel Courses
  • 45,000+
    Students
  • 36
    Years
  • 2,500+
    Testimonials

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

Highly Reviewed by Our Alumni

From our hands-on training style to world-class instructors and custom-crafted curriculum, we deliver results our alumni are proud of.

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 was 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.

Student rating for Advanced Excel Courses: 4.8 stars by 9,406 students

  • Ryan Z. Apr 9, 2021
    Advanced Excel for Business

    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.

  • Touhidul C. Volunteer Associate @ Mayor's Office of Immigrant Affairs Mar 6, 2021
    Advanced Excel for Business

    I definitely recommend this course for professional development in any field where MS Excel is used.

  • Stephy V. @ Agewell Feb 24, 2021
    Advanced Excel for Business

    This was a great class, even if you know excel there are formulas/functions that can give you faster results than what you are doing now.

  • Pierre M. Senior Benefit Advisor @ Agewell New York Feb 24, 2021
    Advanced Excel for Business

    Very good class. Trainer was very good, very patient.

  • Maricruz M. 485 Forms Office Manager @ UJCHASC Feb 24, 2021
    Advanced Excel for Business

    Love this class. Can use what I've learned at work.

  • Aaron B. Senior Accountant @ Kipp NYC Feb 11, 2021
    Advanced Excel for Business

    Never in a million years would've thought that an Excel training workshop would actually be enjoyable!

  • Ellen F. Medicare Enrollment Specialist @ AgeWell New York Feb 10, 2021
    Advanced Excel for Business

    An engaging, informative perfect way to learn or refresh your skills!

  • John A. Senior Associate @ Owl Ventures Jan 14, 2021
    Financial Modeling Bootcamp

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

  • John A. Senior Associate @ Owl Ventures Jan 12, 2021
    Advanced Excel for Financial Modeling

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

  • Stella A. Jan 11, 2021
    Advanced Excel for Business

    If you need to use Excel at work, this class will make your life easier and efficient.

  • Melissa G. Marketing Manager @ Industrial Communications Dec 7, 2020
    Advanced Excel for Business

    Great for business people looking to use advanced Excel features to improve productivity at work.

  • Bruce T. Senior Accounts Receivable Analyst @ Dabur Limited Oct 8, 2020
    Advanced Excel for Business

    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.

  • Kaitie O. Compensation and Benefits Analyst @ Natixis Jun 19, 2020
    Advanced Excel for Business

    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.

  • Lyubitsa G. Treasury Officer @ Lukoil Jun 4, 2020
    Advanced Excel for Business

    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.

  • Mark V. Regional Client Advisor @ Neuberger Berman Apr 24, 2020
    Advanced Excel for Business

    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.

  • Eugene P. Purchasing Contractor @ Columbia University Mar 8, 2020
    Advanced Excel for Business

    If you need a refresher course or if you need to brush up or learn, this is the place to learn.

  • Quinn B. @ NYC DDC Feb 18, 2020
    Advanced Excel for Business

    Patrick was extremely detailed and gave students time to keep up with understanding the work.

  • Charles K. Management consultant @ Element 78 Advisors Nov 6, 2019
    Financial Modeling Bootcamp

    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.

  • Ali G. Sr. Staff Accountant @ Weil, Gotshal and Manges LLP Oct 30, 2019
    Excel Programming with VBA

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

  • David C. May 28, 2019
    Excel Programming with VBA

    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!

  • Rob W. Apr 29, 2019
    Excel Programming with VBA

    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.

  • Kelvin L. Apr 15, 2019
    Financial Modeling Bootcamp

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

  • Tommy M. Feb 5, 2019
    Advanced Excel for Business

    A class was very helpful and the instructor made it worthwhile. Took the two-night excel class and will be back for powerpoint.

  • Ariel O. Dec 4, 2018
    Advanced Excel for Business

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

  • Noam L. Oct 21, 2018
    Financial Modeling Bootcamp

    I can honestly say I learned more useful modeling and excel skills from the Financial Modeling Bootcamp than I have through one and a half years of business school. The course effectively conveys key finance, corporate finance, and financial accounting concepts while also offering students the opportunity to build real financial models with real-time data. The 7:1 student to teacher ratio along with the experience and modeling expertise of Mourad offers a unique opportunity for a personalized learning experience. Whether you are a student looking to pursue a career in finance or a current professional simply looking to brush up on your Excel skills, I would highly recommend this course.

Showing 25 of 41 reviews

Upcoming Schedule: Advanced Excel in NYC

All times are listed in Eastern Time unless otherwise specified.

October 2026
Advanced Excel for Business
October 11
Sunday 10am–5pm
$299
6 Hours

Level up your Excel skills by mastering sophisticated techniques like advanced Pivot Tables, task automation through macros, and analytical tools. You'll also learn to write nested IF statements, apply arrays, and use conditional formatting with custom formulas.

Excel Specialist Certification Program
October 13–15
Weekdays 10am–5pm
$959
19 Hours

This 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.

Excel Expert Certification Program
October 13–15
Weekdays 10am–5pm
$1,149
21 Hours

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

Advanced Excel for Business
October 15
Thursday 10am–5pm
$299
6 Hours

Level up your Excel skills by mastering sophisticated techniques like advanced Pivot Tables, task automation through macros, and analytical tools. You'll also learn to write nested IF statements, apply arrays, and use conditional formatting with custom formulas.

Financial Modeling Bootcamp
October 21–23
Wednesday to Friday 10am–5pm
$995
18 Hours

Learn the skills you need to become a top financial analyst: advanced Excel, financial modeling, corporate finance, and accounting. Build a financial model to value a public company, and learn industry best practices from experienced investment bankers and analysts.

Showing 5 of 147 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 in Excel 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 our 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