Formulas

Sums and Counts

SUMPRODUCT
Count functions
Distinct Count formula

 

Mathematics

Percentages
Percentiles
Rounding up and down
Significant figures
Squaring numbers
Net Promoter Score (NPS)

 

Dates
Date and time functions overview
Date differences and ages

 

Text
FIND and SEARCH functions
FORMULATEXT function
Return the last value in a column
File, folder and worksheet names
Hyperlinks

 

Lookups

INDEX and MATCH functions

 

Booleans

Exclusive Or function

 

Data cleansing

Data cleansing functions

 

Troubleshooting
Formula Auditing overview
Formulas not dragging down
Column references showing as number
Formula being treated as text