Formulas

Sums and Counts

SUMPRODUCT
Count functions
Distinct Count formula

 

Numbers

Percentages
Rounding up and down
Squaring numbers

 

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

 

Booleans

Exclusive Or function

 

Data cleansing

Data cleansing functions

 

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

 

Auditing formulas
Formula Auditing overview

 

Miscellaneous

Hyperlinks