Advanced Excel Classes Online: Goal Seek, Data Tables, Macros

This course includes

6 hours of project-based training from experts
22 training videos
Answers from real instructors
Retake for free within 1 year
Access to class recordings (30 days)
Verified digital certificate of completion

Learn all of the most complex features of Microsoft Excel in this advanced training course. Once you’ve gotten the hang of the basics of building and organizing spreadsheets using Excel, you can learn to manipulate and visualize that data to improve your workflow and draw deeper insights.

In this class, you will find out how to manage spreadsheets, utilize advanced analytics tools, and write macros to improve efficiency. You will also become familiar with complex Excel functions, including MATCH, VLOOKUP-MATCH, and INDEX-Double MATCH. The tools you’ll learn in this class will apply to virtually any job setting where you must organize large amounts of complex data.

Why Learn Excel?

Excel is one of the most commonly used business applications on the planet, so no matter what field you work in, learning Excel has the potential to help optimize your workflow and improve your productivity. Whether working as a professional Data Analyst or just working at a company with a lot of information to catalog and organize, learning Excel can pay long-term dividends.

Very few jobs strictly use Excel, so anyone looking to start a new career will need supplemental training. However, learning Excel is foundational for anyone hoping to work in a data analytics or financial career.

This course has a prerequisite

Attendees must have Excel proficiency equivalent to our Intermediate Excel course, including VLOOKUP, Pivot Tables, and IF statements.

Video Training Preview

Lesson 1: Cell Management

Lesson 2: Special Formatting

Lesson 3: Advanced Functions

Lesson 4: What If Analysis

Lesson 5: Advanced Analytical Tools

Lesson 6: Advanced Database Functions

Lesson 7: Introduction to Macros

Lesson 8: Dynamic Arrays

Highly Reviewed by Our Alumni

From our hands-on training style to world-class instructors and custom-crafted curriculum, we deliver results our alumni are proud of.

Tuition

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.

Full Tuition

$249
Due before the class starts

This course includes

6 hours of project-based training from experts
22 training videos
Answers from real instructors
Retake for free within 1 year
Access to class recordings (30 days)
Verified digital certificate of completion

Learn the Skills Guarantee™

Learn the concepts and skills covered in this course or your tuition is on us. See details and terms & conditions.

Hands-on training

Work on projects proven to boost retention

Several students, sitting at computers, looking at the front of the classroom

Time-tested curriculum

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

Learn from experts

Experienced educators who are driven to help you succeed

Retake for free

Refresh the materials for free within one year

100% Online. Start Anytime

24/7 access to our premium course videos and projects.
Industry experts are assigned as your course instructor. Message your instructor with any questions.
Participate in Noble online discussion forums — share ideas and receive additional support.
Hands-on quizzes and mini projects to test and reinforce concepts.

Expert Instructors

Our instructors are veterans of their field and experienced educators, driven to help you succeed.

Brian McClain

Program Director & Senior Instructor

Mourad Kattan

Program Director & Instructor

Adebayo Norman

Instructor

Garfield Stinvil

Senior Instructor

Earn a Certificate of Completion

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

Sample credential for completion of Excel Level III: Advanced Course Online (Self-Paced)

Excel Level III: Advanced Course Online (Self-Paced) Curriculum

What You'll Learn at a Glance

Cell management including cell locking, auditing, and hot keys
Special formatting for calculating dates
Use advanced functions such as nested IF statements
Learn advanced analytical tools for data consolidation, conditions to exlude data, and pivot charts
Use advanced database functions including MATCH, VLOOKUP-MATCH, and INDEX-Double MATCH
Record macros and relative reference macros for ad hoc reporting
Create a project that applies key concepts from the class

Frequently Asked Questions

Who is the target audience for this course?

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.

Is this course open to beginners?

Attendees must have Excel proficiency equivalent to our Intermediate Excel course, including VLOOKUP, Pivot Tables, and IF statements.

Do you offer payment plans or student financing for this course?

This course does not qualify for payments plans or student financing. See our Payment Plan FAQ to find related programs that qualify.

How long do I have access to the course materials?

What is the cancellation and refund policy for this single course?

For this course, you are entitled to a 90% refund (your payment less the nonrefundable 10% registration fee) within 30 days of purchase if you have not accessed the course materials.

What’s included with my tuition?

A hands-on learning experience working on projects and exercises, which is proven to boost comprehension, retention, and engagement
Expert instructors who are industry professionals and experienced educators that are driven to help you succeed
Top-notch curricula that have been tried and tested over many years and are consistently improved for an optimal learning experience
Supplemental materials to assist both during and after the course - please refer to specific course pages to see what supplemental materials are offered
A certificate of completion to verify your accomplishment

Are there any additional fees or expenses?

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, 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.

Do you offer any discounts for this course?

We don’t currently offer discounts as we do our best to affordably prices our courses.

Take this course as part of a certificate program and save:

Excel Bootcamp Course Online (Self-Paced)

Price: $549 | Hours: 18 Hours

Corporate & Onsite Excel Training

Purchase group class vouchers at a discount for our regularly-scheduled group classes in NYC, or create a custom training program at your offices.

Private Training

Available onsite at your location
Modern computer labs available at our offices
Customize or choose from our existing courses
Free instructor consultations to finalize content

Group Class Vouchers

Send employees to our group classes
Extensive offerings and flexible scheduling
Simple billing and logistics
Computers and training resources provided

Installments
	10% non-refundable deposit
$249.00	Total You Pay