# Excel Bootcamp

Canonical URL: <https://www.creativelive.com/classes/excel-bootcamp>

## Overview

This three-day Excel Bootcamp takes you from complete beginner to advanced user, bundling three one-day courses into a single comprehensive package. You will kick things off with [Excel Fundamentals](/classes/basic-excel-classes), where you will get comfortable with the essentials: calculations, basic functions, charts, formatting, and printing. From there, [Intermediate Excel](/classes/intermediate-excel-classes) builds on that foundation by introducing more complex functions like VLOOKUP and SUMIFS, teaching you how to summarize data with PivotTables, and showing you how to sort and filter databases, split text, and join it back together.

The final day is where things really open up. [Advanced Excel](/classes/advanced-excel-classes) dives into powerful database functions like INDEX and MATCH, walks you through creating basic macros, and introduces What-If Analysis tools like Goal Seek and Data Tables. By the end of the bootcamp, you will have a practical, well-rounded command of Excel that covers everything from everyday business tasks to the kind of advanced functionality that makes you genuinely valuable in a data-driven workplace.

## What you'll learn

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

## Curriculum
1. **Excel Level I: Fundamentals**
2. **Excel Level II: Intermediate**
3. **Excel Level III: Advanced**

## Schedule
- Jun 1, 2026 – Jun 3, 2026 — Live Online
- Jun 16, 2026 – Jun 18, 2026 — Live Online
- Jun 29, 2026 – Jul 1, 2026 — Live Online
- Jul 7, 2026 – Jul 9, 2026 — Live Online
- Jul 7, 2026 – Jul 22, 2026 — Live Online
- Jul 20, 2026 – Jul 22, 2026 — Live Online
- Jul 29, 2026 – Jul 31, 2026 — Live Online
- Aug 11, 2026 – Aug 13, 2026 — Live Online
- Aug 24, 2026 – Aug 26, 2026 — Live Online
- Sep 1, 2026 – Sep 3, 2026 — Live Online
- Sep 8, 2026 – Sep 10, 2026 — Live Online
- Sep 8, 2026 – Sep 24, 2026 — Live Online
- Sep 27, 2026 – Oct 11, 2026 — Live Online
- Oct 13, 2026 – Oct 15, 2026 — Live Online
- Nov 9, 2026 – Nov 11, 2026 — Live Online

## FAQ

### What version of Excel does this course cover?

The instructors typically present using Excel 2019 or Office 365. However, you can also use Excel 2013 or 2016; the exercises and interface are compatible with what we teach (with some minor differences that the instructor will explain).

## Pricing

**Tuition:** $549
