This advanced Excel course is designed for experienced users who want to take on more complex calculations, analysis tools, and workflow improvements. Students learn advanced navigation techniques, mixed references, auditing tools, custom conditional formatting with formulas, date functions, and custom number formats, along with more sophisticated logic using nested IF statements and IF formulas with AND/OR criteria.
The course also introduces What-If Analysis with Goal Seek and Data Tables, advanced PivotTable calculations, Pivot Charts, XMATCH, INDEX-MATCH, INDEX with Double MATCH, macros, and dynamic arrays. It prepares students to build more flexible models, automate repetitive tasks, and approach spreadsheet analysis with greater precision.
Attendees must have Excel proficiency equivalent to our Intermediate Excel course, including VLOOKUP, Pivot Tables, and IF statements.
Learn online at your own pace with video training and live support from our instructors. If you purchase the self-paced option, you can attend the live course for free within one year.
From our hands-on training style to world-class instructors and custom-crafted curriculum, we deliver results our alumni are proud of.
great course, I did have some issue with speed, but I was able to catch up.
Professor made the class interactive! This was helpful. He also made sure we understood before he moved to the next section.
Great pace!
Instructor was very knowledgeable and nice
great teacher
I learned new Excel features in a session.
Great job throughout, the instructor did a great job of warning when the material was going to be more advanced, which was super helpful in stopping me from getting in my head and getting in the way of focusing.
Excellent, very clear organized and easy to follow.
This was one of the best trainings I have ever taken.
Ade was GREAT and kept us on track to get everything finished. Great in person learning experience.
Very knowledgeable, very interesting class.
Really knows his stuff!!
Instructor was really well-versed in Excel! I wish I could have had Garfield for level two.
The instructor is incredibly knowledgeable on this subject and could answer any question someone had! Great class!!!
My overall experience in Excel Level III – Advanced was positive and genuinely worthwhile. The instructor’s expertise and energy made the class engaging, and the advanced skills covered were immediately useful.
This Excel Bootcamp series is an excellent way to get a solid footing in Microsoft excel. There is something for everyone in the course regardless of skill level.
Great instructor and went through everything clearly. Learned a lot of new tips.
This Microsoft Excel class was the best that I've taken! So much useful information packed into a digestible format and timeframe!
I learned a lot of new things about Excel.
Great class.
The instructor was approachable and addressed student questions promptly, offering additional support when needed. The class was well-structured and met the learning objectives. Students left with improved Excel skills and confidence in using the software.
Instructor was very thorough.
My instructor was absolutely outstanding—extremely knowledgeable, incredibly supportive, and truly a pleasure to learn from. Thank you for making the training such a valuable and enjoyable experience!
Garfield is the best! He is patient, methodically and engaging.
This course was very engaging.
Showing 25 of 155 reviews
Learn the concepts and skills covered in this course or your tuition is on us. See details and terms & conditions.
Work on projects proven to boost retention
Refined over many cohorts for an optimal learning experience
The teaching method at Noble Desktop is perfect and the classes provide you with infinite knowledge that makes you eager to take everything they offer. I love Noble!
—Ivonne Ackerman
Experienced educators who are driven to help you succeed
Refresh the materials for free within one year
Attend this course in-person in NYC or live online or as self-paced training. 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 Noble Desktop, 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 Ave, 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.
Learn at your own pace with pre-recorded video lessons and hands-on exercises. Work through the material on your schedule with access to course content and resources.
Our instructors are industry experts and experienced educators, driven to help you succeed.
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.
This class is meant for those with prior experience with basic and intermediate-level Excel skills looking to learn Excel’s most advanced functions and capabilities, including advanced lookup functions, Pivot Charts, and macros.
The instructors typically present using Excel 2019 or Microsoft 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).
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.
Yes. This course is available online. See the course description and enrollment options for the training format and schedule.
For live-online sessions, you attend at the scheduled class times (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.
