# Excel Bootcamp Online (Self-Paced)

Canonical URL: <https://training-nyc.com/courses/excel-bootcamp-online>

## Overview

This bootcamp bundles three courses so you can go from opening a blank workbook to handling genuinely complicated analysis without switching between programs. The fundamentals cover calculations, the functions you will use constantly, charts, formatting, and printing, which is the part most self-taught users skip and then fight with forever.

The intermediate material introduces functions like VLOOKUP and SUMIFS, PivotTables for summarizing data, and the database work of sorting, filtering, splitting text apart, and joining it back together. The advanced course covers INDEX and MATCH, writing basic macros, and What-If Analysis tools including Goal Seek and Data Tables. Because it is self-paced, you can move quickly through the parts you already know and slow down where it gets harder.

## What you'll learn

- Handle calculations, core functions, charts, formatting, and printing
- Use functions including VLOOKUP and SUMIFS
- Summarize data with PivotTables
- Sort and filter databases
- Split and join text and build dropdown lists
- Use advanced database functions including INDEX and MATCH
- Create basic macros to automate repeated work
- Apply What-If Analysis with Goal Seek and Data Tables

## FAQ

### 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 payment plans or student financing. See our Payment Plan FAQ to find related programs that qualify.

### 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 Expert support with answers to your questions from real instructors throughout your learning journey Top-notch curricula that have been tried and tested over many years and are consistently improved for an optimal learning experience 30-day access to class recordings to review material at your own pace 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 price our courses.

## Pricing

**Tuition:** $599