Skip to main content

Intermediate Google Sheets

4.4+
12 reviews
Beginner

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

Start Course for Free
4 Hours12 Videos48 Exercises
47,476 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.

Advanced Data Types and Manipulation

In the first part of the course, we focus on understanding and manipulating various data types in Google Sheets. You'll gain proficiency in handling numeric and logical data, crucial for effective data analysis. This section is designed to build your skills in data manipulation, teaching you techniques to manage and transform data efficiently. Whether you're dealing with large datasets or complex data structures, these skills are essential for making the most out of your data in Google Sheets.

Dealing with Missing Data and Errors

A common challenge in data analysis is dealing with missing data and error types. This course guides you through the intricacies of identifying and managing missing data, as well as understanding and resolving various error types that can occur in Google Sheets. You'll learn how to clean your data, ensuring its accuracy and reliability. This is a critical skill for anyone looking to conduct thorough and error-free data analysis.

Practical Application with Real Datasets

Throughout the course, you'll apply what you've learned using real-world datasets. These include records of 100m sprint world records, asteroid close encounters, benefit claims, and data on butterflies. By exploring these diverse datasets, you'll learn how to calculate summary statistics and gain insights from real data. This hands-on experience not only reinforces your learning but also prepares you to tackle a wide range of data analysis tasks with confidence.
  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

Google Sheets 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.4
from 12 reviews
75%
0%
17%
8%
0%
Sort by
  • Joshua M.
    7 months

    Excellent tutorials

  • Alexander P.
    7 months

    Excellent course

  • Gorkem K.
    about 1 year

    I enjoyed and learned. Thanks.

  • Sofienne F.
    about 1 year

    Very good course

  • Abdelrahman g.
    about 1 year

    great content

"Excellent tutorials"

Joshua M.

"Excellent course"

Alexander P.

"I enjoyed and learned. Thanks."

Gorkem K.

Join over 13 million learners and start Intermediate Google Sheets 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.