The free module covers

1. Sheets basicsSelect a single cell · Enter a value · Select a range · Add two cells with a formula
2. Essential shortcutsCopy and paste with the keyboard · Undo the last change · Apply bold formatting
3. SUM, AVERAGE, COUNTTotal a range with SUM · Find a mean with AVERAGE · Count numeric cells with COUNT
4. Cell referencesUse relative references for values in the same row · Lock a cell with an absolute reference · Recognize the role of dollar signs in a formula
5. Sort and filterSort a table from highest to lowest · Keep row values together while sorting · Filter a table to one category
6. IF basicsBuild a two-result IF formula · Return text from a number test · Include a threshold with >=
7. Comparisons and IFSCompare with >= and <> · Test a text value · Order grade bands in IFS
8. AND and ORRequire every test with AND · Allow either test with OR · Nest AND and OR inside IF
9. COUNTIF and COUNTIFSCount one criterion with COUNTIF · Write a comparison criterion such as >100 · Count two criteria with COUNTIFS
10. SUMIF, SUMIFS, AVERAGEIFAdd one condition with SUMIF · Add several conditions with SUMIFS · Average matching rows with AVERAGEIF
11. VLOOKUPUse FALSE for an exact match · Choose a return column by index · Recognize #N/A from a missing key
12. XLOOKUPLook left or right with XLOOKUP · Choose a separate result range · Return text for a missing value
13. INDEX and MATCHFind an exact position with MATCH · Return a value by position with INDEX · Combine INDEX and MATCH
14. FILTERFilter rows with a text condition · Filter rows with a number comparison · Grade a complete spilled result
15. Lookup projectWrap a lookup in IFERROR · Replace an expected lookup error · Sum values returned by FILTER