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

Canonical URL: <https://www.nextgenbootcamp.com/classes/excel-intermediate-self-paced>

## Overview

In this intermediate Excel class, high school learners build on foundational skills by working with functions such as VLOOKUP and SUMIFS, summarizing data using Pivot Tables, and sorting and filtering larger datasets. You'll also learn how to split and combine text to clean and organize information more efficiently. The course includes access to an Excel video suite, allowing you to review key concepts anytime and continue practicing after class. AI also gets a nod throughout the course. The kind of data wrangling and analysis you'll practice here is exactly what AI and machine learning systems depend on, so you'll start to see how strong spreadsheet skills connect to the way data-driven technology actually works.

## What you'll learn

- 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

## Prerequisites

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

## Curriculum

### 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

#### 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

## Pricing

**Tuition:** $249