Intermediate Excel Classes Online: Learn VLOOKUP, Pivot Tables & More

This course includes

6 hours of project-based training from experts
Software Access
Answers from real instructors
Proprietary workbook included
Access to class recordings (30 days)
Verified digital certificate of completion
Learn at an accredited institution
Credits: 0.06 CEUs

This course is self-paced. You can take the Excel Level II: Intermediate for live online or in-person instruction at Noble Desktop.

In this intermediate Excel class, you'll dive into powerful functions like VLOOKUP and SUMIFs, learn to summarize data with Pivot Tables, sort and filter databases, and manipulate text with split and join functions. You'll also have access to our innovative Excel video suite, allowing you to revisit the material anytime after the class.

Enroll in this class as part of the Excel Bootcamp and enjoy a 15% discount. The full package includes our Fundamentals, Intermediate, and Advanced Excel classes.

Split and join text, add data validation, and use named ranges
Utilize database functions like VLOOKUP and HLOOKUP
Apply logical functions such as AND, OR, and IF statements
Summarize large datasets quickly with Pivot Tables
Use statistical functions like Ranking, COUNTIFS, and SUMIFS
Create advanced combo charts combining multiple chart types
Reinforce key concepts with a final project

This course has a prerequisite

Attendees must have beginner Excel skills equivalent to our Excel Fundamentals course, including basic functions and formulas, printing, formatting, basic charts, and tables.

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
Software Access
Answers from real instructors
Proprietary workbook included
Access to class recordings (30 days)
Verified digital certificate of completion
Learn at an accredited institution
Credits: 0.06 CEUs

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.
Access to
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 industry experts 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 II: Intermediate Course Online

male student at computer workstation taking revit course

Excel Level II: Intermediate Course Online Curriculum

Course Syllabus

Download Syllabus PDF

Worksheet Management

Navigation

Keyboard shortcuts that facilitate quick and easy navigation within cells

Formula Review

Review various methods for completing calculations

Working with Text

Splitting Text

Use Text to Columns to split text into multiple cells

Joining Text

Join text from separate cells

Cell Ranges

Paste Special

Apply formats and perform calculations on selected cells

Paste Special Values

Hardcode the answer to a formula or function

Named Ranges

Assign a name to a range of cells to make it easier to reference those ranges in calculations

Database Functions

VLOOKUP & XLOOKUP

Use VLOOKUP and XLOOKUP to find information in cell range and return information from another cell range

Sort & Filter

Use Sort & Filter to find and organize data in large databases

Pivot Tables

Create Pivot Tables to quickly summarize large databases

Pivot Tables & Grouping

Group within Pivot Tables

Multiple Pivot Tables

Create multiple Pivot Tables on a single worksheet

Logical Functions

IF statements

Use IF statements to return output based on the contents of another cell

AND, OR

Tests to see whether multiple conditions are true

Math Functions

SUBTOTAL

Use SUBTOTAL function to sum/average/count values based on what is not filtered

Statistical Functions

SUMIFS

Use SUMIFS function to sum cells based on one or more conditions

COUNTIFS

Use COUNTIFS function to count cells based on one or more conditions

Improve Data Quality

Data Validation

Restrict the type of data that can be allowed in a cell

Remove Duplicates

Eliminate duplicate row data

Advanced Charts

Combo Charts

Combine two or more charts into a single chart, with the option of adding a secondary axis

End of Class Project

Project

End of class project to review key concepts from the class

Frequently Asked Questions

Who is the target audience for this course?

This course is designed for individuals with a basic understanding of Excel, including basic formulas, functions, graphs, and tables, who want to advance to intermediate-level features such as VLOOKUP and Pivot Tables. The skills gained in this course are applicable across a variety of industries, including technology, finance, retail, education, healthcare, non-profit, professional services, and more.

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.

Is this course open to beginners?

Attendees must have beginner Excel skills equivalent to our Excel Fundamentals course, including basic functions and formulas, printing, formatting, basic charts, and tables.

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 Options FAQ to find related programs that qualify.

How long do I have access to the course materials?

This course is available for 30 days.
You can choose when to start your access period. Once you activate, you will have 30 days to complete it (access the course materials, quizzes, projects and videos). You may request one extension of seven (7) days. Other extension requests will be evaluated on a case-by-case basis. Videos are not downloadable.

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
Access to industry-standard software during your training
Expert support with answers to your questions from real instructors throughout your learning journey
Comprehensive learning materials including proprietary workbook developed by industry experts
30-day access to class recordings to review material at your own pace
A certificate of completion to verify your accomplishment
The confidence of learning at an accredited institution

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.

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

Price: $549 | Hours: 18 Hours

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