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.
In This Free Course, You Will Learn How To
View All Learning Outcomes View Less All Alison courses are free to enrol study and complete. To successfully complete this course and become an Alison Graduate, you need to achieve 80% or higher in each course assessment. Once you have completed this course, you have the option to acquire an official Diploma, which is a great way to share your achievement with the world.
Your Alison is:
- Ideal for sharing with potential employers
- Great for your CV, professional social media profiles and job applications.
- An indication of your commitment to continuously learn, upskill & achieve high results.
- An incentive for you to continue empowering yourself through lifelong learning.
Alison offers 3 types of Diplomas for completed Diploma courses:
- Digital : a downloadable in PDF format immediately available to you when you complete your purchase.
- : a physical version of your officially branded and security-marked , posted to you with FREE shipping.
- Framed : a physical version of your officially branded and security marked in a stylish frame, posted to you with FREE shipping.
All s are available to purchase through the Alison Shop. For more information on purchasing Alison , please visit our FAQs. If you decide not to purchase your Alison , you can still demonstrate your achievement by sharing your Learner Record or Learner Achievement Verification, both of which are accessible from your Account Settings. For more details on our pricing, please visit our Pricing Page
Knowledge & Skills You Will Learn
