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 - Bookkeeping for Freelancers and Sole Proprietors
Google Sheets Masterclass: Create and Analyse Spreadsheets
Google Cloud Computing Foundation
Google SketchUp 2019 Essentials
Google Analytics for Bloggers
Google Sheets for Home and Business
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.
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!