Skip to main content
HomeGoogle Sheets

Introduction to Google Sheets

Bring your Google Sheets to life by mastering fundamental skills such as formulas, operations, and cell references.

Start Course for Free
2 hours7 videos26 exercises28,667 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.
Group

Training 2 or more people?

Try DataCamp for Business

Loved by learners at thousands of companies

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.

For Business

Training 2 or more people?

Get your team access to the full DataCamp platform, including all the features.
DataCamp for BusinessFor a bespoke solution book a demo.

In the following Tracks

Google Sheets Fundamentals

Go To Track
  1. 1

    Cells and Formulas

    Free

    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.

    Play Chapter Now
    Navigating Google Sheets
    50 xp
    Importing data into Google Sheets
    50 xp
    Changing cell contents
    100 xp
    Cell ranges
    100 xp
    Cell mathematics!
    50 xp
    Formulas
    100 xp
    Exponents and parentheses
    100 xp
    Percentages
    100 xp
    Data types and formatting
    50 xp
    Working with text and numbers
    100 xp
    Working with currencies and dates
    100 xp
    Comparison operators and logicals
    100 xp
  2. 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.

    Play Chapter Now
    Introduction to cell references
    50 xp
    Using cell references
    100 xp
    Circular references
    50 xp
    Copying references
    100 xp
    Calculations with cell references
    50 xp
    Mathematical operators and references
    100 xp
    Percentages and references
    100 xp
    Comparison operators and references
    100 xp
    Absolute references
    50 xp
    Using absolute references
    100 xp
    Absolute references: fixing rows
    100 xp
    Absolute references: fixing columns
    100 xp
    References everywhere!
    100 xp
    Congratulations!
    50 xp
For Business

Training 2 or more people?

Get your team access to the full DataCamp platform, including all the features.

In the following Tracks

Google Sheets Fundamentals

Go To Track

datasets

Bank AccountsFood IngredientsMost Populous Countries

collaborators

Collaborator's avatar
Amy Peterson
James Chapman HeadshotJames Chapman

Curriculum Manager, DataCamp

James is a Curriculum Manager at DataCamp, where he collaborates with experts from industry and academia to create courses on AI, data science, and analytics. He has led nine DataCamp courses on diverse topics in Python, R, AI developer tooling, and Google Sheets. He has a Master's degree in Physics and Astronomy from Durham University, where he specialized in high-redshift quasar detection. In his spare time, he enjoys restoring retro toys and electronics.

Follow James on LinkedIn
See More

What do other learners have to say?

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