NYIM Training offers NYC's best Microsoft Excel classes, from beginner to advanced, VBA and financial modeling. Learn Functions, Formulas, Pivot Tables, Macros, and time-saving techniques in our hands-on Excel courses.
Drive team performance and efficiency with NYIM's industry-leading training. Send employees to our group classes in NYC or create a custom training program on-site.
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 have taken two Excel classes at NYIM and they were both fantastic. Garfield is a really skilled teacher and I learned so much! I plan on taking more classes when I can. Highly recommend these classes!
Sandhya B. attended Intermediate Excel for Business
NYIM does incredible work! I did the 3-day Excel Bootcamp & it was amazing! Pooja, Tom & Garfield were incredibly knowledgeable & excellent teachers. They explained everything in an incredibly clear & concise manner. I would HIGHLY recommend NYIM/Career Centers for anyone looking for Excel training, or any other training that they have to offer!
Jonathan S. attended Excel for Business Bootcamp
I enjoyed the Excel Bootcamp I took at NYIM.
First, the trainers were very knowledgeable and took the time to explain the concepts in detail.
Secondly, the course content is very rich. I found it quite voluminous though. But it is great to have printed material for reference.
Thirdly, I loved how interactive classes were with trainers trying as best they could to provide help individually to students.
I greatly recommend NYIM training.
Buri B. attended Excel for Business Bootcamp
We hired NYIM training to provide Microsoft Excel training for UJA staff and it was the best technical training I have seen. Mourad Kattan is an outstanding facilitator and he packed the session with useful information and tips for everyone who was in the room. Also, additional video provided after the session helped to solidify the learning and review everything independently. Looking forward to bringing NYIM to UJA again in the near future!
Yelena K. attended Excel for Business Bootcamp
I took NYIM Training's Intermediate Excel 2016 training this week, and I was impressed by the content and the trainer, Mike. The in-class exercises were all in one multi-tab spreadsheet which included step-by-step instructions for almost all of these, and you send the spreadsheet with any notes you made to yourself at the end of the day for future reference. No wasted time. Plenty of opportunity for questions. I have had other computer training elsewhere, but NYIM was unique in providing big-picture methods, tips, and shortcuts that were useful even for Excel tasks I already knew well. Plus, coffee and snacks to keep you going!
Rob P. attended Intermediate Excel for Business
Overall great experience in taking the Intermediate Excel Class today! Content was well organized and had appropriate progression from easy to more complex examples. Garfield, our instructor, was very knowledgabe, patient, and thorough. He also had a great sense of humor and kept the class interesting, time really flew by! I will be back to take the Advanced class and also the VBA.
Patrick M. attended Intermediate Excel for Business
Just came out of my Excel Business training at NYIM. Garfield, the instructor, is really nice and very helpful. They are very professional and they provide all the necessary tools for the students to acquire all the info they need, and, in case you want to refresh your memory you can always retake the course for free within 6 months. Cool, huh?
Dana D. attended Excel for Business Fundamentals
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
I took the 1-day Intermediate Excel class in-person at the NYIM center. Garfield is an excellent instructor - engaging and very knowledgeable. It was a small group setting with ~10 people, and we had one-on-one if needed. The space is comfortable with coffee and tea, and computers very good. You are able to access an online version of the training after completing the in person. I would highly recommend this class!
Liz P. attended Intermediate Excel for Business
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
Joe is extremely knowledgeable of excel and can TEACH the material. I loved this class; Joe and five of us. Very intimate, that is what I paid for. His knowledge of excel taught to me and my classmates was great because we all had something to add. I even brought up this class on a job interview. Very satisfied!!!
K.B. attended Advanced Excel for Business Level 2
Joe was really informative, helpful, and made learning not seem so daunting. I like the shortcuts he taught and the class exercises. This helped me grasp the lessons. I would definitely suggest this class/instructor.
M.D. attended Advanced Excel 2003
The course was very informative and the instructor did an excellent job going over the material. I will be looking to attend the additional courses in the nearby future. Thank you.
Anonymous attended Excel for Business Fundamentals
Scott is a really good instructor. One can already tell he's very very knowledgeable about the software he's teaching about.
C.A. attended Excel for Business Level 1
I recently started taking classes at NYIM Training, I have found the instructors to be very knowledgeable and professional. NYIM Training offers a number of different courses which includes SQL, Excel, PowerPoint, AutoCAD, VBA, Photoshop, Illustrator, InDesign, and QuickBooks. The price per course is very reasonable and they offer special pricing if you take a series of 3 courses in one particular subject.
I would highly recommend them.
Rob G. attended Excel for Business Fundamentals
This was an amazing class and the instructor made you want to learn. If you want to learn in a great environment, this is the class for you.
Husniyyah A. attended Excel for Business Fundamentals
We all are in agreement - we loved Joe. Personable and very easy to follow. What a great experience. We did gain all we needed to know.
R. H. of Strategic Insight. attended Excel 2010
The class was amazing and the instructor was superb!
Melissa L. attended Intermediate Excel for Business
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
The session with Joe was very useful, I now have a spreadsheet that not only works extremely well for my needs, but is also one I finally really understand. :)
D.C. attended Excel for Business Level 1
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
Joe was excellent at moving through a lot of information while still stopping to make sure I understood. He was very good at conveying the information.
D.E. attended Excel 2003
I normally hate computer classes BUT this one was so much fun! The time just flew by. The instructor really knew what he was doing and was able to explain things very well. I am coming back for the advanced class. Thank you for the great experience!
J.D. attended Excel for Business Level 1
Joe was an excellent instructor who used real life examples to make the class interesting and helped me follow along. I can't say enough good things about this class especially since I had no experience with Excel before this class.
S.S. attended Advanced Excel for Business Level 2
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
Excel class was so thorough and they send you home with materials to reference. Staff is professional and pleasant. Will definitely send staff for the other classes.
Suzette D. attended Excel for Business Fundamentals
Joe was a very detailed, fun and easy going person. His method is perfect for new beginners. Joe gives you a feeling of confidence. AWESOME CLASS
J.H. attended Excel for Business Level 1
I thoroughly enjoyed my training experience (Excel Bootcamp for Business- Fundamentals, Intermediate, Advanced). The instructors were very informative, thorough and engaging and the tools were invaluable to my day-to-day work in accounting. Would highly recommend this training.
Aaron P. attended Excel for Business Bootcamp
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
I had a fantastic experience in NYIM's Intermediate Excel class. Staff was very helpful in guiding me on which course to take based on my current skill set. Scheduling was easy as there were multiple days, times, and formats offered. I took the course over two weekday nights with Garfield. The facilities are clean and modern and offer complimentary water, coffee, and snacks. Garfield was an expert and made learning excel fun (which is not easy to do). I am able to apply what I learned directly to my work. At the end of the course, they offer a handout, online courses, and a copy of the workbook from the training which makes it an incredible value. Would highly recommend NYIM for any excel training, and will definitely be booking advanced excel courses with them in the near future.
David C. attended Intermediate Excel for Business
This was a really incredible Course. I loved the trainer and everything about it. Thanks for staying after with me. I finally got it.
GEOVANNA F. attended Excel 2003
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
It was extremely beneficial. I walked out feeling more comfortable using Excel. Thank you!
Great instructors, they are patient! The materials are great, and you can retake the class once if you need a refresher! I highly recommend them!
Eun K. attended Intermediate Excel for Business
I purchased the excel for business class and had a great experience. The instructor Jeannette was knowledgeable and made the material interesting.
Francesca S. attended Excel for Business Fundamentals
Marco was a great teacher! Answered all the questions i had from my last class.
Yohani G. attended Advanced Excel for Business Level 2
I enrolled in a beginners Excel training class. I enjoyed the class I learned so much. Things I never knew I could do with excel.
The professor Mr. Garfield was great made it interesting and he is a bit funny too! I will take the class again! :)
Haydee M. attended Excel for Business Fundamentals
My instructor was very knowledgable and a great communicator. Anyone looking to learn Excel from the beginning should take this class as it's a wonderful foundation for learning the program.
Rachael G. attended Excel for Business Fundamentals
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
Scott is a great teacher! He is very detailed with the training and took the time to answer my questions. Very patient and had alot of tips for efficiency!
Nicole R. attended Excel for Mac Level 1
Class was great for a quick overview of Excel tools. It was very helpful.
Jane D. attended Advanced Excel for Business Level 2
Joe made the class interesting and not boring using easy ways to get our attention. The methods he used in class I can remember when I'm using excel at work. He's a very nice teacher. All the best to you. Thank you.
S.E. attended Excel for Business Level 1
Joe was really great. He had a sense of where everyone was in the class and adjusted his methods accordingly. I think he's such a great teacher, I'd love to take the advanced class if this is something he teaches. Thanks Joe!
T.O. attended Excel 2003
I took the Excel 1 class for Mac with Michael M. and I was so happy that I chose NYIM. Michael was a wonderful, patient instructor who answered everyone's questions. Unlike many computer classes, this was a totally hands on experience where you actually performed the tasks you learned. The best part is, they will allow you to retake any portion of the class you have trouble grasping without any additional charge. I intend to take the next level class for Excel and will take other classes as well as I need them. It is nice to know that there is a company that actually teaches in a style that is easy to grasp and has the integrity to offer free refresher.
Mary Ann M. attended Excel for Mac Level 1
I took the Excel for Mac level one class at NYIM with Michael M and he was a fantastic instructor. I left the class amazed with the capability of Excel and excited to to put these new learned skills to good use. Michael was patient, meticulous and very good at explaining how to use the program. I have already recommended this institution to friends and I plan on taking a few other courses in soon time.
David D. attended Excel for Mac Level 1
Very good Excel I class. Michael was clear, thorough, patient and very nice. I enjoyed his class very much and will definitely recommend it.
Robbin B. attended Excel for Mac Level 1
Great training with Michael! Very patient, knowledgeable and informative
Ashley N. attended Advanced Excel for Business Level 2
Had a wonderful experience with Karen! Really engaging, personalized, and professional setting. I plan on taking additional classes and appreciate the wonderful staff and Karen in particular.
Madeleine M. attended Excel for Business Level 1
Joe was very effective, paced the class and was very responsive. Did a good job of identifying specific needs and checking back to be sure they were addressed.
B.H. attended Advanced Excel for Business Level 2
Would give way more than 5 stars if this was possible.
Signing up was easy, and I was emailed confirmation within seconds. I got further email reminders before the date of the actual class. One of the emails said that I did not have to bring anything except myself to the class, meaning that pens, paper, workbooks, coffee and water would be supplied. Do not expect a cappuccino bar, but the fact that there was coffee available was very nice.
Kaye was wonderful and answered any questions I had previous to the class. The teacher Karen was phenomenal. She was very eloquent, clear, patient and knew the material fluently.
She also was extremely helpful and patient with any questions asked during the class.
The price for this class was exceptional. Additionally, there are free retakes for life should you desire that. The school is extremely easy to get to. The building is located right on Union Square. I do not have one negative thing to say about this class or the school. Exceeded my expectations.
Stacey B. attended Excel for Business Level 1
Karen M. was such a fantastic trainer! I took the Advanced Level 2 Business course and came in with Excel research background, familiarity with formulas, search and sort, and graphs/charts. The level was just right for me. Karen showed us so many shortcuts that are going to make my life easier and we did nested formulas that helped me understand the real potential of Excel. We also did worksheet and workbook linking and just learned some of the "rules" there that always throw me off. Karen was fun and kept the class going, there wasn't lag time and I felt I was constantly learning. The pivot table part was awesome--obviously, cuz Pivot Tables are dope! Also, at the end of the class you get to keep your workbook, which is broken down by lessons so it's going to be awesome to have handy. Thanks, NYIM!
Hannah K. attended Advanced Excel for Business Level 2
I had a great experience training with NYIM. Karen was an awesome instructor. Slow enough for you to absorb the info, but kept the class moving swiftly so it didn't drag. I got so much out of it...I think I may do the next level.
Tina C. attended Advanced Excel for Business Level 2
Joe is a good instructor. He does an excellent presentation and makes the course very interesting. He is very observant to see if you're having a problem to be right behind you.
E.H. attended Excel 2003
I had a great experience with NYIM. I took "Fast as Hell Excel" course and really enjoyed it. It was very informative and Joe the instructor knew how to deliver the course in a fun way. I am thinking about taking other Excel classes with NYIM and will recommend it to my friends.
Iryna D. attended Fast as Hell at Excel
Took advanced excel for business. Reference materials are great, instructor (Karen) really knew her stuff and kept the class moving at a good pace without leaving anyone behind. Best instruction be ever gotten on pivot tables. Good intro to macros though I might return for a refresher since it was so new to me.
Rebecca F. attended Advanced Excel for Business Level 2
I just took Excel level 2 a week ago and I've already used so much of what I learned in just one day! Karen did a great job at making sure everyone was together on the right track! The class is definitely fast, but as long as you're pretty familiar with excel, you will stay with her! I learned a lot and cannot wait to go take the level 3 class!
Alara A. attended Advanced Excel for Business Level 2
Joe has total command of his class; He is articulate, his delivery is easy and and he take his time with each student who may need some attention in a specific area. He is a very good teacher. Looking forward to more classes.
C.F. attended Excel for Business Level 1
I took the level 1 class and it was great! Karen was a very well trained and patient instructor, who explained everything very clearly. I also love that they gave us work books to take home, with all the info that we learnt in them. Would definitely recommend to anyone interested in learning the basics and understanding new Excel functions.
Sophie C. attended Excel for Business Level 1
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
This was my second class that I took with NYIM and it was great. Karen, the instructor did a good job explaining the material. I will definitely take more classes with NYIM and already recommended it to my friends.
Thanks NYIM!
Iryna D. attended Advanced Excel for Business Level 2
This training was exceptional thanks to Karen. I feel a lot more confident in excel and thought the class was informative, slow enough so you can pause and retrace your steps, and thorough!
Jackie N. attended Advanced Excel for Business Level 2
Michael is an excellent instructor. This Excel training far exceeded my expectations for a one-day course. Thank you.
Lisa M. attended Excel for Mac Level 1
The training course is a great hands on approach to learning how to use Excel. Definitely would recommend others to take the course. Michael was the instructor for the training course I attended. He was great, very professional, and clear with instructions and guidance throughout the course.
Crystal J. attended Excel for Business Level 1
Loved my Excel level 3 class that I took with Karen! She made it entertaining and all of the material was applicable and very relevant if you are someone who works in excel frequently. Highly recommend this course if you're looking to advance your excel skills and gain efficiency in your job!
Chelsey K. attended Advanced Excel Power Users Level 3
I took the Excel for Business with Garfield. The training is great, detailed and you can do a retake so it is a very good value.
Sharon M. attended Excel for Business Level 1
Great course. Second time taking a training course from NYIM. Took Level 2 Excel Training with Michael. He's a great instructor. Very patient and gives great direction. Would definitely recommend to friends.
Crystal J. attended Advanced Excel for Business Level 2
Very useful and right on point for the excel advance II class. It's definitely worth time and money especially they offer life long free retaking. Michel's class material is well organized and detailed oriented. Comfortable learning environments with no sales pressure. Recommend to take more classes here!
Mei W. attended Advanced Excel for Business Level 2
I took the Excel Level I class with my b/f and we both learned so much! The trainer was very clear and even though helping others in the class occasionally, stayed on point with the training so we all learned the program together.
Jess G. attended Excel for Business Level 1
Took the Excel for business level 2 course with Michael and it was fantastic. Learned great new skills and ways to improve things that I am already doing in Excel. Never thought a 7 hour Excel course would go by so fast.
Michal B. attended Advanced Excel for Business Level 2
Great class, really helpful and quick. I will be back for next levels. Totally recommend.
Cosmin B. attended Advanced Excel for Business Level 2
Joey was fantastic! Very thorough, clear, and hands on. I would highly recommend this class to anyone wanting to sharpen their excel skills.
Jessyca B. attended Advanced Excel for Business Level 2
Joe is great, the class is fun, extremely helpful, and he doesn't leave anyone in the dust.
Jesus Z. attended Advanced Excel for Business Level 2
Garfield is an Excel expert. His course was extremely informative and interesting. I learned many Excel functions within the level one class. Garfield provided one-on-one attention to all of the students, he was attentive, professional and had a great sense of humor. The material was detailed and outlined so that the class was able to follow along seamlessly. The entire staff is friendly and welcoming. I highly recommend NYIM!
Lisa S. attended Excel for Business Level 1
I took Excel for Business 2 with Joe. He was great--very dedicated to the class and wants his students to succeed. I learned a lot and will be back.
Dominika J. attended Advanced Excel for Business Level 2
Great beginner Excel Class. Michael was a patient teacher. It's a lot of info for one class. Should be more time to go over tables, etc., last hour was rushed. I need to practice and they let you retake class until you are confident for Excel II. If you want to learn this program, really good place to go.
Jasia A. attended Excel for Business Level 1
Michael was a great teacher. He was extremely helpful and patient throughout the entire course. Highly recommended.
Jennifer M. attended Advanced Excel for Business Level 2
Great location. Terrific instructor, patient and knowledgeable. Would recommend this school highly for Excel!
Stacey F. attended Excel for Business Level 1
Garfield is a terrific instructor, calm and very very knowledgeable. I would recommend others to take this course.
Jeffrey A. attended Excel for Business Level 1
Michael was extremely informative, engaging, and worked at a comfortable pace. Definitely recommend the course.
Phil K. attended Advanced Excel for Business Level 2
Michael was a great teacher for Advanced Excel for Business. Instruction was clear and thorough and I learned a lot that I will take with me to use on a daily basis! Highly recommended.
Clair W. attended Advanced Excel for Business Level 2
A great class for a deeper understanding of the various function Excel has to offer. Michael was a great instructor!! Thank you Michael!
Lauren S. attended Advanced Excel for Business Level 2
Joe really was awesome. Kept everyone's attention...didn't let anyone fall too far behind...communicated extremely well
D.G. attended Excel 2003
Took the Excel for Business class. I plan on taking Level 2 & 3. Garfield is a great instructor. He was able to adapt to everyone's learning curve and was able to simplify several difficult excel concepts easily. The class is approximately 6hrs, it felt like 2-3. The class keeps you engaged and you will learn new ways of doing things.
Sebastian R. attended Excel for Business Level 1
Joe was clear and used the right terms when giving instruction. I find that verbal cues are often the biggest hurdle when talking about operating a computer: click on the box that does that again is the kind of thing that doesn't work, and something Joe avoided well.
T.S. attended Advanced Excel for Business Level 2
I attended Excel for Buisness 1 instructed by Michael. The detail to content and the support as an instructor was fantastic. I had very limited experience with Excel prior and Michael was very helpful and patient with my limited skill.
I even attended the class again for free! you cant beat that. Class size was also perfect less than 10 attended.
Brendan M. attended Excel for Business Level 1
Michael was an incredible teacher! He was very patient, thorough, kind, and very knowledgeable about Excel. I highly recommend taking his class, or any class with this school! :)
Jennifer B. attended Excel for Mac Level 1
Michael was very clear, informative, and very patient. I would highly recommend this course. Very helpful.
Ji K. attended Advanced Excel for Business Level 2
This class was very very informative, I did the Advanced Excel level 2 class with Michael M. He was very clear and I was able to understand everything he did and follow along as well. I DEFINITELY recommend this class. I am going to go back to do level 3 Excel. I believe it is also very affordable considering the scope of information that is covered in 6 hours.
Pablo E. attended Advanced Excel for Business Level 2
Michael is a wonderful teacher. The course (advanced for business level 2) was challenging, fast paced, and covered a lot of ground for a non-frequent excel user looking to rapidly increase my skill set. The environment was open for questions at any point and Michael was happy to give one on one assistance or review formulas or troubleshoot where needed.
Tina M. attended Advanced Excel for Business Level 2
Michael was very thorough and easy to follow through. Highly recommend!
Helen Y. attended Excel for Business Level 1
Michael was a great teacher and explained things very well. I took the Excel for business level 1 class and definitely need to take the second course. I felt like i knew most of the level 1 material, but still learned a few tricks or things that I didn't know, and I liked that he explained how Excel works so I better understand the logic.
3/27/2017
Chelsea S. attended Excel for Business Level 1
Garfield explained all of the topics very clearly and helped me understand excel functions easily. I'm looking forward to using this in my everyday work environment.
May C. attended Excel for Business Level 1
Fantastic learning experience. Garfield was very patient and insightful. Would highly recommend for any excel user.
Lindsey M. attended Excel for Business Level 1
I took Excel For Business Level 2 sort of as a prerequisite for the Levels 3,4 & 5. I went in thinking that I was very knowledgeable because I'd been working with Excel for YEARS (more than 15 years), but I quickly found out that I didn't know nearly enough. All the new things I learned and will learn in the following courses will definitely make me more efficient at my job and they allowed me to look at information in new ways and with new possibilities. I was stuck doing things the way I've always done them and I'd never taken a refresher course. I recommend NYIM for anyone wanting to update their skills and learn advanced processes in Excel. Michael Magreta was my instructor and he was very proficient and patient. I spoke with Nick S., the office manager and he was able to help me schedule my courses painlessly. My husband needs to take some refresher courses for work and I've already given him the thumbs up for NYIM.
Alicia V attended Advanced Excel for Business Level 2
thank you so much for a very informative and intense class. all of my questions were answered.
Talya L. attended Excel for Mac Level 1
Michael Magreta was such an amazing instructor. We got through the class faster than expected. I use Excel all the time but I learned new tricks I will be putting to use.
Thank you Michael for your time!
Amandalisa V. attended Excel for Business Level 1
Teacher is very available and manages all levels. I was a total beginner and Garfield explains this is a class for total beginners and others should know that. Very helpful.
Liz D. attended Excel for Business Level 1
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
My instructor, Garfield, was extremely helpful - took the time to answer any questions I might have had. He was friendly and very efficient! I highly recommend this course!
Tilde M. attended Excel for Business Level 1
I took an excel class with Garfield. The course was organized logically and efficiently, and was comprehensive. The teaching style was a mix of teaching and hands on exercises. Garfield reinforced what we learned throughout the class. We also got materials to take home. He was patient with the students and answered questions clearly and thoroughly. I was very pleased with the day.
Debra R. attended Excel for Mac Level 1
Another amazing Excel course taught by Garfield. He is one of the best teachers I've ever had---patient, caring, will go over anything you don't understand. If you are considering taking this course, go ahead and do it. The teachers here are phenomenal and you will definitely come away learning a lot.
Stacey B. attended Excel for Business Level 1
Garfield did a great job teaching our class excel. Would highly recommend to folks needing a refresher or to learn some new business skills!
Elliott F. attended Advanced Excel for Business Level 2
I learned so much! I highly recommend Advanced Excel for Business, Garfield was a great teacher!
Miranda B. attended Advanced Excel for Business Level 2
Micheal is a great teacher! Best he goes at a nice clip so I never got bored. Learned an incredible amount in a few hours.
Candice O. attended Excel for Mac Level 1
Garfield is a great teacher and very patient. He really takes the time to answer all your questions and is happy to go over something again if you didn't catch it the first time. I enjoyed the excel level 1 business class he taught and will be going back for sure. I highly recommend the class and suggest you take it with Garfield.
Craig F. attended Excel for Business Level 1
Garfield was very responsive to students' questions/ requests as opposed strictly following the class program. However, I believe that not enough time was allocated to the most challenging portion of the class - pivot tables. Otherwise, I would highly recommend the class.
Maxim N. attended Advanced Excel for Business Level 2
Excel for Business Level 1: Garfield was a great teacher. He was thorough on each topic. The class moved at a good pace and a lot was covered in the day. I will return for the second class.
Mary Kate M. attended Excel for Business Fundamentals
Really comprehensive class. Michael was wonderful!
Margaret G. attended Excel for Mac Level 1
It was a full day from 10am-5, fast-moving and packed with information on all the Excel basics, including on-the-spot exercises. Really useful for skills in managing all kinds of information and projects. I'd highly recommend this course, and would like to take the L2 when I'm ready!
Kathleen H. attended Excel for Business Fundamentals
I loved the class and our instructor Joe. I like the fact that the class was a small group with one on one attention. I never knew how great it was to work with Excel. I wouldn't hesitate to recommend your classes to my co- workers and friends.
R.M. attended Excel for Business Level 1
Michael Magreta is Excellent! This is my 3rd course at NYIM Training - every class offers all that I needed an much much more!
Susan C. attended Excel for Business Fundamentals
Joe, I just wanted to thank you for the class. I got a lot out of it largely due to your structured and well thought- out teaching process. It is especially helpful to have both the Excel spread sheets for class and the tailored Word document as well.
A.C. attended Advanced Excel for Business Level 2
This class was very informative. I would highly recommend it for everyone and anyone whether you're highly experienced in excel, or a beginner. Instructor Michael was very helpful, patient, and answered every question with confidence.
Christopher A. attended Excel for Business Fundamentals
Michael was great with the excel training that was done at my company today. Though I knew basic excel, today I learned new tricks and new functions regarding excel.
Joanna M. attended Excel for Business Fundamentals
Fast-paced class, a lot of information in a short amount of time - condensed to most useful tips and tricks. Very glad I was able to participate as I learned a lot more than I already knew. Michael was a great instructor with a very easygoing vibe.
Roksana B. attended Excel for Business Fundamentals
Great Excel class! I'm a pretty seasoned Excel user, so there were parts that were definitely review, but I still learned a whole lot. Michael kept the pace up, though not too fast, and he wasn't married to his agenda. He was flexible and was willing to answer questions at any time. The course materials were great, too, and there was sufficient time built in for completing exercises. I highly recommend.
Kate S. attended Excel for Business Fundamentals
Joe is definitely a great mentor! Everything was pretty useful information and a great way of grasping the abilities of this program. Having done the beginners class as well, I think they are both great!
P.W. attended Advanced Excel for Business Level 2
Thank you Michael for teaching this course!! Your knowledge of the material really help me to feel confident in taking what I've learned in the classroom and applying it to my newly assigned work projects. I would recommend this class to anyone wanting a better understanding of Excel.
Tracy A. attended Intermediate Excel for Business
I recommend NYIM highly because they are a pleasure to work with. Nick was wonderfully helpful and Michael is a patient excellent teacher. Thanks so much!
Teri B. attended Excel for Business Fundamentals
Great Excel Training! Garfield does a great job at instilling actionable tips and shortcuts that can really be used ASAP! Would recommend to anyone looking enhance their skillset!
Aston F. attended Intermediate Excel for Business
Great school and Garfield is my favorite teacher. I've taken 2 excel classes with him and it's been very helpful. He is very clear and explains all the ins and outs.
Emily I. attended Excel for Business Fundamentals
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
I retook this course. Garfield did not teach my first course but he taught my second course. He is a fantastic teacher. He is so clear and methodological. I highly recommend this class.
Dominika J. attended Intermediate Excel for Business
Joe is really smart and VERY helpful! I loved all of it - and I loved the workbook/worksheet we get to go home with...Really great! I had a great time...and I learned a lot of useful information.
R.M. attended Advanced Excel for Business Level 2
One-on-one Excel training with Garfield was amazing. Would highly recommend Garfield and the NYIM for any kind of Excel training or support.
Janet W. attended Excel for Business Fundamentals
Just finished excel level 2 class. Went to review my excel skills before starting new job but ended up learning new tricks and functions also. The lecturer (Garfield) was very calm,kind, and informative. Thank you, Garfield!
Bokyong A. attended Intermediate Excel for Business
I took an amazing class with Michael. He is a great instructor and the course curriculum is very hands on. Thank you NYIM!!!
Joe K. attended Excel for Business Fundamentals
Garfield is an outstanding teacher who instructs in Excel in a logical, concise & easy to understand manner. He is also kind and affable. The school is run very well by Nick and they offer candy, coffee and hot chocolate! Michael is also a very good instructor & I now know enough Excel to work anywhere -- in just 2 sessions!!
Georgiana E. attended Excel for Business Fundamentals
The whole class was practical. I liked the fact that we had a small group. We received a lot of one-on-one attention from Joe and could really focus on the key items that we wanted to learn from the class.
J.A attended Excel for Business Level 1
The instructor Garfield was patient, informative and precise!
Lisa N. attended Intermediate 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
It was just perfect, I can't thank you enough!! I learned faster than expected and handed in the documents ahead of schedule. IT WAS A GREAT EXPERIENCE, I would recommend Excel private training to everyone!!
M.L. attended Advanced Excel for Business Level 2
Just wanted to let you know that you made another happy customer. My class with Joe was everything I hoped it would be, and more. He is a superb teacher, not merely with respect to his technical expertise, but very pleasant and patient! I will sort out my schedule soon, and sign up for Advanced Excel. Thank you for all your help.
C.M. attended Excel for Business Level 1
Garfield and Michael were great, did the bundle, both were very generous with their time and explained information thoroughly.
James B. attended Excel for Business Bootcamp
Had an amazing experience taking Excel for Business Level 2 at NYIM. The excel class helped me get back up to speed on a ton of fundamental techniques and short cuts, and the instructor was awesome. They even gave us videos to look at after we finished the class for some extra help on our own time. The actual location was convenient and comfortable, they gave us coffee tea and chcocolate- an overall great experience. Will definitely be going back for level 3.
Eddie H. attended Intermediate Excel for Business
Took a retake of Excel class with Garfield. He is the best. He is patient, focused and explains everything in the clearest and easiest to understand manner. Beginners and experts will be equally impressed with his teaching ability. If you want to learn Excel or just refresh, Garfield is your guy!
Stacey B. attended Excel for Business Fundamentals
Garfield was very knowledgeable and took his time working with my group. Whenever one of us didn't understand he was more than happy to slow down and figure out where we were confused. Definitely recommend this place!
Sanura D. attended Intermediate Excel for Business
I had a great experience in my level 2 Excel for business course. The instructor, Garfield, was very knowledgeable and patient with questions. He taught all the sections effectively and I really feel like I learned a lot from that one day session.
NYIM has a really nice facility with modern computers (Macs too). The fact that they give you the chance to re-take a class free of charge within a year after the first one is amazing. I highly recommend their courses and will definitely be taking another class, or two!
Tessa P. attended Intermediate Excel for Business
Great experience, I highly recommend for anyone looking to break into consulting/banking!
Thomas P. attended Financial Modeling Bootcamp
Joe- Easy to understand, very helpful, very nice. Lots of knowledge. The best!!!!
J.H. attended Advanced Excel for Business Level 2
I liked the instructor. I thought Joe was friendly and knowledgeable, and also very helpful with questions we had. He really made himself available if anyone needed extra help throughout the day.
E.K. attended Advanced Excel for Business Level 2
Joe - you were awesome. I loved the fact that you made it so much fun and so laid back and yet so informative. I especially appreciated your patience and your ability to tell when we needed a break! A+ and definitely recommended to others.
Group courses, custom training, and certification classes
NYIM's Microsoft Excel courses are guaranteed to increase your daily productivity, from functions and formulas to Pivot Tables, Macros, and various time-saving techniques. Quickly summarize and analyze a database with Pivot Tables; automate your work with macros and VBA; extract data with VLOOKUP, SUMIFs, and more advanced functions; use Paste Special and Hot Keys to breeze through your work. We have the perfect course or private training for everyone, with classes scheduled on weekdays, weeknights, and weekends, at our Manhattan location.
Revolutionary Excel Video Suite
Each of our Excel for Business classes includes our revolutionary Excel video suite with several hours of premium content. Review the course materials with high-quality video with lifetime access on desktop, tablet or mobile, a $95 value, included free with select courses:
Excel for Business video suite ($95 value, included with Excel Fundamentals)
Intermediate Excel for Business video suite ($95 value, included with Intermediate Excel & Fast as Hell at Excel)
Advanced Excel for Business video suite ($95 value, included with Advanced Excel)
Microsoft Excel Training Benefits
Practical and hands-on training focused on real-world applications of Excel
Classes are taught by the top Excel experts in New York
Revolutionary Excel video suite with several hours of premium content: watch on phone, tablet, or desktop with lifetime access
Free Retake within six months of the class
Proprietary Excel course manual & shortcut sheets
Small class sizes for personalized attention
Comprehensive Excel offering with weekday, weeknight & weekend options. Most available Excel classes in Manhattan.
Learn Excel in Workshops, Bootcamps & Certification Programs
Microsoft Excel Workshops
Our introductory Excel workshops are the perfect way to get started or upgrade your Excel skills. Our most popular workshops are Excel for Business Fundamentals, and Intermediate Excel for Business, which can be taken in a full day (weekday or weekend), or over two nights. Those looking for more comprehensive training or certification should attend our Excel for Business Bootcamp or various certification programs.
Microsoft Excel Certification Courses
NYIM offers comprehensive Excel certification training, which includes group classes, private training, and the exam with a free retake. Boost your credentials today and get certified with our Excel Specialist and Excel Expert certification packages. We offer weekday, weeknight, and weekend Excel classes and private tutoring options, so you can get certified on your schedule. We will also administer the certification exam at our location, and provide a comprehensive Excel video suite to reinforce concepts learned in class.
Advanced Excel Classes
For those with intermediate knowledge in Excel (including formulas, functions, Pivot Tables, and graphs), jump into our advanced Excel courses.
Advanced Excel for Business covers advanced nested functions, including INDEX-MATCH, sensitivity analysis tools, macros, and more.
Learn to automate your workflow with Excel programming language, Visual Basic for Applications, in our VBA classes.
For those looking for or starting a career in finance, our Financial Modeling Bootcamp covers the essential modeling, finance and accounting skills you need to succeed as a financial analyst. We also offer an Advanced Excel for Finance course which covers financial functions and advanced Excel techniques and shortcuts used by finance professionals.
Corporate Excel Training
Onsite Excel Courses in NYC, Newark, Jersey City, Long Island
Over two decades, NYIM has served the most prestigious businesses and institutions across the United States with its industry-leading Excel corporate training programs. We provide several training options for clients in the Tri-State area. For custom training, you'll consult with the instructor to set the agenda at no additional cost.
Standard Excel training at our location or onsite
Custom Excel training at our location or onsite
Group class vouchers: Purchase vouchers and send employees to our regularly-scheduled group classes
We'll come onsite to your offices with no travel charge at any of these locations: Manhattan, Brooklyn, Bronx, Queens, Newark, Jersey City, & Long Island.
For a small travel charge, we will come onsite to Philadelphia, Stamford, Boston, and other East Coast locations.
Quickly compare our Excel classes with these downloadable PDF outlines.
Become an advanced Microsoft Excel user in just three days. Begin with data entry, charts, and essential shortcuts in Excel Fundamentals. Go to the next level with Pivot Tables and VLOOKUP in Intermediate Excel. Automate your workflow by recording macros in Advanced Excel. You'll learn everything you need to know to become an Excel pro.
Master the core Microsoft Excel functions in this one-day course. Automate calculations and data entry. Apply formatting to text and cells to make your spreadsheet scannable and visually appealing. In this hands-on training, you will learn all the basics to use Excel as your primary data processing tool. You'll produce polished and print ready spreadsheets while learning tricks to accelerate your workflow.
Go from beginner to experienced professional: summarize data with Pivot Tables, write advanced functions including VLOOKUP, and learn techniques to expedite your workflow. Use tools and formulas to format text. Manipulate data visuals with advanced charting skills. Use statistical formulas like COUNTIFS and SUMIFS to learn more about your data. At the end of intermediate Excel, you'll unlock powerful techniques that will help you complete tasks more quickly.
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.
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.
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 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.
Fast as Hell at Excel® is NYIM's revolutionary course that will increase your productivity and efficiency in Excel. Become faster with navigation, formulas, formatting, calculations, and Hot Keys. Learn some creative time-saving (and sometimes life-saving) techniques using applications of Paste Special, Go To Special, Find & Replace, and Macros.
By the end of this course, you'll have the tools, tricks, and techniques to breeze through your workload, impressing colleagues and cutting down hours of unnecessary work.
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 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 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.
What do you want to learn in Excel? The Complete Topic Guide for our Excel for Business Series
Microsoft Excel is perhaps the most powerful applications used by business professionals today. With so many functions and features, it might be daunting to get started. This guide will give you a brief overview of what Excel can do and which course would be the right fit you.
Data entry & Calculations: Excel is an extremely powerful tool for calculations. Get started using spreadsheets and performing calculations. Create budgets, track expenses and projects, and more.
Autofill: Save time by allowing Excel to complete patterns for you.
Quick Access Toolbar: This allows users to save time by bookmarking commonly-used commands and "pinning" them to the top bar.
AutoSUM Functions: Learn Excel's key functions, including sum, average, max, min, and count.
Text Functions: Use a variety of functions to format and correct text. Change the case of text, trim unnecessary spaces, and pull the first or last characters from a cell.
Formatting: Create polished and presentable work by changing fonts, colors, alignment, and more. Learn shortcuts to format quickly.
Format painter: Use this tool to copy the format from one cell and quickly apply to other cells.
Absolute cell references: Make your Excel formulas more dynamic by "locking" cells that remain constant across calculations. For example, when calculating the sales tax for multiple products, "lock" the sales tax rate to avoid retyping the formula.
Conditional formatting: Set predefined formats based on values. For example, format any cells greater than 100 with a light red fill. Add icons and bars to visually represent the contents of a cell.
Charts: Visualize and summarize data with dynamic charts. Learn the essentials of creating and formatting charts, including line charts, bar charts, and pie charts. Format the axes, add data labels, change the chart theme, and more.
Navigation shortcuts: Navigate around the worksheet fluently without using the mouse using CTRL, SHIFT, HOME, END and the arrow keys. Move quickly between tabs.
Navigation within cells: Navigate, highlight, and edit data with cells. These shortcuts will help you efficiently work with text across all the major Microsoft applications.
Split and Join text: Split text to multiple columns with Text to Columns, and join text with the CONCAT function (or by using "&").
Dropdown menus: Create drop-down menus and restrict unwanted data entry with Data Validation. Create custom error messages and alerts.
Sort & Filter: Within Excel databases or tables, sort alphabetically, largest to smallest, or with a custom sort. Filter the data to show records that meet specific criteria. For example, show employees who salaries are greater than $50,000 and who work in the New Jersey office.
VLOOKUP: Retrieve a value from a table based on the value in the first column. For example, retrieve the name associated with customer ID 74 (where the customer ID is in the first column.
IF Statements: Write formulas that show different outputs based on a condition. For example, if the employee worked less than 40 hours, show "No overtime", and if the employee worked more than 40 hours, show the number of hours overtime worked (hours worked minus 40).
SUMIFS: Sum values that meet one or more conditions. For example, the total employee salaries who work in accounting and in the Northeast region.
COUNTIFS: Similar to SUMIFS, COUNTIFS will count the number of items that meet one or more criteria. For example, the number of employees who work in the finance department.
Pivot Tables: Summarize and visualize data with Pivot Tables. For example, consider an Excel table that shows a log of t-shirt sales, with each record containing a price, size, sales rep, sale date, and customer. With Pivot Tables, you can quickly show the total amount of sales by size, the number of sales made by a specific sales rep, the sales by month or quarter, and so much more.
Advanced Cell Locking (or Anchoring): In beginner Excel, we reviewed how to perform absolute cell references where the row and column are locked. In advanced Excel, we learn mixed cells references, which locks the row or column.
Hot Keys: Work in Excel without using the mouse by activating Hot Keys. Essentially, any command in Excel can be reached by a series of keyboard strokes. Learning these shortcuts will substantially expedite your workflow. For example, center align text with ALT + H + AC.
Cell Auditing: Review your formulas for errors, and trace dependents and precedents. These tools allow users to track their formulas and spot errors.
Conditional formatting with formulas: In the introductory Excel course, we reviewed basic conditional formatting. In advanced Excel, we make our conditional formatting more powerful by formatting cells based on a formula. For example, format cells that are greater than the value in cell C35 with a light red fill.
Nested IF Statements: In intermediate Excel, we cover IF statements, which allow for two options (value if True or value if False). By using Nested IFs, or an IF statement within another IF statement, we can create formulas that allow for multiple options. For example, if A1=1, then show "Base", if A1=2 show "High", if A1=3 show "Low."
IF Statements with AND/OR: This allows us to expand the capabilities of the logical test, the first input in the IF function. For example, for an employee to get a raise, they have to have a 4.5-star review AND have taught more than 200 students. If they are entitled to a raise, the raise should be 5% of their salary, and if not, the raise is equal to 0. The AND function allows us to specify that two or more conditions need to be met, while OR tell Excel that only one of two or more need to be satisfied.
Goal Seek: This is a powerful calculation tool that allows the user to change an input to achieve the desired output. For example, change the score on the final exam so that the student's cumulative average is equal to 90 (in Goal Seek, it would be: set the Average to 90 by changing the final exam score.)
Data Tables: With Data Tables, you can sensitize, or change, one or two inputs and show how that impacts a specified output.
Pivot Charts: Once the data is summarized with Pivot Tables, we can use that summary to create charts.
VLOOKUP-MATCH: Make the VLOOKUP function more flexible and dynamic by adding the MATCH function for the Column input.
INDEX-MATCH: Create a more flexible lookup function by using INDEX. This allows users to "lookup backward" which the VLOOKUP cannot do.
INDEX- Double MATCH: Use two MATCH's in the INDEX function to create the most powerful and dynamic formula to extract data from tables.
Recording Macros: Record macros to automate a series of actions that are frequently repeated.
There are a lot of options available when looking to learn Excel. What separates the programs from one training center from another? There are a variety of factors that can come into play, and it is worth taking a little bit of time thinking about what you want from your training experience.
Each course at NYIM includes the Excel workbook file that you use during the course and an accompanying manual that describes each exercise in detail. You’ll have the expertise and diversity of the Excel instruction team, which is not composed of full-time Excel trainers, but rather industry professionals that have transitioned to the instructor role from a large variety of backgrounds and companies. This same team meets regularly to discuss updates and changes to our Excel curriculum to provide a service we can all be proud of.
There are also after-class resources for students included. Each student at NYIM is entitled to a free retake of the course. Students that take advantage of this often cite the need to refresh their skills periodically—especially those skills that they do not use regularly in their careers.
Beyond the free retake, we also provide lifetime access to an online video suite of the same content. The video suite allows users to watch individual videos (and download the individual worksheet files) or to retake the entire course online, as often as they wish. Excel is easily one of the best forms of professional development in terms of return on investment.
At NYIM we also focus heavily on efficiency. Our courses are logically organized with demonstrations, practice, and independent mini-projects strategically placed throughout. Our goal is not just for you to learn, but for you also to retain what you learn and our learning model supports this.
Here are some brief Excel video tutorials and topic overviews that will give you a sense of the powerful things you can do in Excel. This will also show you which Excel classes cover certain topics
Note that these are overview videos. Our in-person Excel workshops in New York City are hands-on with real-world examples to reinforce these concepts.
Intro to Excel Workshop Overview Video
This video will recap some of the essential concepts we'll cover in our beginner Excel class (Excel for Business Fundamentals), including formulas, charts, Autofill, absolute cell references, conditional formatting & more.
Learn Database Functions in our Intermediate Excel Class
In this video, we'll cover some essential database functions, including VLOOKUP, SUMIFS, and COUNTIFS. These functions will allow you to extract important data from tables.
Discover Crucial Text Functions & Techniques
Learn essential techniques to work with text, including creating drop-down menus with Data Validation, splitting text (Text to Columns), joining text (CONCAT function), removing duplicates, and capitalizing certain letters.
Pivot Tables
Pivot tables allow you to quickly summarize and organize data from larger databases. In our intermediate class, we introduce the basics, including creating a Pivot Table, adding slicers, and using calculated fields. In our advanced class, we learn to perform calculations within Pivot Tables as well as create charts with the data.
NYIM's Pivot Tables & PowerPivot class is perfect for those who deal with Pivot Tables regularly. You'll cover the essentials as well as PowerPivot, an Excel add-in that expands functionality
LOOKUP Functions
VLOOKUP is one of the most popular and essential functions in Excel, which allows users to extract data from tables. You can learn VLOOKUP and HLOOKUP with several practice exercises in our intermediate Excel course. In the advanced Excel class, you learn to add the MATCH function to expand VLOOKUP capabilities. We also cover INDEX and MATCH functions.
