In this course, you will :
- Learn how to interrogate cells to determine the data type of their contents and how to convert data types.
- Learn how to log and square root numbers, round them up and down, and generate random numbers.
- Learn how to work with logical data that contains TRUE and FALSE values, as well as how to deal with missing values and errors.
- Cell addresses, advanced matching, sorting and filtering, and simple imputation are all covered.
- What's in a cell?
- Working with numbers
- Logic & Errors
- Positional Matching