Excel Glossary

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

Quick Links

Example of Absolute Reference in Excel

Absolute reference

Examples of aggregate operations in Excel

Aggregate operation

Arrays and ranges in Excel

Array

Array constant

Example array formula in Excel

Array formula

Example of array of arrays limitation in Excel formulas

Array of arrays

Array operation examples

Array operation

First 128 ASCII characters in Excel

ASCII

Example of bignum used in an Excel formula

BigNum

Example of formula using boolean logic

Boolean logic

Excel formula broadcasting example

Broadcasting

Example of Excel compatibility function

Compatibility function

Examples of concatenation formulas in Excel

Concatenation

Example of CSE array formula in Excel

CSE

Excel Data Type examples

Data Type

Data validation in Excel

Data validation

Example of double unary in Excel formula

Double unary

Example of dynamic array function in Excel

Dynamic array

Example of Dynamic Array formula in Excel

Dynamic Excel

Example of a simple dynamic named range in Excel

Dynamic named range

Pages

Cover art for 101 Excel Functions You Should Know

Download 100+ Important Excel Functions

You saved my butt. I was using VLOOKUP and kept getting NA error, due to formatting i guess. after reading tons of pages you have the answer =VLOOKUP(id&"",planets,2,0)

Charles

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