Google Sheets (Online Courses)
Elevate your career trajectory with our premier online course, designed to sharpen your competitive edge. Explore our curated selection of top-tier digital programs to hone your skills and propel your professional journey forward. Experience transformative learning tailored to empower your career advancement in today's dynamic landscape.
Price on Request
Start Learning
This Course Includes
-
20 hours 10 minutesof self-paced video lessons -
29 Programscrafting your path to success -
Completion Certificateawarded on course completion
Analyzing Data with Tables & Charts in Google Sheets 2020
Price on Request
45 minutes
Analyze data efficiently using the built-in features of Google Sheets. In this course, you will discover how to analyze your data with pivot tables and charts. Learn how to work with pivot tables, including formatting, sorting, filtering, adding calculated fields, and copying and exporting pivot tables. Another alternative to visually display your data is to use the built-in chart features in Google Sheets. Learn how to create and insert charts in your document.
Perks of Course
Certificate: Yes
CPD Points: 43
Compliance Standards: AICC
Analyzing tables & customizing charts in Sheets 2022
Price on Request
45 minutes
Analyze data efficiently using the built-in features of Google Sheets. In this course, you will discover how to analyze your data with pivot tables and charts. Learn how to work with pivot tables, including formatting, sorting, filtering, adding calculated fields, and copying and exporting pivot tables. Another alternative to visually display your data is to use the built-in chart features in Google Sheets. You are able to create, insert, and edit charts in your document. Lastly, you will discover how to connect and manage a sheet with BigQuery.
Perks of Course
Certificate: Yes
CPD Points: 46
Compliance Standards: AICC
Collaborating on a document in Google Sheets 2022
Price on Request
45 minutes
Easily share spreadsheets with your colleagues using Google Sheets collaboration features. Discover how to share documents with others via email and select the most suitable format for sharing your spreadsheet. If you prefer to release your documents to a wider audience you can publish your spreadsheet via a link or by embedding code in a blog. To work with other users in real-time, discover how to set up sharing options for individuals or to create a link available for anyone in your organization. You will also learn how to communicate and interact with other editors, for example, by adding comments or assigning tasks.
Perks of Course
Certificate: Yes
CPD Points: 43
Compliance Standards: AICC
Creating & Managing documents in Google Sheets 2020
Price on Request
35 minutes
Explore the basics of creating, saving and managing spreadsheets in Google Sheets. Discover the multiple ways and places to save your spreadsheet, including on your computer and on Google Drive. Continue by learning how to save a workbook as an Excel, CSV or HTML file. See how to manage a document's version history, and recover unsaved documents. Finally, learn how to configure your spreadsheet settings before printing or saving it as a PDF file.
Perks of Course
Certificate: Yes
CPD Points: 37
Compliance Standards: AICC
Creating & managing sheets in Google Sheets 2022
Price on Request
45 minutes
Explore the basics of creating, saving and managing spreadsheets in Google Sheets. Discover the multiple ways and places to save your spreadsheet, including on your computer and on Google Drive. Continue by learning how to save a workbook as an Excel, CSV or HTML file. You will also learn how to manage a document's version history, and recover unsaved documents. Finally, learn how to configure your spreadsheet settings before printing or saving it as a PDF file.
Perks of Course
Certificate: Yes
CPD Points: 44
Compliance Standards: AICC
Enhancing documents in Google Sheets 2022
Price on Request
45 minutes
Improve the display of your data using the insertion tools in Google Sheets. Discover how to add more columns, rows, and cells to insert more data in a worksheet. You will also learn how to manage and customize rows and columns by changing their size and applying borders. Spreadsheets in Google Sheets do not have to contain only data. Explore various methods for inserting images, including how to create, insert, and edit drawings, as well as hyperlinks. All these tools can be useful for creating first-rate headers for your documents.
Perks of Course
Certificate: Yes
CPD Points: 46
Compliance Standards: AICC
Enhancing your documents in Google Sheets 2020
Price on Request
35 minutes
Improve the display of your data using the insertion tools in Google Sheets. Discover how to add more columns, rows, and cells to insert more data in a worksheet. You will also learn how to manage and customize rows and columns by changing their size and applying borders. Spreadsheets in Google Sheets do not have to contain only data. Explore various methods for inserting images, including how to create, insert, and edit drawings, as well as hyperlinks. All these tools can be useful for creating first-rate headers for your documents.
Perks of Course
Certificate: Yes
CPD Points: 37
Compliance Standards: AICC
Finding & filtering data in Google Sheets 2022
Price on Request
40 minutes
There are times you may only want to work with particular data in a spreadsheet. Discover how to use the Google Sheets tools to easily find and replace data. You will also learn how to sort your data and use filters to display only the data you need. Google Sheets includes other advanced options for sorting and filtering data with colors and conditions. In this course, you will discover other tools for filtering your data, such as filter views and slicers. Finally, learn how to group and ungroup your data to choose the information you want to display.
Perks of Course
Certificate: Yes
CPD Points: 42
Compliance Standards: AICC
Finding, Sorting & Filtering Data in Google Sheets 2020
Price on Request
35 minutes
There are times you may only want to work with particular data in a spreadsheet. Discover how to use the Google Sheets tools to easily find and replace data. You will also learn how to sort your data and use filters to display only the data you need. Google Sheets includes other advanced options for sorting and filtering data with colors and conditions. In this course, you will discover other tools for filtering your data, such as filter views and slicers. Finally, learn how to group and ungroup your data to choose the information you want to display.
Perks of Course
Certificate: Yes
CPD Points: 37
Compliance Standards: AICC
Formatting data in Google Sheets 2020
Price on Request
35 minutes
You can improve the appearance of your data by using the formatting tools in Google Sheets. Discover how to work with data types, apply color, align text, resize columns and rows, and use conditional formatting formulas.
Perks of Course
Certificate: Yes
CPD Points: 37
Compliance Standards: AICC
Formatting data in Google Sheets 2022
Price on Request
40 minutes
Google Sheets 2022 offers different formatting tools to improve the appearance of your data. First, learn how to change your cell's format and learn how to format and align data. Next, learn how to apply colors as well as use alternate colors and themes. In this course, you will also discover how to use basic and advanced conditional formatting as well as apply color to the first new entry in a list.
Perks of Course
Certificate: Yes
CPD Points: 40
Compliance Standards: AICC
Getting started in Google Sheets 2022
Price on Request
30 minutes
Google Sheets is a web-based spreadsheet program from Google. In this course, you will learn how to access the application. You can also explore the Google Sheets home page, which is where you can access all your documents. From this interface, learn how to open your spreadsheets for editing. You will also learn how to use the application by navigating a spreadsheet and exploring the interface. Google also allows customization of the interface and spreadsheet view. Lastly, you can add features to your interface, which are called add-ons, and you can manage them directly from the sheet.
Perks of Course
Certificate: Yes
CPD Points: 28
Compliance Standards: AICC
Inserting & Managing data in Google Sheets 2020
Price on Request
35 minutes
This course focuses on inserting and managing data in your worksheets. Google Sheets includes a variety of tools for inserting, editing, and customizing data. Learn how to insert data and how to create an automatic list of numbers, dates, or codes. You will also see how to select a cell or a cell range for copying and how to use the 'paste special' options to reuse formats or formulas. Finally, learn how to insert data with the Explore tool and how to improve your data with the Spelling tool.
Perks of Course
Certificate: Yes
CPD Points: 37
Compliance Standards: AICC
Inserting & managing data in Google Sheets 2022
Price on Request
40 minutes
This course focuses on inserting and managing data in your worksheets. Google Sheets includes a variety of tools for inserting, editing, and customizing data. Learn how to insert data and how to create an automatic list of numbers, dates, or codes. You will also discover how to select a cell or a cell range for copying and how to use the Paste special options to reuse formats or formulas. Finally, learn how to insert data with the Explore tool and how to improve your data with the Spelling tool.
Perks of Course
Certificate: Yes
CPD Points: 42
Compliance Standards: AICC
Managing & calculating data in Sheets 2022
Price on Request
45 minutes
Discover how to use Google Sheets for common tasks like calculating the interest on a loan and comparing loans. This course will also teach you how to build formulas to find and manage duplicate values in your spreadsheets. Google Sheets includes built-in formulas to extract and analyze data. Learn how to work with some of these formulas on both data and text values, and use the LOOKUP and VLOOKUP formulas. You will explore how to find data in a database, as well as perform calculations using your database. Lastly, you will be able to find a value in a double-entry table and perform a search across two tables.
Perks of Course
Certificate: Yes
CPD Points: 45
Compliance Standards: AICC
Navigating & Configuring in Google Sheets 2020
Price on Request
25 minutes
Google Sheets is a web-based spreadsheet program from Google. Discover how to access the application and explore the Google Sheets home page. From this interface, learn how to open your spreadsheets for editing. You will also see how to customize the interface and spreadsheet view, and work with add-ons.
Perks of Course
Certificate: Yes
CPD Points: 25
Compliance Standards: AICC
Performing calculations in Sheets 2022
Price on Request
40 minutes
Conditional formulas let you perform a calculation on a range of values by specifying the criteria that data must meet. Discover how to use the built-in conditional formulas and how to create your own conditional formulas in Google Sheets. In this course, you will also learn how to use conditional formulas to translate data or to keep your information up to date.
Perks of Course
Certificate: Yes
CPD Points: 41
Compliance Standards: AICC
Performing Conditional Calculations in Google Sheets 2020
Price on Request
40 minutes
Conditional formulas let you perform a calculation on a range of values by specifying the criteria that data must meet. Discover how to use the built-in conditional formulas and how to create your own conditional formulas in Google Sheets. In this course, you will also learn how to use conditional formulas to translate data or to keep your information up to date.
Perks of Course
Certificate: Yes
CPD Points: 39
Compliance Standards: AICC
Referencing & Managing Data in Google Sheets 2020
Price on Request
45 minutes
While working in Google Sheets, you will often use a cell value in a formula or another location. Discover how to use absolute, mixed, and relative cell references in formulas or to extract values from other cells. These cell references will also be useful to create a formula with data from multiple sheets. Lastly, learn how to define data ranges for creating different types of menus using the data validation tool.
Perks of Course
Certificate: Yes
CPD Points: 47
Compliance Standards: AICC
Using Basic Formulas in Google Sheets 2020
Price on Request
45 minutes
This course will focus on manipulating data and performing basic calculations using formulas in Google Sheets. First, discover how to manually select and use formulas in a cell, as well as to get access to the full list of functions available in Google Sheets. You will also see how to copy formulas to quickly fill out a table. Other functions will allow you to rank, count, and round values in a sheet. Google Sheets' functions are useful for manipulating text as well. For example, to replace specific characters or a text string. Finally, learn how to create formulas to generate random numbers and remove whitespace.
Perks of Course
Certificate: Yes
CPD Points: 45
Compliance Standards: AICC
Using basic formulas in Sheets 2022
Price on Request
45 minutes
This course will focus on manipulating data and performing calculations using basic formulas in Google Sheets. First, discover how to manually select and use formulas in a cell, as well as get access to the full list of functions available in Google Sheets. You will also learn how to perform simple calculations and copy formulas to quickly fill out a table. Other functions will allow you to rank, count, and round values in a sheet. Google Sheets' functions are useful for manipulating text as well. For example, to replace specific characters or a text string. Finally, learn how to create formulas to generate random numbers and remove whitespace.
Perks of Course
Certificate: Yes
CPD Points: 46
Compliance Standards: AICC
Using charts in Sheets 2022
Price on Request
40 minutes
Google Sheets offers a huge variety of different chart types and styles for presenting and analyzing your data in attractive and interesting ways. Discover how to insert, format, and manipulate Pie, Scatter, Bubble, Radar, Map, and Combo charts. You will also learn how to use the Sparkline function to track trends in a data series. Lastly, you can share your charts by downloading a copy or publishing via a link or embedded code.
Perks of Course
Certificate: Yes
CPD Points: 40
Compliance Standards: AICC
Using data in Sheets 2022
Price on Request
55 minutes
While working in Google Sheets, you will often use a cell value in a formula or another location. Discover how to use absolute, mixed, and relative cell references in formulas or to extract values from other cells. These cell references will also be useful to create a formula with data from multiple sheets. Lastly, learn how to define data ranges for creating different types of menus, such as drop-down menus, using the data validation tool.
Perks of Course
Certificate: Yes
CPD Points: 53
Compliance Standards: AICC
Using Different Types of Charts in Google Sheets 2020
Price on Request
1 hour 30 minutes
Google Sheets offers a huge variety of different chart types and styles for presenting and analyzing your data in attractive and interesting ways. Learn how to insert, format, and manipulate Pie, Radar, Scatter, Bubble, Map, and Combo charts. You will also see how to share your charts by downloading a copy or publishing via a link or embedded code.
Perks of Course
Certificate: Yes
CPD Points: 39
Compliance Standards: AICC
Using Formulas to Calculate & Manage Data in Google Sheets 2020
Price on Request
45 minutes
Discover how to use Google Sheets for common tasks like calculating the interest on a loan and comparing loans. This course will also teach you how to build formulas to find and manage duplicate values in your spreadsheets. Google Sheets includes built-in formulas to extract and analyze data. Learn how to work with some of these formulas on both data and text values, and use the LOOKUP and VLOOKUP formulas.
Perks of Course
Certificate: Yes
CPD Points: 45
Compliance Standards: AICC
Using formulas to get data in Sheets 2022
Price on Request
40 minutes
Google Sheets includes built-in formulas to extract and analyze data. First, you will get to know your data by identifying data entries with formulas. Then you will discover how to work with some of these formulas on both numeric and text values. For example, you will learn how to retrieve date information as well as display and retrieve information about your data entries. You are also able to find the largest and smallest values in a list, as well as separate your data. Alternatively, you can combine data and compare two lists by using the VLOOKUP function. You can also use the HLOOKUP function to insert data. Lastly, you can identify errors in formulas by using the IFERROR function.
Perks of Course
Certificate: Yes
CPD Points: 40
Compliance Standards: AICC
Using Formulas to Obtain Data in Google Sheets 2020
Price on Request
35 minutes
Google Sheets includes built-in formulas to extract and analyze data. Discover how to work with some of these formulas on both numeric and text values, and how to use LOOKUP and VLOOKUP.
Perks of Course
Certificate: Yes
CPD Points: 35
Compliance Standards: AICC
Using functions in Sheets 2022
Price on Request
30 minutes
Explore the many functions that are offered in Google Sheets 2022. In this course, learn how to create and save a named function. Next, discover how to work with the LAMBDA function as well as use LAMBDA helper functions. The LAMBDA helper functions help you perform more advanced array operations. These LAMBDA helper functions include MAP, REDUCE, BYROW, BYCOL, SCAN, and MAKEARRAY. Lastly, as alternatives to previous functions, you can now use XLOOKUP and XMATCH to for more powerful and flexible formulas.
Perks of Course
Certificate: Yes
CPD Points: 32
Compliance Standards: AICC
Working with others on a document in Google Sheets 2020
Price on Request
40 minutes
Easily share spreadsheets with your colleagues using Google Sheets collaboration features. Discover how to share documents with others via email and select the most suitable format for sharing your spreadsheet. If you prefer to release your documents to a wider audience you can publish your spreadsheet via a link or by embedding code in a blog. To work with other users in real-time, discover how to set up sharing options for individuals or to create a link available for anyone in your organization. You will also learn how to communicate and interact with other editors, for example, by adding comments or assigning tasks.
Perks of Course
Certificate: Yes
CPD Points: 42
Compliance Standards: AICC