Skip to main content

Spreadsheets Foundations

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

Start Course for Free
2 Hours7 Videos26 Exercises2150 XP

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

Spreadsheets software is one of the most popular and powerful data analytics tools. Millions of people use software such as Google Sheets and Microsoft Excel to acquire meaningful insights from data. In this course, you'll learn the fundamentals of spreadsheets by working with tabular data and performing calculations. You'll also create your own formulas and learn how to use references to connect cells and bring your spreadsheets to life.

  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 Spreadsheets
    50 xp
    Importing data into spreadsheets
    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

Datasets

Bank AccountsFood IngredientsMost Populous Countries

Collaborators

amy-4121b590-cc52-442a-9779-03eb58089e08
Amy Peterson
James Chapman Headshot

James Chapman

Content Developer, DataCamp

James is a Content Developer at DataCamp. He has a Master's degree in Physics and Astronomy from Durham University, where he specialized in quasar detection and tutored Math and English. He joined DataCamp as a learner in 2018, and the data skills learned on DataCamp were quickly integrated into his scientific projects. 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 10 million learners and start Spreadsheets Foundations 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.