Google sheets: How to make a water audit spreadsheet
This is a longer video for beginners to google sheets and/or water audits. It takes data from a problem in the book To Catch the Rain and turns it into a spreadsheet.
It is a little slow at parts. My bad. :)
Skills:
⦿ Opening a new workbook
⦿ Naming a workbook
⦿ Naming a sheet
⦿ Pasting in an image
⦿ Formatting (background colors, font colors, borders, merging, horizontal justifying, vertical justifying, italics, bold, wordwrap)
⦿ Copy and paste
⦿ Color codes
⦿ Conversions
⦿ Dragging
⦿ Fixed reference using $ (or F4)
⦿ Sum