Rated the best Advanced Excel classes in New York City
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 attended Advanced Excel for Business
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. attended Excel Specialist Certification Program
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. attended Financial Modeling Bootcamp
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.
Classrooms are not glamorous by any means, but they are acceptable. I took the class in early fall, and I would caution that the room was quite warm; somewhat uncomfortably so once it hit midday, even with the giant fan going. So dress lightly. But worth it for the VBA-ducation.
Rob W. attended Excel Programming with VBA
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. attended Financial Modeling Bootcamp
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. attended Financial Modeling Bootcamp
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. attended Financial Modeling Bootcamp
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. attended Excel Programming with VBA
Thank you for the session! It was really helpful and I've learned a lot from Joe.
N.N. attended Excel Programming with VBA
Great teacher! She was really helpful and moved at a solid pace. Answered all questions super well. She made the class.
Ariel O. attended Advanced Excel for Business
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. attended Excel Programming with VBA
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. attended Advanced Excel for Business
I took the Financial Modeling Bootcamp. The instructors are very knowledgeable about what they teach and encourage questions throughout the workshop.
Kelvin L. attended Financial Modeling Bootcamp
Saba really knows her stuff! Lively attitude kept things interesting. She was very interactive and engaging us in the class.
V.B. attended Excel Programming with VBA
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. attended Excel Programming with VBA
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. attended Advanced Excel for 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!
Rebecca H. attended Advanced Excel for Business
Great experience, I highly recommend for anyone looking to break into consulting/banking!
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
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.
Increase your daily productivity by learning VBA (Visual Basic for Applications). Create custom buttons and automate repetitive tasks. Learn how to write code to develop new macros and update existing macros to improve their functionality. Master the VBA programming language to accelerate your workflow and reduce your daily workload by several hours.
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 a 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.
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.
This certification program will prepare you for the Microsoft Excel exam: Excel 2016 Expert: Interpreting Data for Insights. This program includes three group classes, four hours of private training, and the Excel Expert Exam with a free retake.
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.
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.
Give your resume a boost with Microsoft Excel Certification. 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. You'll also receive free proctoring on exam day. All students enrolled in our Microsoft Excel certification program gain lifetime access to our free Excel video courses, the perfect companion to our live classes.
This PowerPivot class concentrates on how to create powerful Pivot Tables through multiple table relationships. Learn to set up relationships, create and display complex PivotTables, and use Calculated DAX columns.