Home / Categories / Functions
Functions
Formulas from first steps to LET and LAMBDA. Follow the order, or jump to what you need.
Formula Basics: Operators, Wildcards and the Formula Bar
AnalyticsDecision SupportModelling & Forecasting
Relative, Absolute and 3D References
AnalyticsDecision SupportModelling & Forecasting
Conditional Aggregation: SUMIFS, COUNTIFS, AVERAGEIFS, MINIFS, MAXIFS and SUMPRODUCT
AnalyticsDecision SupportModelling & Forecasting
Conditional Sums Compared: Five Techniques, Including Database Functions
AnalyticsData Organization
Rounding Functions: ROUND, ROUNDUP, MROUND, CEILING.MATH, FLOOR.MATH and TRUNC
AnalyticsDecision SupportModelling & Forecasting
Descriptive Statistics: Averages, Ranking, Percentiles and Variability
AnalyticsDecision SupportModelling & Forecasting
TREND and GROWTH: Projecting a Series in a Straight Line or a Curve
AnalyticsDecision SupportModelling & Forecasting
Combining and Formatting Text: CONCAT, TEXTJOIN, TEXT and FORMULATEXT
Data OrganizationAnalytics
Extracting and Cleaning Text: LEFT, MID, SEARCH, SUBSTITUTE, CHAR and TEXTSPLIT
Data OrganizationAnalytics
VLOOKUP, HLOOKUP and XLOOKUP: Finding Data in a Table
Data OrganizationAnalyticsDecision SupportModelling & Forecasting
INDEX, MATCH and CHOOSE: Flexible Lookups and Selectors
Data OrganizationAnalyticsDecision SupportModelling & Forecasting
Dynamic References: OFFSET, INDIRECT and ADDRESS
Data OrganizationAnalyticsDecision SupportModelling & Forecasting
Date Functions: DATE, EDATE, EOMONTH, NETWORKDAYS and More
Data OrganizationAnalyticsModelling & Forecasting
Logic and Errors: IF, IFS, AND, OR, IFERROR and Error Values
Data OrganizationAnalyticsDecision SupportModelling & Forecasting
Dynamic Arrays: Spill, the # Operator and SEQUENCE
AnalyticsDecision SupportModelling & Forecasting
FILTER, UNIQUE, SORT and SORTBY
Data OrganizationAnalyticsDecision SupportModelling & Forecasting
GROUPBY and PIVOTBY: Summaries as Formulas
AnalyticsDecision SupportReporting & Presentation
LET: Naming the Steps Inside a Formula
AnalyticsDecision SupportModelling & Forecasting
LAMBDA, MAP, REDUCE and SCAN: Your Own Functions Without VBA
AnalyticsModelling & ForecastingAutomation & AI