Welcome to Module 2, manage data using Google Sheets. After a spreadsheet has been created, data can be added in multiple ways. In this module will explore adding and organizing data with Google Sheets. You'll learn how to add, paste and import data and you'll also learn how to sort and filter data in a spreadsheet, which is especially useful when working with large datasets. Spreadsheet data is contained in cells, cells are identified by their location or address in the spreadsheet by column and row. The cell in the upper left corner of the spreadsheet is A1 and the cell to it's right is B1. And below it, is A2, understanding cell addresses is essential for creating formulas and functions. The simplest way to add data to a spreadsheet, is to type numbers, or text into a cell. Another option for adding data to a Google Sheets spreadsheet, is by pasting it, from another source, like from another spreadsheet, or from within the existing sheet, or a Google Doc etc. If the data has been copied to the clipboard of your device, it can be pasted into the sheet. Select a cell or range to paste the data into. To paste, open the edit menu and select paste, this is a simple option that will paste the data in with its original format. To choose which formatting to include hover over paste special and choose one of the options. There are several paste special options to choose from, take a moment to explore them. The keyboard shortcuts Ctrl V on Windows and Command V on Mac OS will also work to paste when you're using the Chrome browser. Google Sheets supports importing data from other file formats like Microsoft Excel. The files can be stored either in Google Drive or on your device. To import data, open the file menu and choose Import. To find a file stored in Google Drive, you can browse the My drive, shared with me, shared drives and recent tabs. Select Upload to browse your device's storage for a file, then choose how to import the data. You can create a new spreadsheet, insert a new sheet, replace the current spreadsheet, replace the current sheet, append new rows to the current sheet, or replace data in a selected cell. Select Import to complete the process. When you're working with data sets, especially very large sets, it can be helpful to sort data to gain fast access to the necessary cells. You can store an entire sheet by a column or you can store a range of cells. To sort the entire sheet, right click the letter of a column to sort by and choose whether to sort in ascending or descending order. Alternatively, select a column, open the data menu, then choose sort sheet by column and either A to Z or Z to A. To sort a range, highlight the group of cells you want to sort. To open the data menu and select sort range, select add another sort column to choose another column to sort by next, the sorting is processed in order from first selection to last. If your spreadsheet contains header rows, you can freeze these rows so they are not included in the sort. Filtering data can also help with analyzing a subset of the data in your spreadsheet. Select a range of cells to filter, for example, select a column, then from the data menu select create a filter. A filter button will appear in the top right of the selected range, select the filter button to open the filter options menu. You can filter by condition which includes values and color, you can also search for data points by typing in the search box. To remove a filter, open the data menu and select turn off filter to remove it or select that turn off filter icon from the toolbar. Filters can also be saved as filter views which we'll look at next. When you're working with large data sets in a spreadsheet, the filter view allows you to see just the data that's important and relevant to you without changing the underlying data. To use a filter repeatedly, create a filter view. To create a filter view, open the data menu, hover over filter views and select create new filter view. Give your filter view a descriptive name then select the field next to the range to set the range of the filter, click on the X button to close the filter view. Your new filter is now saved and it will be added to the filter views menu for you and other collaborators to use later. Editors of the spreadsheet will be able to change the filter view. Viewers can create filter views but they won't be saved.
