Excel Glossary

Below is a list of useful Excel terminology. Contact us with suggestions.

Quick Links

Example of "lifting", an array calculation behavior in Excel

Lifting

Excel function list separator varies by region

List separator

Example of locked table reference in formula

Locked table reference

Logical operators in Excel formulas

Logical operators

Examples of logical tests with Excel formulas

Logical test

$Math and Formula Operators in Excel$

Math Operators

Example of mixed reference in Excel

Mixed reference

Example of multi-cell array formula

Multi-cell array formula

The Name Box in an Excel worksheet

Name Box

Name Manager in Excel

Name Manager

Example of Named Range in Excel

Named range

Example of nesting in an Excel formula

Nesting

Example of nominal data in Excel bar chart

Nominal data

Examples of Excel number formats

Number format

Order of operations in Excel

Order of operations

Ordinal data

Example of "pairwise lifting", an array calculation behavior in Excel

Pairwise lifting

Percentage Number Format in Excel

Percentage number format

Example of Excel Pivot Table together with raw data

Pivot Table

The Power Query interface

Power Query

Pages

Cover art for 101 Excel Functions You Should Know

Download 100+ Important Excel Functions

Holy cow thank you Dave, your article "VLOOKUP with numbers and text" saved my butt. Many appreciations and happy friday!

Cameron

More Testimonials

Get Training

Quick, clean, and to the point training

Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed. Each video comes with its own practice worksheet.

View Paid Training & Bundles

Excel foundational video course

Excel Pivot Table video training course

Excel formulas and functions video training course

Excel Charts video training course

Video training for Excel Tables

Dynamic Array Formulas