STREET-SMART GOOGLE SHEETS

Herein is a collection of the functions, formats and linkages that the author used in solving work – related problems as a teacher. The title was aptly named as such owing to the author’s lack of formal training or education on the topic. Among the topics covered herein are Vlookup, If statements, conditional formatting, index, match and other essential functions, pre-filled forms, internal and external links, working with Google Forms, pivot tables and blasting of emails linked to a worksheet. These and more practical formulas and formats are included to enable one to create a fully automated file or database from scratch, with or without the aid of Google Forms.