Go from beginner to experienced professional: summarize data with Pivot Tables, write advanced functions including VLOOKUP and XLOOKUP, and learn techniques to expedite your workflow. Split and join text, create dropdown menus, and sort and filter data. Use statistical formulas like COUNTIFS and SUMIFS to learn more about your data. At the end of this class, you'll unlock powerful techniques that will help you complete tasks more quickly.
Do you want to become an advanced Excel user in just 3 days? Sign up for our Microsoft Excel Bootcamp and get a 15% package discount.
Operating System Note: A PC or Mac with Excel will be provided (choose your operating system at checkout). The instructor will present on a PC but will explain the differences for Mac students, and the class files clearly outline the differences.
Attendees must have beginner Excel skills equivalent to our Excel Fundamentals course, including basic functions and formulas, printing, formatting, basic charts, and tables.
From our hands-on training style to world-class instructors and custom-crafted curriculum, we deliver results our alumni are proud of.
Intermediate Excel was great! Our instructor, Mike, was very patient and happy to answer any questions that came up along the way. VLOOKUPS aren't nearly as intimidating now that I've taken the class.
I would definitely recommend these classes to improve your excel skills. I use excel everyday and having this knowledge will cut time on work significantly.
We could ask as many questions as necessary, and Garfield answered them all.
Life-changing, super helpful! I loved the energy the instructor, Mike, had. It was very interactive and informative. Learned a lot :)
After participating in the Intermediate Excel for Business training, I now feel much more confident about using Excel in my job. I've been intimidated by Excel for quite some time but now I see it as a tool to experiment with and learn from!
Thorough, patient, and enthusiastic instructor; super helpful Excel tips for business.
Excel class worth taking.
Very well paced, easy to follow Excel class!
Adebayo was really helpful. I learned a lot that I did not know prior to taking the class.
No prior homework necessary, this class will break down Excel need-to-knows for you and continue building on your new knowledge throughout the course.
I highly recommend this class and the instructor. It will definitely add to your knowledge base, even if you are an experienced user.
The instructor was fantastic! He explained the concepts clearly and patiently, and encouraged questions. I will be able to apply much of what I learned in this class directly to my work.
Great pace, instructions and applicable for business setting. It helped me understand how to set up my Excel sheets to be more practical.
The class was valuable and comprehensive, and the instructor was knowledgeable yet patient with every learner.
This class opened my eyes to a world of functions I was unaware existed. I thought I knew Excel before, but now I can truly say that I have an in-depth understanding of this software.
This Intermediate Excel for Business training was very useful and easy to follow along. The content was helpful and the examples on how the tasks are used are extremely informative. This content in the class was very helpful even if you are knowledgeable with excel, but need a refresher on some of the more intricate ways excel can be performed. I highly recommend this class.
Excellent delivery, with concise and thorough explanations from our instructor Garfield. Well paced, useful information that is suited to the day to day reporting needs of my team.
The Intermediate Excel class was a very thorough walk through of advanced skills. The instructor was very knowledgeable and would explain the application in a variety of ways to illustrate Excel's capabilities. The class is a very good investment of both time and money. I recommend it to anyone interested in furthering their Excel skills.
These excel classes are outstanding. I would highly recommend to colleagues in the field, especially if you're a beginner or apprehensive about getting started!
Even through a virtual training, I was able to learn as much as I would have in person. I appreciated the patience of the instructor as well as the easy-to-follow steps for each of the different topics.
Totally recommend to take it. I already know what I will be using starting tomorrow in my work.
I would recommend this class to anyone who uses Excel. It is one day of learning that will save you countless hours of work and teaching yourself through looking up stuff on Google!
Worth every minute. It will make you more confident in your work ability.
Garfield was very professional and look forward to other classes conducted by him.
The course was very informative and the instructor was fantastic. Garfield is knowledgeable, professional and has a great balance of learning with humor.
Showing 25 of 55 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
I have taken two Excel classes at NYIM and they were both fantastic. Garfield is a really skilled teacher and I learned so much!
— Sandhya B.
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 or as self-paced training. 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.
Learn at your own pace with pre-recorded video lessons and hands-on exercises. Work through the material on your schedule with access to course content and resources.
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 one month after the session.
The instructors typically present using Excel 2019 or Office 365. However, you can also use Excel 2013 or 2016; the exercises and interface are compatible with what we teach (with some minor differences that the instructor will explain).
Attendees must have beginner Excel skills equivalent to our Excel Fundamentals course, including basic functions and formulas, printing, formatting, basic charts, and tables.
This course does not qualify for payment plans or student financing. See our Payment Plan FAQ to find related programs that qualify.
You may attend this training virtually (online) at the scheduled time the course is offered (New York, Eastern Time).
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.
We don’t currently offer discounts as we do our best to affordably prices our courses.
