Inserting & Managing data

Google Sheets 2020    |    Beginner
  • 11 Videos | 37m 12s
  • Includes Assessment
  • Earns a Badge
Likes 35 Likes 35
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
    3m 21s
    UP NEXT
  • Playable
    2. 
    Selecting a cell
    3m 31s
  • Locked
    3. 
    Inserting data into your cells
    2m 25s
    FREE ACCESS
  • Locked
    4. 
    Creating automatic data lists
    4m 10s
    FREE ACCESS
  • Locked
    5. 
    Deleting data
    3m 32s
    FREE ACCESS
  • Locked
    6. 
    Moving data
    2m 28s
    FREE ACCESS
  • Locked
    7. 
    Pasting values & formats
    3m 30s
    FREE ACCESS
  • Locked
    8. 
    Pasting formulas & transposing data
    2m 18s
    FREE ACCESS
  • Locked
    9. 
    Moving data from one sheet to another
    3m 6s
    FREE ACCESS
  • Locked
    10. 
    Using Smart tools in Google Sheets
    5m 51s
    FREE ACCESS
  • Locked
    11. 
    Using the spell-check
    3m 1s
    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 of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

COURSE Enhancing documents in Google Sheets 2022
COURSE Getting started in Google Sheets 2022
COURSE Adding & arranging data in Excel 365
Likes 13 Likes 13  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Connecting & Setting Up
Likes 69 Likes 69  
COURSE Editing Documents
Likes 50 Likes 50  
COURSE Finding, Sorting & Filtering Data
Likes 8 Likes 8