Inserting & Managing data
Google Sheets 2020
| Beginner
- 11 Videos | 37m 12s
- Includes Assessment
- Earns a Badge
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 worksheetsselect cell, cell ranges and data rangesinsert, edit and replace datacreate an automatic data listdelete data from a spreadsheetcopy and cut data within a spreadsheet
-
use special options to paste values and formatspaste formulas and transpose datamove data from one sheet to anotherinsert and analyze data with the Explore toolproofread your data and manage your personal dictionary
IN THIS COURSE
-
1.Organizing your worksheets3m 21sUP NEXT
-
2.Selecting a cell3m 31s
-
3.Inserting data into your cells2m 25s
-
4.Creating automatic data lists4m 10s
-
5.Deleting data3m 32s
-
6.Moving data2m 28s
-
7.Pasting values & formats3m 30s
-
8.Pasting formulas & transposing data2m 18s
-
9.Moving data from one sheet to another3m 6s
-
10.Using Smart tools in Google Sheets5m 51s
-
11.Using the spell-check3m 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.