Spreadsheets 102- Formulas & Functions
https://docs.google.com/a/apps.sparcc.org/forms/d/1F9NvUHO034ul0yUDpoE0bOzBh1DqNhdrfADzBpxHkOc/viewform

You think to yourself, "Wow, our district has Google Apps for Education! Great tools, collaboration and more. No problem, I am a Word Processing Wonder, an Email Expert and a Presentation Pro but what about that Spreadsheet Thingy?". Sound familiar? Then this webinar is for you. Learn basics of spreadsheet function and use. This webinar is applicable to the majority of spreadsheets programs including Microsoft Excel, Google Sheets, OpenOffice Calc, etc.

This the second of the series of webinars on Spreadsheets (the first of series is Spreadsheets 101 for Educators)

  1. Useful Functions for manipulating text:
    • CONCATENATE
    • SPLIT (a.k.a.- Parsing or Text to Columns)
    • LEFT
    • RIGHT
    • MID
    • LOWER
    • PROPER
  2. Cell References- 
    • Default
    • Absolute
    • Semi-absolute
    • From another worksheet
  3. Ranges
    • What are they?
    • Giving them a "friendly" name
  4. Using VLOOKUP to find information for one range or worksheet in another range or worksheet
Presenter: Anthony Luscre
Date: April 21, 2015- 3:30pm to 4:30pm EST



After the live webinar, a recorded version of the video will be posted below.


  Using Spreadsheets 102- Outline- link 
   Google- Using Google Sheets- link
   Free Spreadsheet Tips and Tutorials
   Edmodo Group- Spreadsheets Across the Curriculum - https://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.