# Excel Level III: Advanced

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

## Overview

Learn the most advanced features of Microsoft Excel in this training course. Once you've mastered the basics of building and organizing spreadsheets, you'll learn how to manipulate and visualize data to improve your workflow and extract deeper insights.

In this course, you'll learn how to manage spreadsheets, use advanced analytics tools, and write macros to improve efficiency. You'll also become proficient in complex Excel functions such as MATCH, VLOOKUP-MATCH, and INDEX-Double MATCH. The skills you develop will apply to virtually any role that requires organizing and analyzing large amounts of complex data.

## What you'll learn

- Understand cell management, including cell locking, auditing, and hotkeys
- Learn special formatting for calculating dates
- Use advanced functions, such as nested IF statements
- Learn advanced analytical tools for data consolidation, conditions to exclude data, and PivotCharts
- Use advanced database functions, such as MATCH, VLOOKUP-MATCH, and INDEX-Double MATCH
- Record macros and relative reference macros for ad-hoc reporting
- Create a project that applies key concepts from the class

## Prerequisites

Attendees must have Excel proficiency equivalent to our [Intermediate Excel course](/classes/intermediate-excel-classes), including VLOOKUP, Pivot Tables, and IF statements.

## Curriculum

### Advanced Navigation

#### Advanced Navigation

- Advanced navigation techniques

#### Fill Review

- Review of Autofill conventions and techniques

### Cell Management

#### Mixed Reference Formulas

- Create powerful formulas by locking either the column or the row

#### Hot Keys

- Transform the ribbon into a visual listing of pre-assigned shortcuts

#### Cell Auditing

- Observe the relationship between formulas and cells

#### Go To Special

- Quickly select cells that meet certain criteria

### Special Formatting

#### Conditional Formatting-Formulas

- Create custom rules for Conditional Formatting with formulas

#### Date Functions

- Calculate dates with a variety of functions

#### Custom Number Formats

- Customize number formats to meet specific requirements

### Advanced Functions

#### Nested IF statements

- Nested "IF" statements allow for more than just two possibilities in a single cell

#### IF statements with AND/OR

- Expand the functionality of the IF function by adding an AND / OR criteria

### What If Analysis

#### Goal Seek

- Find the desired result by adjusting an input value

#### Data Tables

- Data Tables show the range of effects of one or two different variables on a formula

### Advanced Analytical Tools

#### Calculation Options

- Minimize volatility by changing calculation options

#### Pivot Table-Base Fields & Sets

- Analyze data in a Pivot Table with increased granularity by defining base fields and sets

#### Pivot Table-Calculations

- Create calculated rows or columns in a Pivot Table that go beyond the source data

#### Pivot Charts

- Create dynamic, graphical representations of Pivot Table data

### Advanced Database Functions

#### XMATCH function

- Return the relative position (column or row number) of a lookup value

#### INDEX-MATCH

- Efficiently return a value or reference from a cell at the intersection of the row and column

#### INDEX-Double MATCH

- Use a second Match function to create a powerful, two-way lookup tool

### Introduction to Macros

#### Recording Macros

- Record macros that involve formatting and calculations

### Dynamic Arrays

#### Dynamic Arrays

- Use formulas that can return arrays of variable size

### End of Class Projects

#### Projects

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

## Schedule
- Jun 9, 2026 – Jun 11, 2026 — Live Online
- Jun 18, 2026 10:00am–5:00pm — Live Online
- Jul 1, 2026 10:00am–5:00pm — Live Online
- Jul 9, 2026 10:00am–5:00pm — Live Online
- Jul 22, 2026 10:00am–5:00pm — Live Online
- Jul 31, 2026 10:00am–5:00pm — Live Online
- Aug 13, 2026 10:00am–5:00pm — Live Online
- Aug 16, 2026 10:00am–5:00pm — Live Online
- Aug 18, 2026 – Aug 20, 2026 — Live Online
- Aug 26, 2026 10:00am–5:00pm — Live Online
- Sep 3, 2026 10:00am–5:00pm — Live Online
- Sep 10, 2026 10:00am–5:00pm — Live Online
- Sep 22, 2026 – Sep 24, 2026 — Live Online
- Oct 11, 2026 10:00am–5:00pm — Live Online
- Oct 15, 2026 10:00am–5:00pm — Live Online
- Nov 11, 2026 10:00am–5:00pm — 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:** $249