# Advanced Microsoft Excel

Canonical URL: <https://www.careercenters.com/courses/advanced-excel>

## Overview

Develop expertise in Excel’s most advanced features and become a resident Excel expert. Maximize the power of Pivot Tables, save hours by automating tasks with macros, and develop experience with advanced database functions. By the end of this course, you'll have knowledge and skills above and beyond the requirements of most analyst roles.

### Practice-Based Excel Training for Professionals

Learning advanced skills isn’t easy, which is why every student in our advanced class receives a training manual. The manual contains our proprietary curriculum with step-by-step instructions, examples, and activities to practice. Our custom training manual is an indispensable reference for students for years to come.

### Advanced Excel Video Training

Worried you’ll forget a step? Our advanced training tutorial videos explain the most sophisticated features of Excel, providing you with additional instruction beyond the classroom. As an Advanced Excel student, you’ll receive complimentary access to high-quality videos for mobile, tablet, and desktop.

### Free Retake

If you need to brush up on your Excel skills, you can retake the course one time in six months as long as there are spots available.

Before jumping into the Advanced Course, save 15% by enrolling in the [Excel bootcamp](/courses/excel-bootcamp-nyc), which includes our beginner, intermediate, and advanced Excel courses.

## What you'll learn

- Create Powerful Formulas
- Customize Text and Number formats
- Use Advanced Functions
- Perform What if Analysis
- Use Advanced Analytical Tools and Database Functions
- Record a Macro

## Prerequisites

Attendees must have Excel proficiency equivalent to our [Intermediate Excel course](/courses/intermediate-excel), 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
- Jul 1, 2026 10:00am–5:00pm — NYC
- Jul 9, 2026 10:00am–5:00pm — NYC
- Jul 22, 2026 10:00am–5:00pm — NYC
- Jul 31, 2026 10:00am–5:00pm — NYC
- Aug 7, 2026 10:00am–5:00pm — NYC
- Aug 16, 2026 10:00am–5:00pm — NYC
- Aug 18, 2026 – Aug 20, 2026 — NYC
- Aug 19, 2026 10:00am–5:00pm — NYC
- Aug 26, 2026 10:00am–5:00pm — NYC
- Sep 3, 2026 10:00am–5:00pm — NYC
- Sep 10, 2026 10:00am–5:00pm — NYC
- Sep 22, 2026 – Sep 24, 2026 — NYC
- Oct 11, 2026 10:00am–5:00pm — NYC
- Oct 15, 2026 10:00am–5:00pm — NYC
- Nov 11, 2026 10:00am–5:00pm — NYC

## Pricing

**Tuition:** $249