Skip to main content
HomeGoogle Sheets

course

Data Analysis in Google Sheets

Beginner
4.6+
15 reviews
Updated 12/2024
Learn to use Google Sheets to clean, analyze, and draw insights from data. Discover how to sort, filter, and use VLOOKUP to combine data.
Start course for free

Included for FreePremium or Teams

Google SheetsData Manipulation3 hours11 videos34 exercises2,800 XP17,229Statement 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.
Group

Training 2 or more people?

Try DataCamp for Business

Loved by learners at thousands of companies

Course Description

Learn how to clear and analyze data in spreadsheets, discover how to use built-in functions to sort and filter data, and use the VLOOKUP function to combine data from different tables. The skills taught in the course can be applied to various industries, such as finance and marketing.

Perform Data Analysis in Spreadsheets

Spreadsheets are the world's most popular data analytics tool. Companies and institutions worldwide use it to transform mountains of raw data into clear insights. Strong spreadsheet skills can open new career paths, make you more employable in various industries, and save hours in your daily tasks.

Clean and Analyze Real-World Data

The course begins by exploring how spreadsheets handle data. You’ll learn to summarize your data using statistics and manipulate it using handy built-in functions to sort, filter, and even extract unique values.

You'll explore the data behind the moons of the Solar System, clean and prepare data on the highest-grossing films, and analyze employee expenses, manufacturing costs, and educational programs to see how your new skills can be applied across industries.

Learn How to Use VLOOKUP

Later chapters in this course will teach you how to analyze your data, including using conditional functions, creating logical expressions, and performing conditional aggregation. You’ll also learn to use ‘the most important function in spreadsheets,’ VLOOKUP, to combine data from different tables before testing your understanding in hands-on exercises.

These spreadsheets skills, functions, and time-saving shortcuts can be applied to any industry, whether you’re looking to move to a career in data analysis, or looking to improve your skills in marketing, finance, HR, logistics, and more.

Prerequisites

Introduction to Google Sheets
1

Exploring Data

Start Chapter
2

Cleaning and Preparing Data

Start Chapter
3

Analyzing Data

Start Chapter
Data Analysis in Google Sheets
Course
Complete

Earn Statement of Accomplishment

Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance review

Included withPremium or Teams

Enroll now

Don’t just take our word for it

*4.6
from 15 reviews
73%
13%
13%
0%
0%
  • Luis C.
    about 2 months

    Great

  • Homero B.
    3 months

    The course was excellent and the instructor's teaching was very accessible, with a considerable range of content segmented into small chapters, creating a pleasant learning experience, despite going into some advanced topics.

  • Tin H.
    4 months

    Suitable for learner

  • Thomas P.
    6 months

    A perfect course for improve my skills ! :)

  • Gilbert B.
    about 1 year

    loved the practice through examples

"Great"

Luis C.

"The course was excellent and the instructor's teaching was very accessible, with a considerable range of content segmented into small chapters, creating a pleasant learning experience, despite going into some advanced topics."

Homero B.

"Suitable for learner"

Tin H.

FAQs

Join over 15 million learners and start Data Analysis in 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.