Google Sheets Presentation

Presentation is part of a Workshop Series offered by Jen Farr at the Wayland Free Library.

1. WELCOME Workshop sponsored by Wayland Free Library and presented by the library Technology Trainer, Jen Farr.  Call 585-728-5380 if you would like additional (free) technology training(s) by appointment. USING GOOGLE SHEETS

2. Goals for our Workshop Tonight … Introduction to the Google Drive Uploading documents and folders to the Google Drive Navigating Google Sheets Creating a new Google Spreadsheet Sharing, Publishing, Collaborating Revision History

3. Advantages of the Google Drive! Great for anytime, anyplace access Autosave documents Upload photos and documents Free Templates View revision history Share documents

4. Settings Upload Settings > Confirm Setting Before Each Upload Manage Apps > Connect More Apps Cloud Convert From Template Doc Hub Zip Extractor Pixlr Editor Lucid Chart Diagram

5. Let’s look at the Drive

6. Working with The Docs App Click the Red Create button Select the folder icon Call your folder WFL Click on the WFL folder Click on the Red Create Button Click on Create Spreadsheet

7. Tips for Working with the Sheets App ALWAYS remember to give your document a title REMEMBER you can use your mouse to hover over icons to see what they do EXPLORE the Add-ons (I like Add Rows and Columns and the Vertex Template Gallery)

8. Learn About the Sheet Interface This is an excellent introduction to the Google Spreadsheet interface that is available on YouTube : https:// www.youtube.com/watch?v=5B8MqrxmUOA

9. Modifying Columns, Rows, and Cells Watch an excellent YouTube video that introduces you to the concepts of modifying a spreadsheet: https:// www.youtube.com/watch?v=p9GJvhwcS0c

10. Creating Simple Formulas Watch an excellent YouTube video that introduces you to the concept of Creating Simple Formulas: https:// www.youtube.com/watch?v=A6MmdLR3VK0