Skip to main content

Intermediate Spreadsheets

4.3+
11 reviews
Beginner

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 Exercises
46,681 LearnersTrophyStatement of Accomplishment

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

Don’t just take our word for it

*4.3
from 11 reviews
73%
0%
18%
9%
0%
Sort by
  • Alexander P.
    2 months

    Very helpful

  • Igor R.
    3 months

    Great course and lecture as well as all others in Spreadsheets Fundamentals skill track. It totally changed my perception of spreadsheets as a kind of old-fashioned gizmo. Huge and powerful instrument. Great content!

  • Joshua M.
    4 months

    Excellent tutorials

  • Alexander P.
    5 months

    Excellent course

  • Gorkem K.
    11 months

    I enjoyed and learned. Thanks.

"Very helpful"

Alexander P.

"Great course and lecture as well as all others in Spreadsheets Fundamentals skill track. It totally changed my perception of spreadsheets as a kind of old-fashioned gizmo. Huge and powerful instrument. Great content!"

Igor R.

"Excellent tutorials"

Joshua M.

Join over 12 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.