Loading

AMAZING AUGUST SALE: 25% Off Certificates and Diplomas! Limited-time Offer - ends Friday, 6th August 2021

Claim My 25% OFF

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, info customization, and data visualization. The tasks to be taught will range from beginner to advanced levels for a wider reach and ensures proficiency. Enrol today.
Google Sheets for Home and Business
  • Duration

    3-4 Hours
  • Students

    494
  • Accreditation

    CPD

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 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 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. Discover the options for creating a new document, and the awesomeness of the autosave features of the application, which saves you from unforeseen data loss. You will see how you can create new folders and use the drag-and-drop feature of the application to arrange your files. Likewise, you will be shown 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 revealed. Then, 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 info 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. You will also become familiarized with the use of the SPLIT, CONCATENATE, VLookup, and alternative concatenation functions, that enable you to analyse data with greater precision. 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 a plethora of 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. The course will cover beginner operations to super advanced functions of spreadsheets, so that you can become a data crunching professional. So, why wait? Start this course today!

Start Course Now

Careers