Excel Glossary

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

Quick Links

Empty string in Excel formula

Empty string

Example of an "eta lambda" with the BYROW function

eta lambda

Excel Subscription Information at File > Account

Excel 365

Excel dates are just serial numbers (example)

Excel date

Excel datetimes include both date and time values

Excel datetime

Excel Table example

Excel Table

$Excel times are fractional parts of a day (example)$

Excel time

Example of expanding reference in Excel

Expanding reference

Excel fill handle

Fill handle

Example of Excel formula

Formula

Example of Excel Formula Bar

Formula Bar

Example of full column references in a SUMIF function

Full column reference

Example of full row references in a SUM formula

Full row reference

Example of Excel formula based on a single function

Function

Excel function argument example

Function argument

Function screen tip window

Function screen tip

Helper column

Output of COSH and SINH for hyperbolic angles.

Hyperbolic Angle

Excel implicit intersection example

Implicit Intersection

Legacy Excel does not include dynamic array formulas and functions

Legacy Excel

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