Intermediate Spreadsheets

Go to class

Write Review

Free Online Course: Intermediate Spreadsheets provided by DataCamp is a comprehensive online course, which lasts for 4 hours worth of material. The course is taught in English and is free of charge. Upon completion of the course, you can receive an e-certificate from DataCamp. Intermediate Spreadsheets is taught by Richie Cotton.

via DataCamp

4 hours worth of material

Self Paced

Expand your spreadsheets vocabulary by diving deeper into data types, including numeric data, logical data, and missing data.

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.

Syllabus

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.

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.

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.

Positional Matching
-In which you learn about cell addresses, advanced matching, sorting and filtering, and simple imputation.

0, based on 0 Course votes at GetYourEducation

Start your review of Intermediate Spreadsheets

Add review ->

Language

English
Certificate
Certificate Available
Date of Start
30th July, 2022
Price
Free Trial Available
Provider
DataCamp
Taught By

Richie Cotton
Share this course