Quick reference for spreadsheet terms, functions, and concepts. Click any term to learn more.
A lookup function that searches for a value in the first column of a range and returns a value from a specified column in the same row.
An interactive tool that summarizes large datasets by reorganizing and aggregating data based on selected fields, allowing users to analyze information without writing formulas.
A feature that automatically applies formatting (colors, icons, data bars) to cells based on their values or specified conditions, making patterns and outliers visually apparent.
A recorded or written sequence of commands and actions that can be saved and replayed to automate repetitive tasks in spreadsheet applications.
A formula that performs multiple calculations on one or more sets of values and returns either a single result or multiple results, enabling complex operations in a single cell.