Download or read book Google Sheets - Advanced written by Edward McCrae and published by . This book was released on 2020 with total page pages. Available in PDF, EPUB and Kindle. Book excerpt: This course will teach students advanced concepts and formulas in Google Sheets. Students will learn to use logical statements, lookup functions, and date and text functions. Additionally, students will learn how to link spreadsheets and Sheets files, work with range names, learn the options for spreadsheet protection, create PivotTables, work with macros and scripts. Students will also learn about conditional formatting, inserting graphics, and creating Forms.