Supercharging Google Spreadsheets with Add-Ons & Tips for Users
 

You may have been doing spreadsheets for years. You may have used Google Sheets, Excel, OpenOffice Calc, etc. and found they mostly worked the same. That is true, but there are few neat features in Google Sheets that have made me a big fan. Of course there is the great ability to collaborate with others by using the big blue sharing button and that alone makes them extremely useful. But in this Webinar, I would like to demonstrate some of the other features that will supercharge your Google Sheets.

  1. Add-Ons are little user created tools that work within Google Sheets to give you many additional features
    • Session will explore a number of my favorites
  2. Although Google Sheets and Excel share many functions, Google Sheets has a few unique functions that can do amazing things. 
    • Many deal with HTML and website scrapping, linking, etc.
    • Others deal with Images, including one especially neat formula to create QR codes automatically from a list of website addresses.
Please note-- if you have had experience with Spreadsheets most of the concepts covered will be easy to grasp, but if you are a newcomer to Spreadsheets you may want to first watch my other Spreadsheet Webinars- 
    • Spreadsheets 101 - which covers basics starting from square one (no from actually cell one!) 
    • Spreadsheets 102 - which focuses on Functions & Formulas, Special Cell References and working with both numbers and text.
Presenter: Anthony Luscre
Date: September 15, 2015- 3:30pm to 4:30pm EST





Session Resources: 
  Using Spreadsheets 101- Outline- link 
Useful Spreadsheet Functions (Excel & Google Sheets)- link

   Google- Using Google Sheets- link
   Free Spreadsheet Tips and Tutorials
   Edmodo Group- Spreadsheets Across the Curriculumhttps://edmo.do/j/n2pw4b
   Spreadsheets Links- SPARCC Tech Integration Website
   Google Sheets- Tips & Tricks for Making the Switch- link
   Keyboard shortcuts for Google Sheets
   Cloud Computing -- Google Docs Way
   Mr. Excel- Youtube Channel
   C.Pearson Consulting LLC (Advanced SS Tips)- link
   Excel Unusual- A Blog for Applied Science, Engineering and Games in Excel  (Advanced SS Tips)
Sample Spreadsheets for Class- Open,make a copy then you can edit/work with each
Live Session Chat: If you have any questions or comments during the live session, type in the document linked below
 Chat Document - Google Document Link 

Session Evaluation: Please provide your feedback on this session.
 Evaluation - Google Form link

Get Certificate: Earn a certificate of attendance for one (1) contact hour by watching the training video and passing this quiz
 Session Quiz - Google Form Link



Back to full listing of recorded trainings.