Classes available in-person (strict social distancing) or live online with an extended free retake period. See details.

Intermediate Excel for Business in NYC or Live Online

Master VLOOKUP, Pivot Tables, formulas and functions in this hands-on course. Learn the essential Excel skills with real-world projects from the experts.

View Schedule & Enroll

Go from beginner to experienced professional: summarize data with Pivot Tables, write advanced functions including VLOOKUP, 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.

Save 15% on Enrollment with Excel Bootcamp

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.

This course has a prerequisite

Attendees must have beginner Excel skills equivalent to our Excel Fundamentals course, including basic functions and formulas, printing, formatting, basic charts, and tables.

What You'll Learn

Navigation tricks & shortcuts
Summarize data with Pivot Tables
VLOOKUP function
Join and split text
Create drop-down menus
Sort & filter data
Tricks to speed up workflow
Logical functions: IF, AND, OR

Upgrade to a bootcamp or certification program and save on tuition

Excel for Business Bootcamp Sign up
Excel Specialist Certification Program Sign up
Data Analytics Bootcamp Sign up

Learn the Skills Guarantee™

Hands-on Training in small groups

Work on projects proven to boost retention
Video Training & Workbook Included

Students get a workbook and lifetime access to self-paced training videos, a $95 value.
Learn from industry experts with teaching experience

Experienced educators who are driven to help you succeed
Retake the course for free within one year

Refresh the course materials and gain additional practice
Setup Assistance Provided

Prior to the course, we will help you get set up properly with the software you need.

Learn the concepts and skills covered in this course or your tuition is on us. See details and terms & conditions.

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.

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. attended Intermediate Excel for Business

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

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

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

Excel class worth taking.

Janice R. attended Intermediate Excel for Business

Very well paced, easy to follow Excel class!

Elle X. attended Intermediate Excel for Business

Adebayo was really helpful. I learned a lot that I did not know prior to taking the class.

Elhaji D. attended Intermediate Excel for Business

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. attended Intermediate Excel for Business

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. attended Intermediate Excel for Business

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. attended Intermediate Excel for Business

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. attended Intermediate Excel for Business

The class was valuable and comprehensive, and the instructor was knowledgeable yet patient with every learner.

Aidan S. attended Intermediate Excel for Business

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. attended Intermediate Excel for Business

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. attended Intermediate Excel for Business

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. attended Intermediate Excel for Business

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. attended Intermediate Excel for Business

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. attended Intermediate Excel for Business

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. attended Intermediate Excel for Business

Totally recommend to take it. I already know what I will be using starting tomorrow in my work.

Mila K. attended Intermediate Excel for Business

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. attended Intermediate Excel for Business

Worth every minute. It will make you more confident in your work ability.

Frederick J. attended Intermediate Excel for Business

Garfield was very professional and look forward to other classes conducted by him.

Miya K. attended Intermediate Excel for Business

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. attended Intermediate Excel for Business

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. attended Intermediate Excel for Business

Pretty seamless! I enjoyed it a lot more than expected. Highly recommended!

Mikhaila F. attended Intermediate Excel for Business

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. attended Intermediate Excel for Business

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. attended Intermediate Excel for Business

Anyone in financial services should take this course - very helpful!

Harim J. attended Intermediate Excel for Business

veyr informative, and the teacher made sure everyone was up to speed!

Lissette W. attended Intermediate Excel for Business

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. attended Intermediate Excel for Business

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. attended Intermediate Excel for Business

Instructor really help you understand the functional process of excel. If you need to learn excel, this is place to take it!

Judie U. attended Intermediate Excel for Business

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. attended Intermediate Excel for Business

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. attended Intermediate Excel for Business

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. attended Intermediate Excel for Business

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. attended Intermediate Excel for Business

I feel confident about VLOOKUPs now after attending this course.

Alexandra C. attended Intermediate Excel for Business

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

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

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

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

The instructor Garfield was patient, informative and precise!

Lisa N. attended Intermediate Excel for Business

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 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

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

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

The class was amazing and the instructor was superb!

Melissa L. attended Intermediate Excel for Business

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

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

49 Students gave Intermediate Excel for Business a 5-star rating

Full Course Syllabus

Download PDF Outline

Worksheet Management

Navigation

Keyboard shortcuts that facilitate quick and easy navigation around the worksheet

Paste Special

Use Paste Special to apply formats, as well as perform calculations on selected cells

Working with Text

Splitting Text

Use Text to Columns to split text into multiple cells

Joining Text

Join text from separate cells

Named Ranges

Assign a name to a range of cells to make it easier to reference those ranges in calculations

Data Validation

Create a drop-down menu to make data entry quicker and more efficient

Sort & Filter

Use Sort & Filter to find and organize data in large databases

Remove Duplicates

Use Remove Duplicates to eliminate duplicate data

Database Functions

VLOOKUP

Use Vlookup to find information in one column and return information from another column

HLOOKUP

Use Hlookup to find information in one row and return information from a second row

VLOOKUP - Closet Match

If an "Exact Match" cannot be found, Vlookup can still be used to find the closest match

Logical Functions

AND, OR

Tests to see whether multiple conditions are true

IF statements

Use IF statements to return output based on the contents of another cell

Pivot Tables

Create Pivot Tables to quickly summarize large databases

Pivot Tables & Grouping

Group within Pivot Tables

Multiple Pivot Tables

Create multiple Pivot Tables on a single worksheet

Statistical Functions

Ranking

Use Rank.eq and Rank.avg functions to determine a cell's position within a larger array

COUNTIFS

Use COUNTIFS function to count cells based on one or more conditions

SUMIFS

Use SUMIFS function to sum cells based on one or more conditions

Advanced Charts

Combo Charts

Combine two or more charts into a single chart, with the option of adding a secondary axis

End of Class Project

Project

End of class project to review key concepts from the class

This Course is Available Live Online

You can attend this training live online at the scheduled time the course is offered (New York, Eastern Time) through screen-sharing software Zoom (free for you).
Our live online training is interactive and hands-on, just like our in-person classes. There are no extra fees and we'll work with you to ensure your setup is perfect.

Classes are activity-based and taught by a live instructor.
You can hear the instruction, ask questions, and share your screen—all in real-time.
Retake the course for free (in-person or live online) within one year.

See What Students Are Saying About Live Online

“Overall experience on Zoom was maybe even better than in IRL classroom because the instruction takes place right on your own screen, with less distraction. Great overall experience.”
“Given the fact that we had to do this entire class remotely due to Covid-19, I didn’t have very high expectations it would run so smoothly. However, I don’t think it could’ve gone any better. Not only do I feel very comfortable with the program now, but I’m actually excited to use it!”
“This was the first online class I’ve taken with ND and it was a great experience. Looking forward to the other classes I’ve signed up for!”

Learn more about how our live online training works

Frequently Asked Questions

Does this course require any prior knowledge or experience?

Attendees must have beginner Excel skills equivalent to our Excel Fundamentals course, including basic functions and formulas, printing, formatting, basic charts, and tables.
Do I need to bring a computer?

No. We provide a computer with the necessary software for each attendee. Choose a Mac or a PC during the checkout process.
Are discounts available for this course?
No. This course is not eligible for any discounts.

We offer discounts for packages of classes, including our Excel Bootcamp, SQL Bootcamp, Data Analytics, and PowerPoint Bootcamp.

We also provide discounts for ten or more classes purchased together. Please reach out for more information on our voucher programs.

You may be interested in these similar discounted packages:
Does this course come with a book?

Yes. This course includes a complimentary book or manual at no additional cost.
What if I need to retake this course? May I retake it for free?

Yes. You may retake this course for free once within six months, provided that the class is running with an available seat. For more information, visit our policies page.
Can I take this course online (remote learning)?
You may attend this training virtually (online) at the scheduled time the course is offered (New York, Eastern Time).

How does attending “live online” work?
- Students can attend this training remotely through screen sharing software (we use Zoom).
- Participants can hear the instruction, ask questions, and even share their screen with the instructor.
- For audio you can use your computer’s microphone/speakers or call a phone number that we’ll provide.
- Classes are activity-based and taught by a live instructor, so we strongly encourage students who are local to the area to attend in person!
What if I don’t have the software on my computer?

Upon registration, please email contact@nyimtraining.com and we will help you get set up with the software or anything else needed for an optimal training experience.

Corporate & Onsite Intermediate Excel Training

For over two decades, NYIM Training has created and delivered the highest-rated corporate training programs in New York. We have extensive experience developing curriculum for a variety of training sessions, both onsite and in our Midtown offices. Our program can be completely customized to suit your training needs.

Onsite at Your Location
- We’ll come to your offices anywhere in the USA
- Customize the curriculum or choose from existing courses
- Flexible scheduling
Private Training at NYIM
- Central location in Midtown Manhattan
- Modern computer lab—students arrive hands-free
- Customize your curriculum or choose from existing courses
- Catering options available
Group Class Vouchers
- Purchase discounted vouchers to public classes
- Frequently scheduled courses
- Employees choose their schedule
- Custom learning management system for large purchases

Get a Free Quote

contact@nyimtraining.com 212 • 658 • 1918

Intermediate Excel Classes in NYC

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:

Use Pivot Tables to summarize large datasets
Query Excel data with VLOOKUP and other database features
Perform descriptive statistics functions with COUNTIFS and SUMIFS
Combine charts to illustrate complex relationships between data

Intermediate Microsoft Excel Course at NYIM

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.

Learn Functions to Manage Your Excel Database

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.

Accelerate Your Workflow with Shortcuts

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.

Enroll Now and Get Access to Our Free Training Videos

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.

The Best Intermediate Excel Courses NYC Has to Offer:

Step-by-Step project-basic exercises
Practical training for your career
Taught by experienced Excel gurus
Lifetime access to training videos
Workbooks and shortcut sheets for Practice
Small classes and one-on-one attention

What are Intermediate Excel functions?

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!