Loading

The Alison August SALE! 🎉 25% Off PDF Certs & Diplomas!📜 Ends in : : :

Claim Your Discount!

Google Sheets for Home and Business

Master the use of Google spreadsheets for statistical analysis and data visualizations in this free online course.

Publisher: Benjamin Portnoy
In this free online course, learn how to create, view, and edit Google spreadsheets. Study how to perform basic and advanced tasks with Google spreadsheets, including data formatting and modifications, arithmetic and stats operations, as well as the capabilities for data analysis, information customization, and data visualization. The tasks to be taught will range from beginner to advanced levels for a wider reach to ensure proficiency.
  • Duration

    3-4 Hours
  • Students

    2,598
  • Accreditation

    CPD

Share This Course And
Earn Money  

Become an Affiliate Member

Description

Modules

Outcome

Certification

View course modules

Description

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 columns 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 obscurest 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

Careers