Advanced Excel Courses in NYC or Live Online

Group Classes & Corporate Training

Learn advanced Excel tools and techniques to become a power user in hands-on classroom and corporate training in New York. Our advanced classes are taught by top instructors using our proprietary curriculum.

  • 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 courses are instructor-led in our Manhattan classrooms or live online (virtual learning).

  • Excel Programming with VBA

    • Weekdays only
    • 12 hours
    • Open to beginners

    Learn Visual Basic for Applications to accelerate your workflow and reduce errors in Excel. This bootcamp course includes Excel VBA Macros Levels 1 and 2. By the end of this course, you'll be able to develop a macro, create automated event processes, and use automation to manage unforeseen errors. 

    View course

  • Excel Expert Certification Program

    • Weekdays, evenings, saturdays, or sundays
    • 21 hours
    • Open to beginners

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

    View course

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

    View course

  • Excel Specialist Certification Program

    • Weekdays, evenings, saturdays, or sundays
    • 19 hours
    • Open to beginners

    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.

    View course

  • Microsoft Excel PowerPivot

    • Not currently scheduled
    • 7 hours
    • Open to beginners

    You will make use of the PowerPivot add-in to import data from various sources and create a dynamic report.

    View course

  • 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. Through various exercises and projects, you will reinforce and build upon knowledge gained in intermediate-level courses.

    View course
Show All Advanced Excel Courses
  • 45,000+
    Students
  • 34
    Years
  • 2,500+
    Testimonials

Corporate Training

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

Get a Free Quote

Why Learn at Career Centers

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 4.8 stars by 7,638 students

in the past 24 months

As a self-taught Excel user for many years, this course is a great way to fill in blanks, understand why things work the way they do, and move you forward in ways you may never have been able to on your own.

Very good! Day 2 of a 2 day course - really did not think the instructor (Peter) could have been better than day 1 instructor (Ade). While they are different, they are both great! I really appreciate the time Peter spent on the difficult topics today. Made them very simple to understand which will really help with recollection!


Ortho Clinical Diagnostics, Inc.

Excellent value for cost. Lot of personal attention with small class sizes. Overall great class.

Really good way to get groundwork for VBA coding. Fast pace, real-world examples.

An excellent start to put you on the right track toward your journey to software mastery.

Mourad is a fantastic presenter with a great grasp on the information and has the skills to teach it effectively!

As someone pursuing a career change, the hands-on, practical experience I got from the financial modeling bootcamp was exactly what I needed.


Mount Sinai

This class was very helpful & the instructor was very knowledgeable on the subject. The class was very interactive and I would 10/10 suggest it to others.


Moody's Analytics

Garfield's class was so informative, I would definitely return for refresher classes if I ever need to sharpen my skills. HIGHLY RECOMMEND!


Natixis

Great class, taught me things about excel that I will definitely use in my profession.

One of the best Excel classes that I have taken.


NYC DDC

Highly recommend to anyone looking to build technical skills in Excel.


NYU

Amazing class. I needed a refresher on this information, especially Pivot Tables and macros. I loved Jordan's knowledge, professionalism, and personality. He made all of this information so much easier to understand. Thank you!


adidas AG

Liked the pace at which the class went and was able to cover all the concepts for the day.

Even taking a class like this online, I feel I received the most benefit from the material. Everything was provided and easy to navigate.


NYU Grossman School of Medicine

Great instructor!

As a long-time user of Excel in both my professional and personal life, I was apprehensive on what I can learn from an instructor-led course on such a specific topic as Visual Basic that I couldn't learn by watching YouTube videos. The instructor and class interactions helped me learn how to approach solutions using this tool. I would highly recommend these courses to my peers who are interested in expanding their knowledge base.

I came in knowing nothing about VBA and macros. I left with a sufficient enough understanding to continue mastery at home or in the office!

Upcoming Advanced Excel Classes in NYC

All times are listed in Eastern Time unless otherwise specified.

December 2024
Excel Expert Certification Program
December 26–30
Weekdays 10–5pm
$1,149
21 Hours
NYC or Live Online

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

Excel Specialist Certification Program
December 26–30
Weekdays 10–5pm
$959
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.

January 2025
Excel Expert Certification Program
January 6–22
Evenings 6–9pm
$1,149
21 Hours
NYC or Live Online

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

Excel Specialist Certification Program
January 6–22
Evenings 6–9pm
$959
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.

Excel Expert Certification Program
January 7–9
Weekdays 10–5pm
$1,149
21 Hours
NYC or Live Online

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

showing 5 of 42 courses

Hands-on Advanced Excel training classes in Manhattan, NYC

Become an Excel Expert 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 an Advanced Excel for Finance training where you'll master financial functions and advanced applications of Excel used in the financial field. 

Continue reading
Yelp Facebook LinkedIn YouTube Twitter Instagram