Inserting & Managing data in Google Sheets 2020

Google Sheets 2020    |    Beginner
  • 11 videos | 37m 12s
  • Includes Assessment
  • Earns a Badge
Likes 112 Likes 112
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.

WHAT YOU WILL LEARN

  • create and organize worksheets
    select cell, cell ranges and data ranges
    insert, edit and replace data
    create an automatic data list
    delete data from a spreadsheet
    copy and cut data within a spreadsheet
  • use special options to paste values and formats
    paste formulas and transpose data
    move data from one sheet to another
    insert and analyze data with the Explore tool
    proofread your data and manage your personal dictionary

IN THIS COURSE

  • Playable
    1.  Organizing your worksheets in Google Sheets 2020
    3m 21s
    A single spreadsheet document can contain multiple worksheets. You can thus use your formulas and data across different spreadsheets without having to retype all your entries. This tutorial will show you how to create a… FREE ACCESS
  • Playable
    2.  Selecting a cell in Google Sheets 2020
    3m 31s
    To insert data into your spreadsheet, you will need to select a cell. In this tutorial, you will find out about the different ways in which you can choose your cell and begin inserting data. FREE ACCESS
  • Locked
    3.  Inserting data into your cells in Google Sheets 2020
    2m 25s
    A spreadsheet is made up of a number of cells into which data can be inserted. This tutorial will show you how to insert data using your mouse and keyboard. You will also find out how to edit data that you have already… FREE ACCESS
  • Locked
    4.  Creating automatic data lists in Google Sheets 2020
    4m 10s
    In order to save yourself valuable time, you can use the automatic list function in Google Sheets in order to create lists of data. This function can, for example, be used to create a list of the days of the week, simply… FREE ACCESS
  • Locked
    5.  Deleting data in Google Sheets 2020
    3m 32s
    Just as important as being able to insert data is knowing how to delete entries from your spreadsheet. In this tutorial, you will find out how to remove the contents of a single cell, and of an entire column or row. You… FREE ACCESS
  • Locked
    6.  Moving data in Google Sheets 2020
    2m 28s
    If you want to be able to use the data that you have inserted into your spreadsheet in different tables and other sheets, then you are going to need to know how to move this information around. This tutorial will show you… FREE ACCESS
  • Locked
    7.  Pasting values & formats in Google Sheets 2020
    3m 30s
    When you copy and paste values in Google Sheets, you'll be presented with a variety of options if you choose "paste special". This feature allows you to select the most appropriate way to display data. For… FREE ACCESS
  • Locked
    8.  Pasting formulas & transposing data in Google Sheets 2020
    2m 18s
    Google Sheets has a variety of paste options that allows to re-use formulas, data validation or conditional formatting. In this video you will also learn how to transpose a data range. Google Sheets gives you an easy way… FREE ACCESS
  • Locked
    9.  Moving data from one sheet to another in Google Sheets 2020
    3m 6s
    You can move data from one sheet to another and even from one document to another. Save yourself a bit of time by learning how to this with the use of Google Sheet's keyboard shortcuts. FREE ACCESS
  • Locked
    10.  Using Smart tools in Google Sheets in Google Sheets 2020
    5m 51s
    The Explore tool in Google Sheets can be used to interpret the data in your spreadsheet and quickly insert tables, pivot tables, and graphics. Find out how to use the Explore tool, perform quick calculations and analysis… FREE ACCESS
  • Locked
    11.  Using the spell-check in Google Sheets 2020
    3m 1s
    The Google Sheets spell-check allows you to check your document for spelling mistakes. This is very important if you are intending to publish your document or share it with work colleagues. Once a mistake has been… FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE