Google Sheets Masterclass: Create and Analyse Spreadsheets

Google Sheets offers many advantages over other spreadsheet programs like Microsoft Excel: it’s free, accessible from anywhere, compatible with any device and allows for real-time collaboration and direct sharing of spreadsheets. This Google Sheets tutorial teaches you how to use this fantastic tool to boost your productivity and streamline your professional and personal life as spreadsheets are a powerful organisational tool you can use to manage and analyse data. We begin by exploring the Google Sheets environment, including its interface and main menu, and examining features like ‘Docs’, ‘Sheets’, ‘Slides’ and ‘Forms’. We then show you how to work with cells, sheets and spreadsheets as you become familiar with the various menus and tools available, including ‘File’, ‘Edit’, ‘Format’ and ‘Share’.

The course then goes through the Google Sheets menu and explains the purpose of each feature. We explain how to manage files with the ‘File’ menu, edit spreadsheets with the ‘Edit’ menu and change the view with ‘View’ menu. We then discuss how to use the ‘Insert’ menu to insert text, photos, objects, tables and graphs into spreadsheets. The course then demonstrates how to create a pivot table, apply slicers and use functions like ‘SUM’, ‘Average’ and ‘Count’ to perform various computations in a salary table. These tools allow you to do more than record information on spreadsheets as they facilitate powerful data analysis.

We also examine several Google Sheets templates and show you how to use them in practice. We explain how to work with a few pre-made templates, including ‘Google Calendar’, ‘To-Do list’, ‘Annual Budget’, ‘Monthly Budget’, ‘Google Finance’, ‘Investment’ and ‘Daily Schedule’. These templates can speed up your work and boost productivity but can also help you to organise your personal life. Finally, we cover Google Forms and its tools and capabilities to help you learn how to create a form, add questions, tweak them, view and analyse the responses and collaborate and share the form. The course also demonstrates how to develop different types of quiz. Sign up for this Google Sheets tutorial to learn how to use this popular and free data management tool and add a valuable skill to your toolbox.