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

2 Hours7 Videos26 Exercises6,746 Learners

or

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

50 xp
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.

In the following tracks

Collaborators

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