As listed in the Master Workbook (see link at the top of the page), there are functions grouped into categories. This video is a demonstration of the Experience Level 1 – Lookup & Reference functions.
The functions covered in this video lesson are:
ADDRESS – COLUMN — COLUMNS — HLOOKUP – INDEX — INDIRECT
LOOKUP — MATCH — OFFSET – ROW – ROWS – VLOOKUP
Extract of Level 1 – Lookup and Reference Functions from the Master Workbook: