Vincent Vankrunkelsven
Vincent Vankrunkelsven

Spreadsheet instructor at DataCamp

Vincent has a Master's degree in Computer Science and has several years of experience with spreadsheets in a professional context. He experienced first-hand the difficulties that come with creating a spreadsheet that is beautiful as well as functional. This made him passionate about teaching people how to use spreadsheets correctly.

See More
  • Richie Cotton

    Richie Cotton

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

    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.

  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.

info Artboard a