Looking for corporate training?
We offer custom onsite training and discounted class vouchers.
corporate@nobledesktop.com(212) 684-5151
Download Syllabus
Learn advanced Excel features and become an Excel expert. In this course, you'll master advanced functions like INDEX-MATCH, macros, and data analysis.
Develop expertise in Excel’s most advanced features and become a resident Excel expert. Maximize the power of Pivot Tables, save hours by automating tasks with macros, and develop experience with advanced database functions. By the end of this course, you'll have knowledge and skills above and beyond the requirements of most analyst roles.
Learning advanced skills isn’t easy, which is why every student in our advanced class receives a training manual. The manual contains our proprietary curriculum with step-by-step instructions, examples, and activities to practice. Our custom training manual is an indispensable reference for students for years to come.
Worried you’ll forget a step? Our advanced training tutorial videos explain the most sophisticated features of Excel, providing you with additional instruction beyond the classroom. As an Advanced Excel student, you’ll receive complimentary access to high-quality videos for mobile, tablet, and desktop.
If you need to brush up on your Excel skills, you can retake the course one time in six months as long as there are spots available.
Before jumping into the Advanced Course, save 15% by enrolling in the Excel bootcamp, which includes our beginner, intermediate, and advanced Excel courses.
Attendees must have Excel proficiency equivalent to our Intermediate Excel course, including VLOOKUP, Pivot Tables, and IF statements.
From our hands-on training style to world-class instructors and custom-crafted curriculum, we deliver results our alumni are proud of.
Advanced Microsoft Excel is rated 4.7 stars by 1,513 students
in the past 24 months
This course covers the many Excel functions that job descriptions deem necessary. Highly recommend this course.
Pamela Cappuzzello
Ade is absolutely amazing at what he does. He really knows Excel and he taught me a lot throughout the course of the day!
Jonathan Veloz
Advanced Excel is an excellent course for anyone looking to enhance their Excel skills and futher their career. I would high recommend taking this course with Jeanette as she made the course easy to understand and kept a good pace so we could learn a lot of things in 6 hours! Thanks to this school and Jeanette, I managed to learn XLOOKUP and INDEX & MATCH in just 2 days!
Hai Ngo
I think anyone who needs help with advanced Excel should attend this class. Hopefully, you will get Professor Day Yi! He did an amazing job today.
Klara Collaku
Take the class! You won't regret it!
Frankania Compres
Professor Garfield made this class an excellent experience. He communicated the material very effectively, and I learned so much. The Excel spreadsheet and handout were very helpful.
John Walsh
Michael Green is a great instructor, very thorough, and easy to follow. Keeps you engaged and not overwhelmed. The class teaches you a ton of useful information that you can use in your day-to-day work activity.
Sabrina Chan
Mike was terrific. He did his best to keep us engaged. He repeats himself regarding the actions taken so that no one gets left behind. Plus, he uploaded his copy of the assignments with the notes he took about the functions, which will make a terrific second reference.
Patricia Huizinga
This class was great! I am excited to implement what I learned in my work.
Edison Won
I only wish I'd taken these courses earlier - so much of what I've learned would have made me far more efficient in my job. I look forward to using these skills and hope to take more classes from NYC Career Centers.
Sherilyn Smith
Would absolutely recommend this class for the advanced Excel user to freshen up on skills.
Gena Wachendorfer
I had Mike as an instructor for Excel Level II and Excel Level III. The experience in both was superb. He made the experience relatable to real-world situations.
Bridgette Williams
I've worked in finance for 10 years and have been doing a lot of things, like sensitivity tables and Pivot Charts, manually. This class was a game changer!
Sabeen Firozali
After taking all three classes, I now feel comfortable using all of Excel's tools. I did not know Excel was so powerful. I like that I have the Excel workbooks from class to always refer to. I also like that I can do the projects added to the end of the workbooks to continue to practice and look at the answer key to see if I got the right solutions.
Astrid Ovalles
Amazing class. I now feel prepared for my job.
Brendan Hannon
This class was engaging and full of useful information. I would recommend it to anyone looking to further their Excel knowledge and skills.
Hayley Hooper
Using Excel as a tool to its fullest capabilities is like magic! I am a wizard with data and storytelling now, and this course opened up a whole new spell book!
Meghan Sullivan
Debbie made this class. How she got these tough concepts to stick in my brain I'll never know, but I'll always be grateful as it is going to give me back so much time in my work!
Allison Iarocci
The course was amazing! Very excited to utilize these new skills in work!
Makeda Martin
I had fun and learned a lot about complex Excel functions with a great instructor!
Eleanor Harrison
This class provides you with the tools to learn cool tricks and be an expert at Excel. The overall experience was great and has me interested in taking more classes to learn new skills.
Gary Fishkin
I thought I knew Excel until Ade Norman showed me an advanced way to solve day-to-day Excel functions in a simple and fun way! Ade took his time to break down each formula and showed how to repurpose them in ways that help save time at work while maximizing our data sets!
Ryan Resl
The class was very interesting - my favorite part was learning macros. We managed to cover a lot of material in a short period of time, and the instructor was able to get through the topics while also answering questions.
Maria Elisa Vallejo
Great way to learn some Excel tips and tricks! I can't wait to apply what I learned in my day-to-day work!
Ashton Crothers
Great instructors, great class materials, and a great overall experience. In my experience, this course is far and away better than anything you can do on LinkedIn Learning and certainly better than just watching YouTube videos. It really made a difference in my knowledge of Excel. The main advantage of this class is being able to work with pre-loaded data on the provided spreadsheets, which provided me with real-world experience using the techniques taught in the class. I highly recommend it!
Jacob Wahl
Very good! Day 2 of a 2 day course - really did not think the instructor (Peter) could have been better than day 1 instructor (Ade). While they are different, they are both great! I really appreciate the time Peter spent on the difficult topics today. Made them very simple to understand which will really help with recollection!
TiffanyMarie Gorritz
Ortho Clinical Diagnostics, Inc.
An excellent start to put you on the right track toward your journey to software mastery.
Bishoy Sidhom
Garfield's class was so informative, I would definitely return for refresher classes if I ever need to sharpen my skills. HIGHLY RECOMMEND!
Jamelle Broverman
Natixis
Great class, taught me things about excel that I will definitely use in my profession.
Varun Varadaraj
One of the best Excel classes that I have taken.
Gianluciano Perratore
NYC DDC
Amazing class. I needed a refresher on this information, especially Pivot Tables and macros. I loved Jordan's knowledge, professionalism, and personality. He made all of this information so much easier to understand. Thank you!
Nitza Rochez
adidas AG
Liked the pace at which the class went and was able to cover all the concepts for the day.
Frank Cordova
I learned so much in this course. Now that I know much more than before, I feel comfortable and confident in Excel.
Katherine Lebovics
I love this class! Very helpful to my work with Excel!
Xiangmei Xi
If you thought you knew all about Excel, this is a challenge you don't want to pass up.
Nilma Quiros
Debbie did a great job walking us through useful shortcuts and different ways to navigate through Excel macros, Pivot Tables, and VLOOKUP.
Karen Guante
Shubhi is a great Excel instructor! She answers every question with care, she gave time for practice after each topic, and she made sure we all understood. Every minute was informative and I'm pleased with the amount of information and the way of delivery. Would highly recommend it.
Sarah Hamed
Dragados
I love to be learning hands-on. I think that is the only way to learn Excel. The files and material will help me go back and review the concepts when a way to apply appears.
Luz
Dragados Canada
Mike was an outstanding teacher and you can tell that he really enjoys the class. I would take another class with Mike if possible.
Nick Tomkins
First National Realty Partners
Content/materials were presented in a way that was easy to follow. Enjoyed the charisma from the instructor and the simplicity of his explanations. Very productive class.
Ivelisse Pagan
Very helpful!
Lauren Biegelman
Excellent course for a great value. I am a business analyst for a Fortune 100 company and the concepts I improved on in this class will both improve the quality of my work and boost my team's productivity.
Lindsay Vacek
So much information but I took copious notes to refer back to later. So many things that we do not know are available, and now we know more about what is available and can be used to simplify repetitive tasks.
Susan Torell
HUGO BOSS Retail, Inc.
This course is great! It has added to my skills and will be helpful in my career.
Lisa Ramtahal
The best if you want to learn or brush up on your Excel skills. The instructors know their trade and are very patient in teaching the class with examples. Will take another class again!
Victor Figueroa
Weleda
Great class, great teaching of the class, very interactive with clients. Hands-on is the best!!
Keisha Howard
FilmRise
Great class! I have a better understanding of a lot of the Excel functions that I've seen and can now use them day to day.
Nikesha W.
I loved this class.
Josh Adcock
Hugo Boss
The content was very useful and I look forward to using this in my work. Ade was very knowledgeable and covered a great deal of material. He was able to answer all of our questions. It's very helpful to also have access to a pre-recorded video that we can go back to in the future.
Arlene P.
Would highly recommend the school and this class to all.
Lana Smith
Certain aspects of Excel that I have spent hours Googling (i.e. Index formulas) were explained clearly and succinctly. I not only learned key functions, but also simple moves to make me more efficient in my day-to-day.
Jacqueline Gannon
Everyone needs Excel in the modern workplace; there is no better place to learn it at your pace than Career Centers.
Tyler Alvarado
Phenomenal. Perfect speed. Never provided excessive information that would excessively complicate while also providing an extensive and comprehensive description/instruction for each step/tool/feature. Also really nice teacher -- very approachable, bright, helpful. I came in with a very rudimentary knowledge of Excel and left feeling like an expert. Very worth it.
Adam Rusakow
Great class, loved it! Thanks so much!
Kaitlin Weinman
On the whole, an excellent and enjoyable learning experience. Thank you!
Patrick McGuire
Excellent class for learning Excel!!
Efstathios Sanchez
This is a great class for anyone looking to take their Excel skills to the next level. And Debbie was a great instructor!
Antranig Kechejian
Extremely thorough coverage of Excel!
Ashley Tuen
Advanced Microsoft Excel was a very helpful class and Ade was a great instructor!
Jean-Claude Dowden
Debbie was an excellent instructor. Very knowledgeable. She ran the class quickly and efficiently, but with a real sense of fun and a willingness to answer questions. I learned a ton of tips and tricks in Excel that I can't wait to leverage.
Tim Carroll
Advanced Microsoft Excel is an excellent class with a great instructor. Your confidence in using the software will immediately increase after the first session. It'll feel like second nature after you finish the class.
Michael Tran
Great class. Have been an Excel power user for years but had some clear holes in my skill set. The instructor laid it out in a very easy-to-understand way. His delivery of the material was fun and easy to follow.
Nick Jenkins
If you need an Excel refresher, this class is perfect. It covers all the most important topics and formulas and reviews shortcuts! The instructor breaks everything down in a digestible way. I had no expectations coming in and I really enjoyed this session.
Talisa
This Excel for Business Bootcamp was intense but informative. I learned a great deal and so many shortcuts. Thanks Shubhi, you were great.
G. Huaylla
Mike G. helped learning about macros and some of the more advanced functions in Excel truly interesting! He taught the course in a personable, fun way that really destroyed the bad rep that Excel gets as 'boring' and 'impossible.'
Kimberley Campbell
Jeanette Howell commands Excel like a steely sorcerer and uses her magic to pull the student into a world of mystical formulas, hotkeys, and values! One of the best instructors I have ever encountered. I feel smarter having taken her class.
Tremayne Thomas Little
I loved the instructor's style and real-life integration. It assisted in my learning and absorption. The class had very informative, relative, and actionable content. I would recommend this to all my peers.
Eric Perez
OVED
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.
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.
—Diane Speros
Gain industry knowledge from professionals
Retake the course for free within one year
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 NYC Career Centers, 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.
Attendees must have Excel proficiency equivalent to our Intermediate Excel course, including VLOOKUP, Pivot Tables, and IF statements.
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 Microsoft Excel with your selected courses.
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.
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.
Take your Excel skills up a level with this Intermediate Excel course. Learn important Excel functions like VLOOKUP, SUMIFs, and Pivot Tables in this hands-on training. You'll also learn crucial text-related features like splitting and joining text, removing duplicates, and data validation.
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.
This certification program will prepare you for the Excel Expert certification exam. This program includes three group classes, four hours of private training, and the Excel Expert Exam with a free retake.
Learn Visual Basic for Applications to accelerate your workflow and reduce errors in Excel. This bootcamp course includes Excel VBA Macros Levels 1 and 2. By the end of this course, you'll be able to develop a macro, create automated event processes, and use automation to manage unforeseen errors.
We offer custom onsite training and discounted class vouchers.
corporate@nobledesktop.comThe 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 |