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

This course includes

6 hours of project-based training from experts
Answers from real instructors
Access to class recordings (30 days)
Verified digital certificate of completion
Learn at an accredited institution

This course is self-paced. For live online or in-person instruction, take Excel Level III: Advanced.

In this advanced Excel training course, you'll learn how to unlock the full potential of Microsoft Excel. After mastering the basics of building and organizing spreadsheets, you'll dive into techniques to manipulate and visualize data, improving workflow and generating deeper insights. This course is designed to help you manage spreadsheets, utilize powerful analytics tools, and write macros for greater efficiency.

Throughout the class, you'll become proficient with complex Excel functions such as MATCH, VLOOKUP-MATCH, and INDEX-Double MATCH, which will help you handle large amounts of complex data in virtually any job setting. Whether you're aiming to boost your career in data analysis or just streamline your work process, this course is a great investment.

Manage cells with locking, auditing, and hot keys
Apply special formatting techniques for calculating dates
Use advanced functions, such as nested IF statements
Leverage analytical tools for data consolidation, filtering, and pivot charts
Master advanced database functions like MATCH, VLOOKUP-MATCH, and INDEX-Double MATCH
Record macros and create relative reference macros for ad-hoc reporting
Complete a final project to apply key concepts learned in the course

This course has a prerequisite

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

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
Answers from real instructors
Access to class recordings (30 days)
Verified digital certificate of completion
Learn at an accredited institution

Why Learn at VDCI?

Hands-on training

Work on projects proven to boost retention

Time-tested curriculum

Refined over many years for an optimal learning experience

This training will definitely help my career. I was able to show my supervisor and co-workers what the software programs have to offer and what I'm capable of when the time comes for creating that construction design team in the future. I was able to provide documentation to my employer that the money spent was well worth it. The training I received at VDCI will become an asset moving forward.
—Donahue Chase

Learn from AEC industry experts

Experienced educators who are driven to help you succeed

Receive support from course instructors

Get help when you need it

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

Garfield Stinvil

Instructor

Eugenio Solis de Ovando

Instructor

Colin Jaffe

Instructor

Brian McClain

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

male student at computer workstation taking revit course

Excel Level III: Advanced Course Online Curriculum

Course Syllabus

Download Syllabus PDF

Advanced Navigation

Fill Review

Cell Management

Advanced Cell Locking

Hot Keys

Cell Auditing

Go To Special

Special Formatting

Conditional Formatting-Formulas

Date Functions

Custom Number Formats

Advanced Functions

Nested IF statements

IF statements with AND/OR

What If Analysis

Goal Seek

Data Tables

Advanced Analytical Tools

Calculation Options

Conditional SumProduct

Pivot Table-Base Fields & Sets

Pivot Table-Calculations

Pivot Charts

Advanced Database Functions

XMATCH function

INDEX-MATCH

INDEX-Double MATCH

Introduction to Macros

Recording Macros

Dynamic Arrays

End of Class Projects

Projects

Frequently Asked Questions

Who is the target audience for this course?

Are there any additional fees or expenses?

Is this course open to beginners?

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

How long do I have access to the course materials?

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

What’s included with my tuition?

Are there any additional fees or expenses?

Do you offer any discounts for this course?

Corporate & Onsite Data Analytics Training

Purchase group class vouchers at a discount for our regularly-scheduled group classes, 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