Build on intermediate Excel skills with advanced functions, PivotTable techniques, and recorded macros. Use INDEX-MATCH and nested functions to make formulas more flexible, and explore Goal Seek and Data Tables for what-if analysis.
Practice worksheet protection and shortcuts, then record macros to automate repetitive tasks. This course is included in the Excel for Business Bootcamp.
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.
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.
I definitely recommend this course for professional development in any field where MS Excel is used.
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.
Very good class. Trainer was very good, very patient.
Love this class. Can use what I've learned at work.
Never in a million years would've thought that an Excel training workshop would actually be enjoyable!
An engaging, informative perfect way to learn or refresh your skills!
If you need to use Excel at work, this class will make your life easier and efficient.
Great for business people looking to use advanced Excel features to improve productivity at work.
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.
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.
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.
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.
If you need a refresher course or if you need to brush up or learn, this is the place to learn.
Patrick was extremely detailed and gave students time to keep up with understanding the work.
A class was very helpful and the instructor made it worthwhile. Took the two-night excel class and will be back for powerpoint.
Great teacher! She was really helpful and moved at a solid pace. Answered all questions super well. She made the class.
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.
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!
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.
Showing 20 of 20 reviews
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. Engage with expert instructors, ask questions, and get feedback on your exercises and projects.
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 185 Madison Ave, 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 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 30 days after the session.
Excel features and the interface vary by version and operating system. Check the course’s software requirements before enrolling. If you plan to use an older version or Excel for the web, contact NYIM to confirm whether it supports the exercises.
Attendees must have Excel proficiency equivalent to our Intermediate Excel course, including VLOOKUP, Pivot Tables, and IF statements.
This course does not qualify for payment plans or student financing. See our Payment Plan FAQ to find related programs that qualify.
Live online attendance is available for selected upcoming dates. Check the schedule for each date's attendance format and time zone before enrolling.
You have some options:
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.
