Inserting & managing data in Google Sheets 2022

IN THIS COURSE

• 1.  Overview: Inserting & managing data in Sheets 2022
  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
• 2.  Organizing your worksheets
  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
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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