Analyzing Data in Spreadsheets
Learn how to analyze data with spreadsheets using functions such as SUM(), AVERAGE(), and VLOOKUP().
Start Course for Free3 Hours27 Exercises
Create Your Free Account
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
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
Predefined functions
FreeThis 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.
First function - ROUND100 xpFunction composition - SQRT100 xpFunctions and ranges - MIN, MAX100 xpSelecting ranges - SUM, AVERAGE, MEDIAN100 xpMultiple arguments - RANK100 xpEven more arguments - RANK100 xpString manipulation - LEFT, RIGHT100 xpString information - LEN, SEARCH100 xpCombining strings - CONCATENATE100 xpDate functions - WEEKDAY100 xpComparing dates100 xpCombining functions100 xp - 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.
Performance statistics100 xpFlow control - IF100 xpNested logical functions - IF100 xpCombining logical values - OR, WEEKDAY100 xpConditional counting - COUNTIF100 xpConditional aggregation - COUNTIF100 xpConditional sum - SUMIF100 xpConditional average - AVERAGEIF100 xpAdvanced conditions - AVERAGEIF100 xpFilters - FILTER, DATEVALUE, MEDIAN100 xpGrades in class100 xpAutomating the lookup - VLOOKUP100 xpMore about lookup - VLOOKUP100 xpHorizontal lookup - HLOOKUP100 xpWeighted average - SUMPRODUCT, HLOOKUP100 xp
Collaborators
Vincent Vankrunkelsven
See More
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.
Join over 12 million learners and start Analyzing Data in Spreadsheets today!
Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.