Advanced Excel for Business
Master advanced Excel techniques in this hands-on training. Learn how to use the more advanced tools in Excel like What-If Analysis, INDEX-MATCH, macros, and more.
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 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.
This course is part of our Excel Bootcamp. Enroll in our three-course package and save 15%.
Class Note: A PC or Mac will be provided for use during class. The instructor will present on a PC but will explain the differences for Mac students.
Great teacher! She was really helpful and moved at a solid pace. Answered all questions super well. She made the class.
A class was very helpful and the instructor made it worthwhile. Took the two-night excel class and will be back for powerpoint.
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.
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!
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
Patrick was extremely detailed and gave students time to keep up with understanding the work.
If you need a refresher course or if you need to brush up or learn, this is the place to learn.
Great way to learn more advanced functions of working with data in spreadsheets, easy to follow and a ton of information. You even get a workbook to follow along, enhancing the experience and creating a paper trail/reference sheet.
I highly recommend this class - the instructor managed to teach for 6 hours on zoom while perfectly explaining every single element at a perfect pace for everyone and was very attentive and had full expertise on all of Excel's functions.
This was an extremely helpful course and I'll be able to use so much of what we reviewed in my day to day at work. I'm excited to be able to re watch parts of the lessons through the recording as well! Once I master this, I'm definitely interested in the Macros class.
I learned a number of functions and procedures in Excel that will allow me to be more productive and more efficient with my daily tasks.
Great for business people looking to use advanced Excel features to improve productivity at work.
If you need to use Excel at work, this class will make your life easier and efficient.
An engaging, informative perfect way to learn or refresh your skills!
AgeWell New York
Never in a million years would've thought that an Excel training workshop would actually be enjoyable!
Love this class. Can use what I've learned at work.
Very good class. Trainer was very good, very patient.
Agewell New York
This was a great class, even if you know excel there are formulas/functions that can give you faster results then what you are doing now.
I definitely recommend this course for professional development in any field where MS Excel is used.
Mayor's Office of Immigrant Affairs
In this course, I learned a lot about Excel that I didn't know previously. I would certainly recommend it to those looking to learn more about the software.
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.
Work on projects proven to boost retention
Refined over many cohorts for an optimal learning experience
Great class! The content was well organized and the instructor was excellent.
— Rebecca H.
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!
We offer a single free retake of the 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).
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 Advanced 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.
Go from beginner to experienced professional: summarize data with Pivot Tables, write advanced functions including VLOOKUP, and learn techniques to expedite 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.
Purchase group class vouchers at a discount for our regularly-scheduled group classes in NYC, or create a custom training program at your offices.
Are you an Excel power user with knowledge of Pivot Tables and VLOOKUP? Do you use Excel daily for work and professional needs? If so, NYIM’s Advanced Excel Course will help you take your skills to the next level. In the advanced Microsoft Excel course, you will learn how to:
Apply pre-assigned shortcuts to accelerate your workflow
Build upon your knowledge of Pivot Tables with Pivot Charts
Implement the MATCH function with VLOOKUP and INDEX
Automate formatting and calculations tasks with macros
In Advanced Excel for Business, you’ll learn automation and shortcut techniques to apply to Excel’s most advanced features like Pivot Tables. The course includes training on recording macros to perform repetitive Excel tasks in a single click. At the end of the course, you’ll complete a course project that you can demo to current and prospective employers to demonstrate your new skill set.
Our advanced classes are perfect for those with knowledge of basic techniques including formatting, charts, basic formulas and functions, and absolute cell references, as well as intermediate-level concepts, including VLOOKUP, Pivot Tables, and intermediated functions such as SUMIFS and IF. For more information on the required prerequisite knowledge, see our Excel Fundamentals and Intermediate Excel course pages.
Don’t quite meet the prerequisites but want to become an advanced Excel user? Did you forget how to use core Excel functions like Pivot Tables and VLOOKUP? Get a refresher on Microsoft Excel functions and gain master Advanced Excel in our Excel bootcamp. The Advanced MS Excel class is part of our Excel for Business Bootcamp. Take our three Excel for Business classes and get a 15% package discount. Sign up for the Excel Bootcamp!
We offer a handful of advanced Excel courses to suit different needs.
Advanced Excel for Business builds off Intermediate Excel and teaches the advanced Excel features most commonly used by business professions today. Make your lookup functions more flexible by adding MATCH to VLOOKUP and using INDEX and MATCH together; expand Pivot Tables with Pivot Charts and other advanced features; create nested functions including nested IFS and IF with AND/OR; utilize advanced analytical tools; and write basic macros with the macro recorder to automate repetitive tasks.
For those looking to further automate tasks and create custom commands, enroll in our Excel Programming with VBA course. This two-day bootcamp covers the essentials of Excel’s programming language.
Gain real-world value that you can apply on the job
Reinforce learning with practice exercises after each course section
Solidify your new skills with a cumulative project at the end of class
Get free access to our premium Advanced Excel video suite
Retake the course free within six months
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.
|10% non-refundable deposit|
|$249.00||Total You Pay|