Creating your own templates

Hi [accessally_user_firstname],

We hope you found the previous videos useful.

This module will help you to set up your own templates within the tabs inside the Google Sheet. This will enable you to customise the Staff Booklet to your school/organisation.

You will learn:

How to create your own tab in the Google Sheet.
How to change the size of rows or columns.
How to apply borders to cells.
How to merge cells in the Google Sheet.
How to add the 'Crop Sheet' add-on to your Google Sheet and get rid of unnecessary rows/columns.

This video is a little longer at 5 minutes 28 seconds because it covers a number of useful skills:

[accessally_missing_any_tag tag_id=’578′ comment=’Members – 30 day trial’]

[/accessally_missing_any_tag] [accessally_has_any_tag tag_id=’578′ comment=’Members – 30 day trial’]This video is available to paid members – please upgrade here…[/accessally_has_any_tag]

Additional tips:[accessally_missing_any_tag tag_id=’578′ comment=’Members – 30 day trial’]

  1. If you have particular documents that exist in your school/organisation that you want inside your Staff Booklet, we suggest starting with the ones that are simple (if you are new to using a Google Sheet).
  2. Once the tabs are inside your Staff Booklet, then you can look at getting those responsible for that area (eg. duty roster, CRT roster, etc.) to put the content into it – or check you’ve got the right information in there!

[/accessally_missing_any_tag][accessally_has_any_tag tag_id=’578′ comment=’Members – 30 day trial’]

Additional tips and ideas are available to paid members – please upgrade here



My private notes...
Click here to enter your note (this is private to you)...

You might also like to explore the Google Sheets & Forms for the Office 1 course if you are interested in learning more about Google Sheets and Forms.


Module Progress:


Social Sharing Course

[accessally_user_firstname], If you’re enjoying this course, please share it with your friends!

Skip to toolbar