Build your ultimate AI agent
コース説明
前提条件
カリキュラム
コース概要
1
What's in a cell?
In which you learn to interrogate cells to determine the data type of their contents, and to convert between data types.
- Data types for data science50 XP
- What IS*() the data type?100 XP
- Checking rarer data types100 XP
- Finding missing data100 XP
- Dteectnig bdaly tpyed dtaa100 XP
- Convert or die!50 XP
- Making numbers while the sun shines100 XP
- How the 104% live100 XP
- Converting logical values to numbers100 XP
- Preaching to the CONVERT()ed100 XP
2
Working with numbers
In which you learn to apply log and square root transformations to numbers, round them up and down, and generate random numbers.
3
Logic & Errors
In which you learn how to work with logical data consisting of TRUE and FALSE values, and how to handle missing values and errors.
4
Positional Matching
In which you learn about cell addresses, advanced matching, sorting and filtering, and simple imputation.
S
中級 Google Sheets
コース修了
