This course will expand your Google Sheets vocabulary. You'll dive deeper into data types, practice manipulating numeric and logical data, explore missing data and error types, and calculate some summary statistics. As you go, you'll explore datasets on 100m sprint world records, asteroid close encounters, benefit claims, and butterflies.
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.
Curriculum Architect at DataCamp
“I've used other sites—Coursera, Udacity, things like that—but DataCamp's been the one that I've stuck with.”
Devon Edwards Joseph
Lloyds Banking Group
“DataCamp is the top resource I recommend for learning data science.”
Harvard Business School
“DataCamp is by far my favorite website to learn from.”
Decision Science Analytics, USAA