Categories
Disclaimer: Some of the links on this website are affiliate links, meaning we may earn a commission if you click through and make a purchase. This comes at no additional cost to you.
By clicking the button above, you acknowledge that you will be redirected to a third-party website and agree to their terms and conditions.
Log in to manage favorites.
Google Sheets for Home and Business
Google Cloud Computing Foundation
Google Apps for Personal and Business Use
Google SketchUp 2019 Essentials
Google Sheets - Bookkeeping for Freelancers and Sole Proprietors
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.
Disclaimer: Product information, including title, description, and images, is sourced/provided by our affiliate partner, Alison US CA.
Disclaimer: Some of the links on this website are affiliate links, meaning we may earn a commission if you click through and make a purchase. This comes at no additional cost to you.
By clicking the button above, you acknowledge that you will be redirected to a third-party website and agree to their terms and conditions.
Product information, including title, description, and images, is sourced/provided by our affiliate partner, Alison US CA.
Share this product with a friend:
Refer a friend and earn 0.05 CEC when they click the link, plus an additional 1.00 CEC if they register. Share this Product and boost your earnings together!
Log in to manage favorites.
Similar Products
Share this product with a friend:
Refer a friend and earn 0.05 CEC when they click the link, plus an additional 1.00 CEC if they register. Share this Product and boost your earnings together!