# Excel 6: Named Ranges, Lookups, Sort & Filter (Intermediate Level)

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

## Overview

_This class is in the intermediate tier of our twelve-part mini Excel class series. Fundamental Excel experience is required to attend._

Learn intermediate Microsoft Excel skills in this one hour and 15-minute session:

1. Named Ranges
2. VLOOKUP & XLOOKUP
3. Sort & Filter

## Prerequisites

Students must have Excel proficiency equivalent to [Excel 1](/courses/excel-1), [Excel 2](/courses/excel-2), [Excel 3](/courses/excel-3), and [Excel 4](/courses/excel-4)  **or** [Excel for Business Fundamentals](/courses/excel-fundamentals), including basic functions and formulas, printing, formatting, basic charts, and tables.

## Pricing

**Tuition:** $149