Skip to main content

Introduction to Spreadsheets

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

Start Course for Free
2 Hours7 Videos26 Exercises
13,147 Learners

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
    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

In the following tracks

Data Skills for BusinessSpreadsheet Fundamentals

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. 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 12 million learners and start Introduction to Spreadsheets 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.