Intermediate Spreadsheets
Expand your spreadsheets vocabulary by diving deeper into data types, including numeric data, logical data, and missing data.
Start Course for Free4 Hours12 Videos48 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 expand your Google Sheets vocabulary. You'll dive deeper into data types, practice manipulating numeric and logical data, explore missing data and error types, and calculate some summary statistics. As you go, you'll explore datasets on 100m sprint world records, asteroid close encounters, benefit claims, and butterflies.
- 1
What's in a cell?
FreeIn which you learn to interrogate cells to determine the data type of their contents, and to convert between data types.
Data types for data science50 xpWhat IS*() the data type?100 xpChecking rarer data types100 xpFinding missing data100 xpDteectnig bdaly tpyed dtaa100 xpConvert or die!50 xpMaking numbers while the sun shines100 xpHow the 104% live100 xpConverting logical values to numbers100 xpPreaching to the CONVERT()ed100 xp - 2
Working with numbers
In which you learn to apply log and square root transformations to numbers, round them up and down, and generate random numbers.
Common data transformations50 xpLogarithmic transformations100 xpExponential transformations100 xpSquare root transformations100 xpRounding and formatting numbers50 xpRound and round100 xpFrom floor to ceiling100 xpRounding negative numbers100 xpGenerating random numbers50 xpGenerating uniform random numbers100 xpGenerating random numbers from other distributions100 xp - 3
Logic & Errors
In which you learn how to work with logical data consisting of TRUE and FALSE values, and how to handle missing values and errors.
Logical operations50 xpLogical operations are hard... NOT!100 xpAND now for something completely different100 xpYea OR nay100 xpFlow control50 xpIF only100 xpLots of IFS100 xpSWITCH it on!100 xpBlanks, missing values, & errors50 xpBlankety blank100 xpGoing missing100 xpErrors and omissions100 xpWhat's the problem?50 xp - 4
Positional Matching
In which you learn about cell addresses, advanced matching, sorting and filtering, and simple imputation.
Cell addresses50 xpWorking with cell addresses100 xpFrom addresses to values100 xpFinding nearby cells with offsets100 xpLocal addresses100 xpLookups & matching50 xpA VLOOKUP refresher100 xpSorted!100 xpMatching values100 xpBringing it all together50 xpAdvanced filtering100 xpConditional summary statistics100 xpSimple imputation100 xpCongratulations!50 xp
In the following tracks
Spreadsheet FundamentalsPrerequisites
Data Analysis in SpreadsheetsRichie Cotton
See More
Data Evangelist at DataCamp
Richie is a Data Evangelist at DataCamp. He has been using R since 2004, in the fields of proteomics, debt collection, and chemical health and safety. He has released almost 30 R packages on CRAN and Bioconductor – most famously the assertive suite of packages – as well as creating and contributing to many others. He also has written two books on R programming, Learning R and Testing R Code.
Join over 12 million learners and start Intermediate 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.