Google Sheets is a free, web-based spreadsheet that is provided by the giant internet technology company Google LLC. It is a great tool for spreadsheet operations because it is not difficult to use, comes with hundreds of handy functions, and is easy to share with your collaborators or partners. An exciting feature of the tool is that it gives users the ability to organize information and distil insights from otherwise incongruous data. What is even more exciting is that the tool is available to be used at no cost, i.e., free of charge. In this free online Google Sheets course, you will start by learning how to open a Google account and verify your information so that you can gain access to the Google Sheets tool. Explore the options for creating a new document, and how great the autosave features of the application are, which saves you from unforeseen data losses. You will see how you can create new folders and use the drag-and-drop feature to arrange your files and also how you can navigate between sheets, and customize file options in the template gallery.
Next, the vital functions of the various menu buttons and icons will be explained. The systems for row and column selection, as well as the cross-sectional techniques for cell labelling, will be described. The topic on beginner formatting will examine the menu contents, text wrapping and formatting techniques, as well as the procedures for modifying the properties of cells, rows and columns. The functions of the format painter and alternating colour tools will also be analyzed. The following bit of content covers the procedures for working with numbers, and the primary operations of the five commonly used formulas (SUM, AVERAGE, COUNT, MAX, MIN) will be taught. Discover the methods for sorting, filtering, and ranking data, as well as the magical effects of the fill handle (also known as the magic blue dot in the bottom right corner). Basic data validation techniques will cover the procedures for validating lists from a range, lists of items, numbers, custom formulas, as well as the information to show for invalid data entries. In addition, some essential formatting and analysis tricks, and the systems for conditional formatting, including the “paste special” method will be demonstrated. The topic on creating multi-tab formulas will examine how to manipulate information via a critical evaluation study of a sample real estate investment data. Finally, important functions like the Count, CountA, CounfIF, Rounding, and SumIF functions will be identified and the use of the SPLIT, CONCATENATE, VLookup, and alternative concatenation functions, that enable you to analyse data with greater precision will be comprehensively covered. The procedures for outputting and visualizing your data via graphs, charts and pivot tables will be explained, and you will be taught how you can create a sample budget. How can the number of values or variables in a dataset be determined? What functions can be used to search and return the value of a specified cell? The solution to these questions will be provided in this course via a step-by-step demonstration of the procedures. This course will dig deep into the obscure nooks and crannies of Google spreadsheets to uncover some of its most useful and important features. The application has many advanced functions, options, and shortcuts, which will make you more productive.
Whether you are a newbie, or you already have a basic understanding of spreadsheets, but you want to dig deeper and learn more advanced features and functionalities of Google Sheets, this course is the one for you. Enrolling in this course includes covering beginner operations to super advanced functions of spreadsheets, so that you can become a data crunching master. Start Course Now
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
- Include it in 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 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 Dashboard. For more details on our pricing, please visit our Pricing Page