Skip to main content
HomeBusiness Intelligence

Course

Introduction to Google Sheets

BasicSkill Level
4.8+
1,770 reviews
Updated 12/2025
Bring your Google Sheets to life by mastering fundamental skills such as formulas, operations, and cell references.
Start Course for Free
Google SheetsData Preparation2 hr7 videos26 Exercises2,150 XP48,756Statement 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

Group

Training 2 or more people?

Try DataCamp for Business

Course Description

Google Sheets stands out as one of the premier data analytics tools, empowering millions of users worldwide to extract valuable insights from diverse datasets. Whether you're a professional seeking to enhance your analytical skills or a novice eager to dive into the world of data, our comprehensive online course is tailored for you.

Mastering Spreadsheet Fundamentals

Delve into the core of spreadsheet functionality as you embark on a journey to grasp the fundamentals of Google Sheets. Through hands-on exercises, you'll gain proficiency in working with tabular data and executing intricate calculations. This course goes beyond the basics, equipping you with the skills to create your own formulas, ensuring you have the tools to manipulate and analyze data effectively. Explore the art of referencing cells, fostering a deep understanding of how to interconnect data points and breathe life into your spreadsheets.

Become a Formula Maestro and Spreadsheet Architect

Elevate your spreadsheet prowess by becoming a formula maestro and a spreadsheet architect. Uncover the secrets of crafting complex formulas that can tackle real-world data challenges. Learn how to design spreadsheets that not only organize information seamlessly but also communicate insights effectively. Whether you're looking to streamline work processes or make data-driven decisions, this course provides you with the knowledge and skills to transform Google Sheets into a powerful tool in your professional toolkit.

Feels like what you want to learn?

Start Course for Free

What you'll learn

  • Identify the correct spreadsheet navigation and cell-selection methods, including cell references and cell ranges.
  • Recognize supported file types and identify appropriate import options for loading data into Google Sheets.
  • Identify the correct use of formulas, arithmetic operators, percentage calculations, and comparison operators to perform numerical and Boolean evaluations.
  • Differentiate between cell data types (plain text, number, date, currency) and identify appropriate formatting options such as decimal precision.
  • Distinguish between relative and absolute cell references and identify when to apply each in calculations and copied formulas.

Prerequisites

There are no prerequisites for this course
1

Cells and Formulas

You’ll begin by learning how to use spreadsheets to extract insights from your data. In this chapter, you'll learn how to write formulas, perform calculations in spreadsheets, use comparison operators, and format cells.
Start Chapter
2

Cell References

In this chapter, you'll learn about one of the most powerful concepts in spreadsheets: cell references. Using geographical and demographical data from the ten most populous countries, you'll utilize cell references to make your spreadsheets reactive to changes and learn useful shortcuts to start applying calculations at scale.
Start Chapter
Introduction to 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
Enroll Now

Don’t just take our word for it

*4.8
from 1,770 reviews
86%
12%
1%
0%
0%
  • Alif
    4 hours ago

  • Daniel
    7 hours ago

  • Johanna
    8 hours ago

  • Melquisedec
    10 hours ago

  • Guillermo
    yesterday

  • Linet
    yesterday

Alif

Johanna

Melquisedec

FAQs

Is this course suitable for complete beginners?

Yes. No prior spreadsheet or data experience is required. The course starts with the basics of navigating a spreadsheet, identifying cells, and entering data before introducing any formulas.

What can I calculate using the formulas taught in this course?

You will be able to perform arithmetic using addition, subtraction, multiplication, division, and exponentiation, as well as percentage increases and decreases, and comparisons between values using operators like greater than and less than.

What is an absolute cell reference and why does it matter?

An absolute cell reference locks a cell's row, column, or both so the reference does not shift when you copy a formula to another cell. The course covers all three locking variations using the dollar sign syntax.

What datasets will I work with?

Chapter 1 uses food ingredient and calorie data to practice formulas, and Chapter 2 uses country population and land area data to apply cell references and calculations in a real-world context.

Who is this course most useful for?

It is designed for data consumers, analysts, and business leaders who need to build and interpret spreadsheets for tasks like tracking KPIs, compiling reports, or performing everyday calculations without writing code.

Does this course cover Google Sheets, Microsoft Excel, or both?

The course teaches core spreadsheet concepts and formula syntax that apply across both tools. The skills you learn, including cell references, arithmetic operators, and data formatting, transfer directly to either platform.

Join over 19 million learners and start Introduction to 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.