The importance of Google Sheets
Google Sheets is a powerful tool for collaboration, data analysis and visualization. Marketers, Finance professionals or teachers are not immune to using it to organize and analyse their data.
While getting started with it can be straightforward, learning how to master it can prove to be challenging. In this article we recap our favourite online resources that can help you level up your Google Sheets easily, quickly and for free!
Perfect for both beginners and experimented users, FreeCodeCamp offers a full Google Sheets course on Youtube. The course is 3 hours long and covers all the basics of Google Sheets, from filtering data up to building charts.
Ideal for: Beginners and intermediate users
2. Learnit Training
This YouTube channel provides video tutorials on how to use Google Sheets. It has a wide variety of tutorials ranging from beginners’ guides on using spreadsheets, to advanced tips and tricks that can help you streamline your work process.
Their Google Sheets tutorials are divided into beginner, intermediate, and advanced categories.
HustleSheets is a Youtube channel helping Marketers and Sales scale their Google Sheets abilities.
It's particularly adapted to marketing professionals, but can be useful for anyone with a spreadsheet to manage.
For example, check out this video that teaches you how to create dashboards in Sheets.
Ideal for: Intermediate and Advanced (particularly in Marketing and Sales)
Coursera is of course also a great place to get started. The platform offers free online courses in many subjects, including Google Sheets.
If you're new to Sheets and want to learn how to use it from scratch, this course by the Google Cloud Team will teach you everything from entering your first cell value all the way up through formulas, charts and pivot tables.
Ideal for: Beginners
5. Teacher's Tech
Teacher's Tech is a Youtube channel that offers tutorials particularly addressed to teachers.
They cover Google Sheets in many of their tutorials. These are adapted to both beginners and advanced users.
You'll find their Google Sheets playlist here.
Ideal for: Beginners, Intermediate and Advanced users.
There are many resources available for learning Google Sheets, so don’t be afraid to explore your options and try out different courses. It can be overwhelming at first, but once you get the hang of it you’ll wonder how you ever got by without knowing these tips and tricks!