Lim Keng Kee has completed

3 hours
2,700 XP

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

### .css-1goj2uy{margin-right:8px;}Group.css-gnv7tt{font-size:20px;font-weight:700;white-space:nowrap;}.css-12nwtlk{box-sizing:border-box;margin:0;min-width:0;color:#05192D;font-size:16px;line-height:1.5;font-size:20px;font-weight:700;white-space:nowrap;}Training 2 or more people?

Try DataCamp for BusinessFor a bespoke solution book a demo.
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.

### GroupTraining 2 or more people?

Collaborators

Vincent Vankrunkelsven

Data and Software Engineer @DataCamp

See More