Function library
Every Excel function
All 521 functions from Microsoft’s list, grouped the way Excel groups them. 500 run right here in the practice sheet; the rest come with step-by-step guides for desktop Excel.
Database
Summarise a table with a criteria range: DSUM, DAVERAGE, DCOUNT, DGET.
12 functions
DAVERAGEAverage of a column for matching recordsDCOUNTCounts numbers in matching recordsDCOUNTACounts non-empty cells in matching recordsDGETThe single value that matchesDMAXLargest value in matching recordsDMINSmallest value in matching recordsDPRODUCTProduct of values in matching recordsDSTDEVSample standard deviation of matching recordsDSTDEVPPopulation standard deviation of matching recordsDSUMSum of a column for matching recordsDVARSample variance of matching recordsDVARPPopulation variance of matching records