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 one year 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.
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
Advanced Microsoft Excel is rated 4.8 stars by 1,756 students
Great class! The instructor really knew her stuff. I learned more about Excel than I was expecting to.
I only have positive things to say. The instructor was fantastic and extremely knowledgeable. I thought it was impressive that he was able to support students with more basic Excel knowledge but still pace the class to keep the rest of the group stimulated. The material was clear, organized, and presented with a logical flow. The INDEX MATCH and macro sections were particularly helpful. I will be back for additional courses.
I thought that if it came down to me and Excel, Excel had nothing on me. Debbie showed me otherwise.
Will recommend this class to anyone interested in Excel.
Great way to learn some Excel tips and tricks! I can't wait to apply what I learned in my day-to-day work!
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!
Fantastic presenter. Debbie is very knowledgeable and enthusiastic.
Great! I felt like I learned a lot from this class, and I would love to take another class if it is similar to this type of format. Often, it is difficult for me to fully understand material during a Zoom meeting. Even though this class was through Zoom, I was able to fully understand the material because I was working with the instructor, and then I was able to practice what I learned on my own.
Made me a better Excel user.
Very helpful and the Excel shortcuts taught are worth knowing!
10/10. There were awesome tips and tricks for a nice variety of things to do in Excel, the distributed documentation made it easier to follow along without falling behind, and the shared recording is an excellent feature to have after these classes.
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.
I learned a lot of great new concepts in Excel and reinforced my current knowledge base of functions as well.
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!
Professor Norman was very informative. Really patient and knowledgeable about the material. Willing to stop class and share screen to see where you might have committed a mistake. Thanks for giving me a better understanding of Excel!
I was fortunate to do the Excel Bootcamp with Ade and Eugenio. Both were exceptional teachers and displayed an incredibly high level of knowledge in their respective courses. Ade was strategic in his approach and attacked the “more difficult” subjects the first half of the day while our minds were at their sharpest. He then somehow kept us engaged throughout the entire class, especially when the material went into greater detail!
Outstanding! Thank you!
I am so thankful that I had the opportunity to attend almost all of the classes that Ms. Cunningham conducted. She was very professional and very knowledgeable. She kept us engaged, reviewed material from previous classes, and shared a lot of helpful tips. I have an entire binder full of handwritten notes. I'm looking forward to reviewing them and adding more when I rewatch the videos.
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.
The course was amazing! Very excited to utilize these new skills in work!
I had fun and learned a lot about complex Excel functions with a great instructor!
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!
This class was engaging and full of useful information. I would recommend it to anyone looking to further their Excel knowledge and skills.
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!
This course covers the many Excel functions that job descriptions deem necessary. Highly recommend this course.
Showing 25 of 143 reviews
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. 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 185 Madison Avenue, 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 30 days 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 payment 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:
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 price our courses.
These related courses share skills and topics with Advanced Microsoft Excel. Select up to two and tap Compare selected courses to view a side-by-side comparison.
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.
Microsoft Excel Bootcamp covers everything in this course, plus the beginner and intermediate material this course assumes as prerequisites, packaged into a three-day novice-to-expert intensive.
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 Beginner Microsoft Excel first if you're new to Excel; this advanced course assumes intermediate-level proficiency with VLOOKUP, Pivot Tables, and IF statements before diving into INDEX-MATCH and macros.
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.
Take Intermediate Microsoft Excel first if you're not yet comfortable with VLOOKUP, Pivot Tables, and IF statements; this advanced course lists that material as its required prerequisite.
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.
Excel Specialist Certification Program covers everything in this course, plus the Fundamentals and Intermediate classes, two hours of private tutoring, and the Microsoft Excel Specialist exam 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.
Excel Expert Certification Program covers everything in this course, plus the Fundamentals and Intermediate 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.
Choose Excel Programming with VBA if you want to focus on automating Excel with macros and code; this course records simple macros but stops short of VBA programming, event processes, and error handling.
We offer custom onsite training and discounted class vouchers.
corporate@nobledesktop.com
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 | |
| $299.00 | Total You Pay |