Looking for corporate training?
We offer custom onsite training and discounted class firstname.lastname@example.org
We are open! Classes are running in-person (socially distanced) and live online. Secure your seat today
The intermediate Excel class focuses on more advanced functions (including VLOOKUP, COUNTIFS and SUMIFs), Sort & Filter, and Pivot Tables. You'll also learn crucial text-related features like splitting and joining text, removing duplicates, and data validation. Embedded in the course are pivotal time-saving tricks like Paste Special, keyboard shortcuts, and navigation techniques.
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.
I thought the class was well organized, clear, and easy to follow, and the instructor was very knowledgeable with excellent presentation skills, Debbie did a great job. Overall the course is going to be very useful in my day-to-day job.
I liked the class and would like to come back for the advanced course.
I would recommend this course to anyone who needs a greater level of understanding in Excel.
Bob was incredibly knowledgeful and patient while teaching Intermediate Excel. The class was interesting and I was shocked to learn as much as I did.
Perfect for anyone who uses Excel in their day-to-day life! Learned many new shortcuts for Excel and my new favorite: the XLOOKUP.
Excellent instruction. Pace, cadence, and delivery were perfect for an intermediate user like me. If Excel were easy, everyone would be doing it.
Excellent, the instructor related the material to very helpful real-world scenarios. Patient and kind.
I would recommend the Excel training classes at NYC Career Centers. If you are looking to enter back into the job market or just want to update your skills - then NYC Career Centers is the place to do it. The teachers are well versed in their courses and have a helpful attitude. The school is centrally located in NYC. The classrooms are extremely clean. They offer both online and in-person classes. Listen, it is time to go for it!!!!
I have used Excel at work for years but I picked up so many tips and learned new functionality. I will be much more efficient after this class!
Really enjoyed this course. Super succinct and covers a wide range of topics.
OMG! Ade was an excellent instructor! He explained things in a very clear way; he was thorough yet not overwhelmingly so. Definitely would recommend.
Ortho Clinical Diagnostics.com
Great class if you're looking to enhance your professional skills!
I feel confident about VLOOKUPs now after attending this course.
Lazard Asset Management
Great class! Definitely excited to take these tips into the workforce.
Small class sizes, patience experts with real life experience, and the opportunity to retake a course in 6 months! They really want you to succeed!
Great overview of basic Excel functions.
I am now an Excel Guru, no doubt!
Here to Learn - Earn with what your Learn!
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.
I initially took this class for VLookups and Pivot Tables, but there were so many useful tools just for everyday tasks in the office. I would recommend this class to anyone. I'll be back for Advanced Excel. Thanks!!
The perfect boot camp to refresh my skills while also learning new, helpful tips! Great for beginners and experts alike. Would definitely take another class and recommend to other peers and colleagues.
Very interactive, great way to build skills with Excel.
Helped me distinguish my strengths and weaknesses in Excel and really advanced my skills and understanding of the software.
Whether you are looking to firm up your skills, learn new skills, or just get faster and more efficient at the skills you already have, this is a great training experience!
Would highly recommend to anyone interested in improving their Excel abilities. Garfield is particularly wonderful.
I did the all day class on a Sunday. I thought it would be a long grueling day, but it was actually enjoyable and went by really fast.
Patrick is a fantastic instructor. This was my second time taking the Excel class with him. His pace is just right, he waits for every single person in the class to finish before he moves on to the next task and doesn't over-complicate things. He's always open to explaining again and sometimes shows shortcuts while he does that. His teaching style is incredible and I'd definitely recommend him.
Teaches tips and tools with step-by-step instructions that never leave you behind.
Learned so many tips and tricks. Thank you!
The class session went very well. Ade does take the time to go through the lesson and allow students to ask questions.
Dept. of Environmental Protection-City of New York
Game changing! These tools will save me hundreds of hours of time at work :)
The class was extremely helpful, even if you are a heavy Excel user! I learned many processes that will help me function much more efficiently. Vincent was a fantastic teacher!
Great class and they make it super easy to learn!
Jeanette was patient and did a very good job. I like the way she taught.
I am glad that I took the class and I learned a lot of information that I am sure will make working with Excel more efficient. I would recommend the class to anyone who has never taken a class and is self-taught. The shortcuts alone that I learned will save me so much time in the future.
I will definitely encourage my department to attend this class. Very informative.
Ade was very personable and knowledgeable. He made a seven-hour course fun and engaging. I learned a lot that will make my life and job easier.
It was very helpful to learn more shortcuts! The material was in-depth without being overwhelming.
Everything provided can be used in my daily operations.
Enjoyed the fact that the class had a workbook, very interactive!
This course was very helpful and thorough!
Even though I have used Excel for years, there is always something new to be learned. Looking forward to taking more of these classes!
HUGO BOSS Retail, Inc.
This class was definitely suited for intermediate Excel users. Not only was it a great refresher in some basics but it also covered many topics that were more complex. They made the concepts easy to grasp in order to write the formulas.
Ade's Intermediate Excel class was incredibly informative and explained in a very clear way that was easy to understand. The instructor had great energy, was very patient about answering questions.
Fantastic class, made it super easy to learn Excel!
I came into this class knowing nothing about Excel. After a class with Mike, I felt like a pro!
Career Centers has the best instructors and you get the best for your money.
NYU Grossman School of Medicine
I would recommend this class!
NYU Langone Health
The course material was engaging and the structure allowed for increased retention of material.
NYU Langone Medical Center
Mike was a fantastic instructor and was very attentive to any student questions.
The course is very thorough.
I enjoyed the course and learned quite a lot.
Definitely worth the time investment. Great content, extremely applicable.
Vincent is so friendly and does a great job engaging virtually. He is sure to slow the pace when needed and patiently guides anyone who needs it.
This is a life saver class!
The best, most engaging Excel course I've taken to date! Mike was absolutely fabulous. I took the intro Excel course with him and was so excited to see that he was teaching this course today! Mike isn't just an exceptional instructor, but also a master at engaging his students. His teaching style is the perfect mix for me: keeping the topics light while introducing game-changing knowledge and insights.
Adebayo is very patient and attentive. He answers everyone's questions and make sure we all understand.
Excel Intermediate with Debbie Cunningham was the class I didn't know I needed but I'm so glad I enrolled. She made everything seem so easy and always had a useful shortcut, which is essential for time management. If I could, I would take all of her classes.
Mike was very informative and explained matters in a way that was easy to understand.
I loved this class! The instructor went slow enough for me to actually understand and follow along. I think this class will help me work faster in Excel with all the shortcuts and new functions I have learned!
A good broad overview if you need to expand your skills from just basic Excel.
Mitsubishi International Corp.
The instructor was very clear. Explained concepts in detail and in a way that made them easy to follow. I was a bit apprehensive about taking the course online - however, I was pleasantly surprised.
He was very helpful, spoke clearly, and made sure nobody was left behind. Mike Green is a great instructor. He would ask questions and test us as he went on with the class which I really liked. He was clear about what we will need if we look into taking more classes, which I truly appreciated. I would refer this center to anyone looking in learning any type of software.
I have been wanting to learn about Pivot Tables for years. So glad to finally know how they work! I am in Excel every day, but there is a lot for me to learn still - and it was great to learn tips on how to analyze my data more efficiently. The instructor was upbeat and not boring at all. It can be very easy to get distracted during online trainings, but I did not during this course.
Very good information! I have always thought I was fairly proficient in Excel, able to navigate easily and get the outputs I wanted, but this course definitely taught me some shortcuts and provided new knowledge.
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!
Learn with real-world projects
Step-by-step instruction to boost retention
The Career Centers instructors are highly skilled communicators who really know their craft. They are wonderful about explaining and re-explaining when necessary and I never felt rushed or foolish for asking a question.
Gain industry knowledge from professionals
Retake the course for free within one year
In addition to 7 Hours of live training, you’ll receive lifetime access to self-paced training videos, a $95 value.
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.
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 Microsoft Excel with your selected courses.
Get going with the basics of Excel and start working on projects in Excel. Get practice with calculations and formulas, charts and tables, worksheet and workbook formatting, and basic hotkeys to accelerate your workflow.
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.
Go from novice to expert in our three-day comprehensive Excel Bootcamp. You’ll learn advanced database functions, calculations, and formulas, shortcuts, Pivot Tables and scripts, and macros for automating tasks with ease.
Become an expert Excel user with this Advanced Excel course. Learn powerful functions like INDEX-MATCH, work with advanced Pivot Table functions, and start recording macros to automate workflows. Prepare yourself for any Excel challenge with this advanced Excel course.
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 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 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 Career Centers, 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 Career Centers 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!