Google Sheets is product made by Google that helps us process, create, and retain information by storing our inputs in accurate, easy-to-use data sets. Spreadsheets have been around historically, and help us sort and label in a way that makes sense, so we can reference it and perform calculations later. However, with Google's product, we can now store our information on a "cloud" that lets us access it anywhere and anytime, as long as there is access to the internet. It can be used to handle task lists, create project plans, analyze data with charts and filters, calculate formulas, keep track of inventories, link to our calendars, and much more.
The first set is learning how to create a spreadsheet and upload your data onto it. Sheets uses rows and columns to orient the system, and referencing each cell is important in manipulating the data. Your data can be used to not only log numbers, but turn into graphs and charts, import onto important calendar dates, and automatically chart survey responses. Google Sheets is a powerful data tool.
Many formulas can be inputted into the data cells of the spreadsheets in order to calculate our data. A few examples are listed:
SUM = adds the sum of any given data set (numbers)
DATEVALUE = Converts a provided date string in a known format to a date value
NOW = Returns the current date and time as a date value.