Tools like spreadsheets have found various applications in business and personal life as they are used to organise and present information effectively. You could easily automate routine tasks by mastering these applications, boosting productivity. Google Sheets is a handy spreadsheet application that you can access on any device worldwide. Since multiple users can view and edit sheets simultaneously, it is an excellent collaboration tool. This course aims to help you master the Google Sheets application for greater productivity and better collaboration.

Spreadsheets are useful in storing and manipulating data. Their applications include creating simple household budgets to performing complex arithmetic and visualisations from big data. Google Sheets has an additional benefit of being cloud-based, making it the go-to application for seamlessly collaborating with family or colleagues. This course will help you gain mastery of the web-based application, making you significantly more productive and a much better collaborator. You will first learn about the processes involved in creating and sharing sheets. Then explore how to navigate the application and share your documents using the various available options. Compare Google Sheets to other applications and their different formatting and editing options. Learn to protect your documents, create named ranges, charts, pivot tables and so on.

Next, you will discover functions and learn how to simplify the process of cleaning and manipulating data on your sheets using only formulas. Here, you will learn mathematical, text, date, filter, ‘lookup’ and ‘info’ functions. Finally, you will apply your Google Sheets knowledge to create a spreadsheet for automatically computing and tracking mortgage payments. The knowledge from this course applies to personal life or business ventures of any scale. Enrol now and master one of the most popular productivity tools in only three hours!