If you are interested in learning + improving your Spreadsheet skills, here are some courses you can do on Datacamp (a paid annual subscription). Datacamp’s Spreadsheet courses are designed such that you can practice on Google Sheets as you learn. A context and pre-filled data are provided in each spreadsheet so your learning pace is fast.
TIP: Buy their annual subscription during Thanksgiving Offers time to get up to 60% off!
Data Analysis in Spreadsheets
What you will learn:
- Using predefined functions to solve complex problems without having to worry about specific calculations. Functions for numbers – ROUND(), SQRT(), , MIN(), MAX(), SUM(), AVERAGE(), MEDIAN(), RANK(). Functions for strings – LEFT(), RIGHT(), LEN(), SEARCH(), CONCATENATE(). And functions for dates – WEEKDAY(), DATEDIFF(), DATEVALUE() etc. And combining functions.
- Conditional Functions and Lookups – more advanced functions like IF(), OR(), COUNTIF(), SUMIF(), AVERAGEIF(), using FILTER(), and VLOOKUP(), HLOOKUP(), SUMPRODUCT().
altLearners 