Learn how to use open-source Google Sheets to organize, analyze and present data in this free online spreadsheet course.

Imagine creating a recipe booklet or a vacation plan using Google Sheets. This course helps you to do just that as we explore different features and options offered by this versatile Google tool. We explain how to start a sheet from scratch and work with rows and columns before picking a theme. We then go over some insider tips used to improve formatting and provide keyboard shortcuts that can speed up your work and boost productivity.

This Google Sheets tutorial answers many questions you might have, from ‘can you insert documents into Google Sheets?’ to ‘what can you import into Google Sheets?’. We then focus on inserts and take you through the process of inserting digital objects into your sheet. The course helps you to master data validation in Google Sheets by explaining functions like ‘sorting’ and ‘filtering’ before laying out the basics of using formulas or functions to analyze data. 

The step-by-step demonstration videos found in the ‘Resources’ section help you to understand the collaborative features of this powerful tool. Our exercises and instructor sheets reinforce key learning points as you learn to arrange, ‘chunk’ or break your data logically. Google Sheets has uses beyond the fields of education and business. For example, you can use it to create an organizational chart or develop a catalogue for a blog or site. The ability to analyze, vizualise and present data is a key professional skill for the Information Age so sign up for this Google Sheets tutorial to master this powerful spreadsheet platform and advance your career.