4.7+
28 reviews
Beginner

Learn how to analyze data with spreadsheets using functions such as SUM(), AVERAGE(), and VLOOKUP().

3 Hours27 Exercises

or

## Course Description

This course will dig deeper into some of the core functionality of Google Sheets. There's a whole bunch of predefined functions we'll cover, like `SUM()` and `AVERAGE()`, and `VLOOKUP()`. We'll apply these techniques to do some analysis on your grades in school, look at performance statistics within a company, track monthly sales, and look at some real geographical information about the countries of the world.
1. 1

### Predefined functions

Free

This chapter introduces a very useful feature in Google Sheets: predefined functions. You'll use these functions to solve complex problems without having to worry about specific calculations. We’ll cover a lot of predefined functions, including functions for numbers, functions for strings, and functions for dates.

Play Chapter Now
First function - ROUND
100 xp
Function composition - SQRT
100 xp
Functions and ranges - MIN, MAX
100 xp
Selecting ranges - SUM, AVERAGE, MEDIAN
100 xp
Multiple arguments - RANK
100 xp
Even more arguments - RANK
100 xp
String manipulation - LEFT, RIGHT
100 xp
String information - LEN, SEARCH
100 xp
Combining strings - CONCATENATE
100 xp
Date functions - WEEKDAY
100 xp
Comparing dates
100 xp
Combining functions
100 xp
2. 2

### Conditional functions and lookups

In the last chapter of the course, you'll master more advanced functions like IF() and VLOOKUP(). Conditional and lookup functions won’t seem so scary after you completed this chapter.

Collaborators

Vincent Vankrunkelsven

Data and Software Engineer @DataCamp

Vincent has a Master's degree in Computer Science and has several years of experience scaling up the DataCamp's platform as a Software Engineer. He experienced first-hand the difficulties that come with building scalable data products. This made him passionate about teaching people how to do tackle these problems the right way.
See More

## Don’t just take our word for it

*4.7
from 28 reviews
82%
11%
4%
4%
0%
Sort by
8 months

I love the way its purely Practical. Its easy to understand.

• Pavel S.
9 months

Uturuque

• Riaz E.
9 months

I learn the basic of data analysis using spreadsheet fron this course. The course lessons are easy, understandable, proper examples, handy, concise, topic-related texts.

• David P.
10 months

Excellent introduction!

• Gustavo M.
10 months

Great

"I love the way its purely Practical. Its easy to understand."

"Uturuque"

Pavel S.

"I learn the basic of data analysis using spreadsheet fron this course. The course lessons are easy, understandable, proper examples, handy, concise, topic-related texts."

Riaz E.