Inserting & Managing data

Google Sheets 2020
  • 11 Videos | 40m 22s
  • 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
  • Locked
    4. 
    Creating automatic data lists
    4m 10s
  • Locked
    5. 
    Deleting data
    3m 32s
  • Locked
    6. 
    Moving data
    2m 28s
  • Locked
    7. 
    Pasting values & formats
    3m 30s
  • Locked
    8. 
    Pasting formulas & transposing data
    2m 18s
  • Locked
    9. 
    Moving data from one sheet to another
    3m 6s
  • Locked
    10. 
    Using the Explore tool
    3m 31s
  • Locked
    11. 
    Using the spell-check
    3m 1s

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

Likes 1 Likes 1  
Likes 1 Likes 1  
Likes 0 Likes 0