Intermediate Excel for Business
Master VLOOKUP, Pivot Tables, formulas and functions in this hands-on course. Learn the essential Excel skills with real-world projects from the experts.
Master VLOOKUP, Pivot Tables, formulas and functions in this hands-on course. Learn the essential Excel skills with real-world projects from the experts.
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 for Business is rated 5.0 stars
in the past 24 months
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.
The class was amazing and the instructor was superb!
Melissa L.
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.
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.
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.
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.
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.
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.
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.
The instructor Garfield was patient, informative and precise!
Lisa N.
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.
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.
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.
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.
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.
I feel confident about VLOOKUPs now after attending this course.
Alexandra C.
Lazard Asset Management
Michael covered all of the content I expected, as well as content I didn't expect, but found valuable. Workshop was practical, and the nature of the problem sets were relevant to the business world, which I appreciated. Also really appreciate that you guys provide access to a digital course for our review, and a 6 month retake policy. That's very generous.
Renee E.
Bionic
I've been taking classes here over the course of many years. Convenient location, class schedule availability, individual attention, reasonably priced. Great opportunity if you want a classroom setting.
Phyllis O.
This class was the perfect balance between learning new and reviewing some old topics. Garfield was very informative, but had a good sense of humor and real world examples.
Rebekah R.
Hyatt Hotels
I would recommend anyone to this class whoever is trying to learn excel, even though it is very critical but once you get the hold of it it is easy
Mohammed B.
JobDiva
Instructor really help you understand the functional process of excel. If you need to learn excel, this is place to take it!
Judie U.
Allied Partners
Training here has changed my life. The instructor's attention to detail has allowed me to pinpoint and execute a plethora of topics. I am ready for everything ahead.
Joseph S.
Boston College
The Intermediate Microsoft Excel Class for Business was very informative and helpful. I can take the knowledge I obtain and apply it to my project immediately.
Carl S.
veyr informative, and the teacher made sure everyone was up to speed!
Lissette W.
Stellar Works
Anyone in financial services should take this course - very helpful!
Harim J.
Schonfeld
Very good intermediate level class. Easy understanding of more complicated topics as VLOOKUP and IF STATEMENTS. The teacher is very knowledgeable and easy to talk to.
Ivonne E.
Group SJR
NYIM Excel for Intermediate Business may be the reason I don't lose my job! It was efficient, to the point, covered all areas and more. I am so happy to have taken this course; most importantly, it provided a lifetime support that sets me up for success outside of the course.
Erika R.
The training I took was INCREDIBLY helpful. I took Intermediate Excel for Business online with Garfield as the instructor. The material covered in the course was uncannily relegated to my business on a day to day basis. I could not speak highly enough of Garfield as an instructor. He effectively explained all material by walking us through each step and using helpful analogies for us to have a stronger understanding of when you would use each tool. As an online course, he made sure everyone was engaged and was patient yet timely to reexplain something if people had questions. Garfield was kind enough to make himself available for me after the course as I was struggling with a challenging and important excel file I was working on. He let me share my screen with him and explain what I needed help with. His help with this file and the tools I gained from his instruction very likely are the reason I saved my job. Thank you NYIM and Garfield. If you are looking to increase your excel skills THIS is the company you should invest your time in.
Erika R.
Pretty seamless! I enjoyed it a lot more than expected. Highly recommended!
Mikhaila F.
Tishman Speyer
I've taken other computer instruction courses and I can't think of any of them that provided an answer key or videos for later viewing. Sooo helpful. Also, I loved the number of classes offered on a regular basis. This was a class I needed right away.
Stephanie S.
The course was very informative and the instructor was fantastic. Garfield is knowledgeable, professional and has a great balance of learning with humor.
Roseland O.
HarperCollins Publishers
Garfield was very professional and look forward to other classes conducted by him.
Miya K.
Worth every minute. It will make you more confident in your work ability.
Frederick J.
Rolex
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!
Annie S.
New York Public Radio
Totally recommend to take it. I already know what I will be using starting tomorrow in my work.
Mila K.
JCCGCI
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.
Mariclare M.
Natixis North America
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!
Mordy L.
Hadar
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.
Jami S.
Brightree
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.
Taniqua B.
Namaste Laboratories
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.
Paula G.
Lime Brokerage LLC/Lightspeed Financial Svcs Group
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.
Brooke S.
The class was valuable and comprehensive, and the instructor was knowledgeable yet patient with every learner.
Aidan S.
JBJS
Great pace, instructions and applicable for business setting. It helped me understand how to set up my Excel sheets to be more practical.
Wendy C.
NYU Langone Health - Rusk Rehab
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.
Alix S.
International Rescue Committee
I highly recommend this class and the instructor. It will definitely add to your knowledge base, even if you are an experienced user.
Cassandra G.
Seton Hall University, Pre-Medical/Pre-Dental Plus Program
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.
Su C.
AG Consulting Partners
Adebayo was really helpful. I learned a lot that I did not know prior to taking the class.
Elhaji D.
NYU Langone Health
Very well paced, easy to follow Excel class!
Elle X.
Excel class worth taking.
Janice R.
Village Care Max
Thorough, patient, and enthusiastic instructor; super helpful Excel tips for business.
Mia M.
NYU Langone
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!
Ashley D.
NYC Service
Life-changing, super helpful! I loved the energy the instructor, Mike, had. It was very interactive and informative. Learned a lot :)
Melissa G.
We could ask as many questions as necessary, and Garfield answered them all.
Catia F.
Brookfield
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.
Cora W.
NYC Service
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.
Maria C.
N/A
As one of our smaller courses, tuition for this course is due in full before the start date. The best way to save on this course is to take it as part of a certificate program.
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.
We don’t currently offer discounts as we do our best to affordably prices our courses.
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 via Zoom. 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 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 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 payments 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:
Select up to two courses and tap Compare selected courses to view a side-by-side comparison of Intermediate Excel for Business with your selected courses.
Become an advanced Microsoft Excel user in just three days. This Excel Bootcamp includes 18 hours of hands-on training in formulas, functions, Pivot Tables, macros & more.
Learn all the basics to use Excel as your primary data processing tool. Create charts and tables, get started with formulas and functions, and format and print your output.
Become an Excel guru in this hands-on advanced training. You'll make functions more flexible, take Pivot Tables to the next level, automate tasks with macros, and learn advanced analytical tools.
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.
Purchase group class vouchers at a discount for our regularly-scheduled group classes in NYC, or create a custom training program at your offices.
We’ve trained thousands of companies!
Let us create the perfect program for your team.
Are you comfortable with the essential functions of Excel, such as entering data, basic calculations, and formatting spreadsheets? If so, there’s a lot more Excel can do to help with your business needs. In this intermediate course, you’ll learn the following skills:
Intermediate Excel for Business covers the essential applications of Excel used frequently by business professionals. This course is perfect for those with an understanding of basic formulas and functions, charts, and workbook management techniques. In this intermediate-level course, you will learn Pivot Tables, summary tables that calculate statistics and essential information from massive datasets.
If you’re using Excel to manage large datasets, Intermediate Excel will help you manage data better with lessons on basic database functions. Intermediate Excel also covers VLOOKUP and HLOOKUP to query columns and rows. We will show you crucial database management tools including Named Ranges, Sort & Filter, and Data Validation to help you enter data quickly and efficiently.
Throughout the class, we'll show you tricks and techniques to speed up your workflow, including navigational and keyboard shortcuts. In this hands-on course, you will work on real-world examples, reinforcing the concepts with practice throughout the class, as well as a cumulative project at the end.
Our Excel video suite provides premium video lessons for Excel students. Review the course materials anytime you need a refresh with high-quality video and lifetime access on desktop, tablet or mobile. Intermediate Excel students receive the video suite, a $95 value, completely free with course sign up.
Do you want to improve your abilities in Excel? Our Intermediate Excel for Business course is the perfect option. This course offers comprehensive training in Excel with hands-on exercises in our custom workbooks. You’ll leave this class with confidence and eager to demonstrate your knowledge of Excel at work!
Worksheet Management begins with Navigation techniques. To save time switching between keyboard and mouse, you can apply basic keyboard shortcuts to navigate around worksheets. You don’t need the mouse to highlight or move text from one cell to another. Paste Special, which illustrates how to copy data, formatting, and even formulas from one cell to another with a quick keyboard shortcut.
What if you put the first and last name of each client in one cell, but want to divide them into two cells? If you have 200 clients in one Excel spreadsheet it could take hours. Do you have to copy and paste text from one cell to another? Not with Intermediate Excel functions!
Split Text from one cell into multiple cells by using the ribbon and Join Text from multiple cells into a single cell with CONCATENATE and the ampersand “&”. You can also make calculations easier by using Named Ranges to classify an individual cell or a range of cells.
Keeping your data organized is essential to perform calculations and other data functions in Excel. Data Validation formats cells with a drop-down menu, thereby restricting the data that can be entered into a cell.
Sort & Filter will show you how to organize and search your data efficiently. Remove Duplicates demonstrates Excel’s ability to quickly examine a set of data and eliminate any duplicate rows.
Database Functions help you find data within the Excel worksheet quickly. For example, you may look up a product code, and return the name or the cost of that product. The VLOOKUP is easily considered the second most important skill in Excel and helps you find data within columns. HLOOKUP is used to find data within rows.
Logical functions help you find data that meets certain criteria. For example, with the IF statement you can design a true/false test and designate specific actions to perform for both true and false results. This powerful ability allows a single cell to offer two different outcomes. AND/OR functions build on the basic True/False property by implementing multiple logical tests to determine in a statement is true.
Pivot Tables are easily the most-sought-after skill in Excel. Pivot Tables are another way to analyze data in Excel through both consolidation and analysis. With the Grouping technique, you can consolidate row and column data into groups. You can also create Multiple Pivot Tables on the same worksheet page.
It’s hard to keep track of data within large datasets. The RANK.EQ, COUNTIFS, and SUMIFS provide additional information on data position and count within an Excel worksheet. Combo Charts are a unique visualization tool that allows Excel users to combine two charts.
At NYIM, helping professionals master Excel quickly and efficiently is our #1 priority. We offer a variety of benefits to ensure every student succeeds. When you attend classes at NYIM you’ll find small class sizes, a modern computer lab with PCs and Macs, and patient instructors that ensure everyone understands.
We also provide a free course retakes for all courses include Intermediate Excel. After the course, take time to practice and reinforce what you’ve learned with your Excel workbook. Take your Intermediate Excel course again within six months absolutely free of charge!
This policy was updated on August 14, 2018.
Your privacy is important to us. It is the policy of NYIM Training to respect your privacy regarding any information we may collect from you across our website, https://training-nyc.com, and other sites we own and operate.
We only ask for personal information when we truly need it to provide a service to you. We collect it by fair and lawful means, with your knowledge and consent. We also let you know why we’re collecting it and how it will be used.
We only retain collected information for as long as necessary to provide you with your requested service. What data we store, we’ll protect within commercially acceptable means to prevent loss and theft, as well as unauthorized access, disclosure, copying, use or modification.
We don’t share any personally identifying information publicly or with third-parties, except when required to by law.
Our website may link to external sites that are not operated by us. Please be aware that we have no control over the content and practices of these sites, and cannot accept responsibility or liability for their respective privacy policies.
You are free to refuse our request for your personal information, with the understanding that we may be unable to provide you with some of your desired services.
Your continued use of our website will be regarded as acceptance of our practices around privacy and personal information. If you have any questions about how we handle user data and personal information, feel free to contact us.
By accessing the website at https://training-nyc.com, you are agreeing to be bound by these terms of service, all applicable laws and regulations, and agree that you are responsible for compliance with any applicable local laws. If you do not agree with any of these terms, you are prohibited from using or accessing this site. The materials contained in this website are protected by applicable copyright and trademark law.
In no event shall NYIM Training or its suppliers be liable for any damages (including, without limitation, damages for loss of data or profit, or due to business interruption) arising out of the use or inability to use the materials on NYIM Training’s website, even if NYIM Training or a NYIM Training authorized representative has been notified orally or in writing of the possibility of such damage. Because some jurisdictions do not allow limitations on implied warranties, or limitations of liability for consequential or incidental damages, these limitations may not apply to you.
The materials appearing on NYIM Training’s website could include technical, typographical, or photographic errors. NYIM Training does not warrant that any of the materials on its website are accurate, complete or current. NYIM Training may make changes to the materials contained on its website at any time without notice. However, NYIM Training does not make any commitment to update the materials.
NYIM Training has not reviewed all of the sites linked to its website and is not responsible for the contents of any such linked site. The inclusion of any link does not imply endorsement by NYIM Training of the site. Use of any such linked website is at the user’s own risk.
NYIM Training may revise these terms of service for its website at any time without notice. By using this website you are agreeing to be bound by the then current version of these terms of service.
These terms and conditions are governed by and construed in accordance with the laws of New York and you irrevocably submit to the exclusive jurisdiction of the courts in that State or location.
The first installment is due one week before the first class. Subsequent installments are spread out evenly across the duration of the course.
Installments | |
---|---|
10% non-refundable deposit | |
$249.00 | Total You Pay |