Inserting & Managing data in Google Sheets 2020
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 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
-
3m 21sA 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 new worksheet, how to move and rename existing sheets, and how to hide and unhide one. FREE ACCESS
-
3m 31sTo 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
-
3. Inserting data into your cells in Google Sheets 20202m 25sA 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 inserted, and how to quickly replace entries. FREE ACCESS
-
4. Creating automatic data lists in Google Sheets 20204m 10sIn 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
-
5. Deleting data in Google Sheets 20203m 32sJust 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 will also learn how to differentiate between clearing a column's contents and deleting it entirely, two manipulations which have different effects on your spreadsheet. FREE ACCESS
-
6. Moving data in Google Sheets 20202m 28sIf 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 how to 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
-
7. Pasting values & formats in Google Sheets 20203m 30sWhen 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 example, you can choose to paste the copied cell's values or format. FREE ACCESS
-
8. Pasting formulas & transposing data in Google Sheets 20202m 18sGoogle 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 to do this by copying the data in the existing range and then using the "special paste" option. FREE ACCESS
-
9. Moving data from one sheet to another in Google Sheets 20203m 6sYou 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
-
10. Using Smart tools in Google Sheets in Google Sheets 20205m 51sThe 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 on your data, and insert pre-formatted data representations in a matter of seconds. FREE ACCESS
-
11. Using the spell-check in Google Sheets 20203m 1sThe 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.
