# Intermediate Excel Course

Canonical URL: <https://www.graduateschool.edu/courses/intermediate-excel-classes>

## Overview

In this intermediate Excel course, you’ll learn functions like VLOOKUP and SUMIF; summarize data with PivotTables; sort and filter databases; and split or combine text.

The class includes our exclusive Excel video suite, allowing you to review the material anytime after the session.

## What you'll learn

- Learn to split and join text, add data validation, and named ranges
- Use database functions such as VLOOKUP and HLOOKUP
- Add logical statements, including AND, OR, and IF statements
- Create PivotTables to quickly summarize large databases
- Use statistical functions such as RANK, COUNTIFS, and SUMIFS
- Create advanced combo charts from multiple charts
- Review key concepts by creating a final project

## Prerequisites

Attendees must have beginner Excel skills equivalent to our [Excel Fundamentals course](/courses/basic-excel-classes), 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

- Using Concat and the & (ampersand) to combine 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

### End of Class Project

#### Project

- End of class project to review key concepts from the class

## Schedule
- May 28, 2026 10:00am–5:00pm — Live Online
- Jun 2, 2026 10:00am–5:00pm — Live Online
- Jun 2, 2026 – Jun 4, 2026 — Live Online
- Jun 10, 2026 10:00am–5:00pm — Live Online
- Jun 17, 2026 10:00am–5:00pm — Live Online
- Jun 23, 2026 10:00am–5:00pm — Live Online
- Jun 30, 2026 10:00am–5:00pm — Live Online
- Jul 8, 2026 10:00am–5:00pm — Live Online
- Jul 14, 2026 10:00am–5:00pm — Live Online
- Jul 21, 2026 10:00am–5:00pm — Live Online
- Jul 30, 2026 10:00am–5:00pm — Live Online
- Aug 12, 2026 10:00am–5:00pm — Live Online
- Aug 25, 2026 10:00am–5:00pm — Live Online
- Sep 2, 2026 10:00am–5:00pm — Live Online
- Sep 9, 2026 10:00am–5:00pm — Live Online
- Sep 9, 2026 10:00am–5:00pm — Live Online
- Sep 15, 2026 – Sep 17, 2026 — Live Online
- Oct 4, 2026 10:00am–5:00pm — Live Online
- Oct 14, 2026 10:00am–5:00pm — Live Online
- Oct 20, 2026 10:00am–5:00pm — Live Online

## Pricing

**Tuition:** $249