In which you learn to interrogate cells to determine the data type of their contents, and to convert between data types.
In which you learn to apply log and square root transformations to numbers, round them up and down, and generate random numbers.
In which you learn how to work with logical data consisting of TRUE and FALSE values, and how to handle missing values and errors.
In which you learn about cell addresses, advanced matching, sorting and filtering, and simple imputation.