# 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

## Pricing

**Tuition:** $599