Course
Intermediate Google Sheets
BasicSkill Level
Updated 09/2024Google SheetsData Preparation4 hr12 videos48 Exercises4,150 XP56,945Statement of Accomplishment
Create Your Free Account
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
Training 2 or more people?
Try DataCamp for BusinessCourse Description
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.Prerequisites
Data Analysis in Google Sheets1
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.
2
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.
3
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.
4
Positional Matching
In which you learn about cell addresses, advanced matching, sorting and filtering, and simple imputation.
Intermediate Google Sheets
Course Complete
Earn Statement of Accomplishment
Add this credential to your LinkedIn profile, resume, or CVShare it on social media and in your performance reviewEnroll Now
FAQs
What topics does this course cover beyond basic Google Sheets?
You will learn data type interrogation and conversion, log and square root transformations, random number generation, logical operations, error handling, and advanced positional matching.
What datasets are used in the exercises?
You will explore datasets on 100-meter sprint world records, asteroid close encounters, benefit claims, and butterflies throughout the four chapters.
Does the course cover how to handle missing data and errors?
Yes. Chapter 3 teaches you to work with logical TRUE and FALSE values, handle missing values, and manage different error types in Google Sheets.
What prerequisites do I need?
You should complete Introduction to Google Sheets and Data Analysis in Google Sheets first, as this course expands on the vocabulary and techniques from those courses.
What is covered in the positional matching chapter?
Chapter 4 teaches cell addresses, advanced matching functions, sorting and filtering techniques, and simple imputation methods for replacing missing values.
Join over 19 million learners and start Intermediate Google Sheets today!
Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.Grow your data skills with DataCamp for Mobile
Make progress on the go with our mobile courses and daily 5-minute coding challenges.