Want to learn how to leverage spreadsheet formulas to simplify how you work with your data? This session will cover some hands-on activities to help you configure a spreadsheet solution to typical tasks that teachers face, such as building a grade book, managing student contact info, recording observations, generating a class schedule in your calendar, and managing communication. By combining spreadsheet formulas with Add-ons or Apps Scripts, you can leverage these amazingly powerful tools to automate a lot of the repetitive work we all find ourselves doing. Most of the tips and techniques covered will work in both the old sheets and new sheets. This is an advanced session, so knowledge of spreadsheet commands, add-ons, and scripts will be helpful.