# Advanced Excel for Business

Canonical URL: <https://training-nyc.com/courses/advanced-excel>

## Overview

Advance your career with this essential course for professionals that use Excel daily. You'll make functions more flexible, take Pivot Tables to the next level, and automate tasks with macros. Utilize Excel's most important tools with training in core database functions. If you have strong working knowledge in Excel and want to save even more time with custom shortcuts and advanced features, this is the perfect course for you. 

This course is part of our [Excel Bootcamp](/courses/excel-bootcamp-nyc). Enroll in our three-course package and save 15%.

**Class Note:**  A PC or Mac will be provided for use during class. The instructor will present on a PC but will explain the differences for Mac students.

## What you'll learn

- What-if Analysis: Goal Seek & Data Tables

- Advanced cell locking

- Create more flexible lookup functions with INDEX-MATCH

- Advanced Pivot Table techniques

- Record relative and absolute macros

- Advanced nested functions

- Work without a mouse using Hot Keys

## 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
- Jun 9, 2026 – Jun 11, 2026 — NYC
- Jun 18, 2026 10:00am–5:00pm — NYC
- Jun 18, 2026 10:00am–5:00pm — NYC
- 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 13, 2026 10:00am–5:00pm — NYC
- Aug 16, 2026 10:00am–5:00pm — NYC
- Aug 18, 2026 – Aug 20, 2026 — 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

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