Understanding Spreadsheets

0
Certificate

Paid

Language

Level

Advanced

Access

Free

Last updated on June 20, 2025 2:26 pm

This free online course will show you how to create a spreadsheet and familiarise yourself with the Google Sheets workspace.

Add your review

In this free online course, you are going to learn how to create and use spreadsheets. Spreadsheets are essential in organizing in categorizing data into a logical format. You can use them for accounting and calculation purposes, business data storage, generating reports, and more. In this free online course, you will learn the basics of Google Sheets and how to use the various functions to analyze your data with ease.

What You Will Learn In This Free Course

  • Identify the prerequisite for creati…
  • Explain how to create a spreadsheet …
  • Recognize the Functions of Sum and C…
  • List and explain the features of a G…
  • Identify the prerequisite for creating a Google spreadsheet
  • Explain how to create a spreadsheet from your Gmail account
  • Recognize the Functions of Sum and Count formula and state how to use the Sum function to get the total of a given range of data
  • List and explain the features of a Google spreadsheet
  • Discuss how to protect cells and sheets from being manipulated
  • Describe how to share a spreadsheet with others in both private and public mode
  • Identify and explain some of the valuable functions in a spreadsheet
  • List the steps involved in filtering and sorting data
  • Getting Started with Basic Functions

    In this module, you will learn how to create a spreadsheet from your Gmail account, the basics of Google spreadsheet, and how it works. Then you will learn the basic functions in a spreadsheet such as SUMIFS, COUNT, etc., and how to use these functions to achieve results. You will also learn how to use functions to manage data and information.

    Advanced Functions and Extra Tips

    In this module, you are going to get acquainted with the advanced functions in a spreadsheet, such as IMPORTRANGE, how to merge multiple tabs into one, sharing sheets with others, freezing rows and columns, shortcuts, and how to protect your data from being manipulated by an external source.

    Course assessment

    User Reviews

    0.0 out of 5
    0
    0
    0
    0
    0
    Write a review

    There are no reviews yet.

    Be the first to review “Understanding Spreadsheets”

    ×

      Your Email (required)

      Report this page
      Understanding Spreadsheets
      Understanding Spreadsheets
      LiveTalent.org
      Logo
      LiveTalent.org
      Privacy Overview

      This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.