Excel Bootcamp Online: Beginner to Advanced Bootcamp

This course includes

18 hours of project-based training from experts
62 training videos
Access to Microsoft Office
Learn from a Microsoft Certified Trainer
Proprietary workbooks included
Retake for free within 1 year
Supplemental refresher video suite
Verified digital certificate of completion

This course is self-paced. For live online or in-person instruction, take the Excel Bootcamp.

Go from beginner to pro in our self-paced Excel Bootcamp. This package includes three Excel classes—Fundamentals, Intermediate, and Advanced:

Excel Level I: Fundamentals Course Online (Self-Paced): In this beginner Excel course, you’ll learn the essentials, including calculations, basic functions, charts, formatting, and printing.
Excel Level II: Intermediate Course Online (Self-Paced): In this intermediate Excel class, you’ll learn more complex functions such as VLOOKUP and SUMIFS, summarize data with Pivot Tables, sort and filter databases, and split and join text.
Excel Level III: Advanced Course Online (Self-Paced): In this advanced Excel training, you’ll learn advanced database functions such as INDEX and MATCH, create basic macros, and use What-If Analysis for Goal Seek and Data Tables.

Courses & Videos in This Package

Download Syllabus PDF

Unit 1 6 Hours

Excel Level I: Fundamentals Course Online (Self-Paced)

In this beginner Excel workshop, you’ll learn the essentials of Microsoft Excel, including calculations, basic functions, graphs, formatting, and printing. This basic Excel class is perfect for those with limited experience looking to expand their proficiency.

Become familiar with the interface and data entry
Learn essential formulas and functions
Format and print your work
Create charts, including line, column, and pie charts
Learn tips and tricks for easy workbook management
Review key concepts in a final project

Video Training Preview

Lesson 1: Introduction

Lesson 2: Formulas

Lesson 3: Formatting

Lesson 4: Charts & Tables

Lesson 5: Workbook Management

Unit 2 6 Hours

Excel Level II: Intermediate Course Online (Self-Paced)

Learn to split and join text, apply data validation, and create named ranges
Use database functions such as VLOOKUP and HLOOKUP
Write logical formulas using AND, OR, and IF functions
Create Pivot Tables to efficiently summarize and analyze large datasets
Apply statistical functions such as RANK, COUNTIFS, and SUMIFS
Build advanced combo charts by combining multiple chart types
Reinforce key concepts through a guided final project

Video Training Preview

Lesson 5: Workbook Management

Lesson 1: Worksheet Management

Lesson 2: Working with Text

Lesson 3: Cell Ranges

Lesson 4: Database Functions

Lesson 5: Pivot Tables

Lesson 6: Logical Functions

Lesson 7: Statistical Functions

Lesson 8: Advanced Charts

Unit 3 6 Hours

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

Cell management including cell locking, auditing, and hot keys
Special formatting for calculating dates
Use advanced functions and advanced analytical tools
Record macros and relative reference macros for ad hoc reporting

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

Program Reviews

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

Tuition

Full Tuition

$747
$549
Due before the class starts

This course includes

18 hours of project-based training from experts
62 training videos
Access to Microsoft Office
Learn from a Microsoft Certified Trainer
Proprietary workbooks included
Retake for free within 1 year
Supplemental refresher video suite
Verified digital certificate of completion

Learn the Skills Guarantee™

Learn the concepts and skills covered in this true 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

A student reading a workbook in class

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.
Access to Microsoft Office
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.

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 Bootcamp Online (Self-Paced)

Excel Bootcamp Online (Self-Paced) Curriculum

What You'll Learn at a Glance

Master calculations, basic functions, charts, formatting, printing
Learn functions such as VLOOKUP and SUMIFS
Summarize data with Pivot Tables
Sort and filter databases
Work with text: split and join text, dropdown lists
Advanced database functions such as INDEX and MATCH
Create basic macros
Use What-If Analysis for Goal Seek and Data Tables

Frequently Asked Questions

Who is the target audience for this course?

Participants with limited to no experience in Excel, looking to master Excel’s most common applications used by business professionals, including:

Those working in or seeking a position that requires advanced analytical skills in Excel
College and graduate students looking to supplement academic coursework with practical applications of Excel in business contexts
Entrepreneurs or freelancers looking to work on advanced Excel projects

Is this course open to beginners?

Yes, this course is open to beginners. Students must be comfortable using a computer. No other prior knowledge is required.

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 package?

For this series of 3 courses, you are entitled to a 90% refund (your payment less the nonrefundable 10% registration fee) within 30 days of purchase for any course in the bundle that you have not accessed.

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
A comprehensive program with 3 in-depth course modules designed to build your skills progressively
Extensive video training resources to support your learning journey
Access to Microsoft Office during your training
Expert support with answers to your questions from real instructors throughout your learning journey
Comprehensive learning materials including proprietary workbooks developed by industry experts
Access to a supplemental refresher video suite to reinforce key concepts whenever you need them
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.

Do you offer any discounts for this course?

This program is a discounted package of classes that is 15–25% off the individual class prices, so additional discounts do not apply.

Instructor answering question

Corporate & Onsite SQL Classes Online 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

Or

Group Class Vouchers

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

Installment Plan Breakdown for Excel Bootcamp Online (Self-Paced)

Each installment is charged to your card on file every 30 days or before you begin your next class.

Installments		List Price
$54.90	10% non-refundable deposit	--
$249.00	Excel Level I: Fundamentals Course Online (Self-Paced)	$249
$245.10	Excel Level II: Intermediate Course Online (Self-Paced)	$249
▴ Your 10% deposit has been applied, as well as the certificate discount of $198
Free	Excel Level III: Advanced Course Online (Self-Paced)	$249
$549.00	Total You Pay

See the Installment plan FAQ for more information.