Function Categories

Browse all Excel & Google Sheets functions organized by category

Financial Functions

Loan payments, interest rates, investments, and depreciation calculations

Averages, standard deviations, correlations, and forecasting

Rounding, sums, products, and mathematical operations

String manipulation, concatenation, and text formatting

Date calculations, time formatting, and duration tracking

Query and aggregate data with criteria-based functions

Find and retrieve data across your spreadsheet with VLOOKUP, XLOOKUP, INDEX/MATCH

Conditional logic, branching, and decision-making in formulas

FILTER, SORT, UNIQUE — modern array functions for Excel 365

Check cell types, errors, and metadata about your data

Exclusive Google Sheets functions: QUERY, IMPORTRANGE, ARRAYFORMULA