I just couldn’t wait to share two of the best tips I learned at the Google Teacher Academy and both are used in Google Spreadsheets – Magic Fill and Google Lookup.

Note PC users use CTRL key for Magic Fill, Mac users the ALT key

Also available on Screencast.com

Further resources – Using Google Lookup, Magic Fill