Google Apps Quickstarts - Sheets

<<< Google Apps How-to guides
Wazza’s Quickstarts
	Google Sheets Quickstart Guide (pdf) An introductory ‘getting started’ guide for teachers who are new to the Spreadsheet component of Google Apps.
Other guides and videos
	Google Sheets for Teachers Step-by-step guide to getting started with Google Spreadsheets.
	Pivot Tables in Google Sheets A pivot table allows you to ‘pivot’ or rotate data, thus looking at it from different angles and seeing a variety of patterns which may not be immediately obvious.
	24 Free Docs Templates Some good idea-starters for fresh Document layouts and Spreadsheets. (Click on ‘Use Template’ to save a copy to your Drive)
	5 little-known Sheets Functions Some of these options might be handy – calculate days left for a project, validate email addresses, create email addresses, and translate foreign languages.
	3D Charts Extension Add this extension to create 3D versions of your charts for your next presentation.

	Record Macros in Sheets – skip mundane tasks

	Sort and filter data in columns….

	Separate first and last names in a column….

	Use Conditional Formatting to create a ‘heat map’….

	Use Conditional Formatting for alternate row/column colours…

	Create an Organisational Chart….

	Create Pivot Tables….

	Share live data from one Sheet’s tab to another spreadsheet (Import Range)….

	Create Protected Sheets and Cell Ranges….

	Add Data Labels to Charts….

	Using add-ons for Google Docs and Sheets….

	(Admin) Controlling Add-on installation across your Domain….

	Using the Flubaroo Add-on to grade assignments….

	Grade assignments with Goobric – (Using rubrics with Google sheets)….

	Quick Sum in Google Sheets….

	Import HTML and Filter Views in Google Sheets….