Skip to main content

Intermediate Spreadsheets

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

Start Course for Free
4 Hours12 Videos48 Exercises43,088 Learners

Create Your Free Account

GoogleLinkedInFacebook

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.

Loved by learners at thousands of companies


Course Description

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.
  1. 1

    What's in a cell?

    Free

    In which you learn to interrogate cells to determine the data type of their contents, and to convert between data types.

    Play Chapter Now
    Data types for data science
    50 xp
    What IS*() the data type?
    100 xp
    Checking rarer data types
    100 xp
    Finding missing data
    100 xp
    Dteectnig bdaly tpyed dtaa
    100 xp
    Convert or die!
    50 xp
    Making numbers while the sun shines
    100 xp
    How the 104% live
    100 xp
    Converting logical values to numbers
    100 xp
    Preaching to the CONVERT()ed
    100 xp

In the following tracks

Spreadsheet Fundamentals
Richie Cotton HeadshotRichie Cotton

Data Evangelist at DataCamp

Richie is a Data Evangelist at DataCamp. He has been using R since 2004, in the fields of proteomics, debt collection, and chemical health and safety. He has released almost 30 R packages on CRAN and Bioconductor – most famously the assertive suite of packages – as well as creating and contributing to many others. He also has written two books on R programming, Learning R and Testing R Code.
See More

What do other learners have to say?

Join over 11 million learners and start Intermediate Spreadsheets today!

Create Your Free Account

GoogleLinkedInFacebook

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.