Inserting & managing data in Google Sheets 2022

Google Sheets    |    Beginner
  • 12 videos | 42m 51s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Rating 4.6 of 72 users Rating 4.6 of 72 users (72)
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.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in the inserting & managing data in sheets 2022 course
    Create and organize worksheets
    Select a 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

  • 55s
    This video outlines the key content covered in Inserting & managing data in Sheets 2022 course including organizing your worksheets, deleting data, and using the Explore tool. FREE ACCESS
  • 3m 38s
    A single spreadsheet document can contain multiple worksheets. Therefore, you can use your formulas and data across different spreadsheets without having to retype all of your entries. You can create a new worksheet, move and rename existing sheets, and hide and unhide worksheets. FREE ACCESS
  • Locked
    3.  Selecting a cell
    3m 30s
    To insert data into your spreadsheet, you will need to select a cell. With Sheets, there are different ways that you can choose your cell and begin inserting data. You can also select ranges of cells and data as well as an entire sheet. FREE ACCESS
  • Locked
    4.  Inserting data into your cells
    3m 24s
    A spreadsheet is made up of a number of cells where data can be inserted. You can insert data using your mouse and keyboard. You are also able to edit data that you have already inserted as well as quickly replace entries. FREE ACCESS
  • Locked
    5.  Creating automatic data lists
    4m 1s
    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 by inserting the first two days and using the fill-down function. It can also be used to create numerical series of varying intervals. FREE ACCESS
  • Locked
    6.  Deleting data
    4m 7s
    Now that you are able to insert data, it is just as important to know how to delete entries from your spreadsheet. You can remove the contents of a single cell, and of an entire column or row. It is also possible to differentiate between clearing a column's contents and deleting it entirely. These are two manipulations which have different effects on your spreadsheet. FREE ACCESS
  • Locked
    7.  Moving data
    3m 49s
    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. In Sheets, you can move data from one cell to another, between different sheets within the same spreadsheet, or even from one spreadsheet file to an entirely different one in Google Sheets. FREE ACCESS
  • Locked
    8.  Pasting values & formats
    3m 30s
    When you copy and paste values in Google Sheets, you'll be presented with a variety of options if you choose the "paste special" feature. This feature allows you to select the most appropriate way to display data. For example, you can choose to paste the copied cell's values or format. FREE ACCESS
  • Locked
    9.  Pasting formulas & transposing data
    2m 54s
    Google Sheets has a variety of paste options that allows you to re-use formulas, data validation or conditional formatting. In addition, you can transpose a data range. Google Sheets gives you an easy way to do this by copying the data in the existing range and then using the Paste special option. FREE ACCESS
  • Locked
    10.  Moving data from one sheet to another
    4m 4s
    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
    11.  Using the Explore tool
    5m 7s
    The Explore tool in Google Sheets can be used to interpret the data in your spreadsheet and quickly insert tables, pivot tables, and graphics. You can also perform quick calculations and analyze your data, as well as insert pre-formatted data representations in a matter of seconds. FREE ACCESS
  • Locked
    12.  Using the spell-check
    3m 51s
    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 identified, you can choose to replace it from a list of suggestions, or ignore it entirely. 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.

YOU MIGHT ALSO LIKE

Rating 4.5 of 27 users Rating 4.5 of 27 users (27)
Rating 3.9 of 21 users Rating 3.9 of 21 users (21)
Rating 4.7 of 11 users Rating 4.7 of 11 users (11)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.5 of 107 users Rating 4.5 of 107 users (107)
Rating 4.5 of 51 users Rating 4.5 of 51 users (51)
Rating 4.6 of 86 users Rating 4.6 of 86 users (86)