Analyzing Data in Spreadsheets
Learn how to analyze data with spreadsheets using functions such as SUM(), AVERAGE(), and VLOOKUP().Start Course for Free
3 Hours27 Exercises89,952 Learners2700 XP
Create Your Free Account
Loved by learners at thousands of companies
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.
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.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
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
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.
What do other learners have to say?
Join over 11 million learners and start Analyzing Data in Spreadsheets today!
Create Your Free Account