ForumOther Handy Tips & Tricks
Hi [accessally_user_firstname], it is time now to learn some handy tips and tricks to apply to your Staff Booklet to make it more visually appealing, easy to navigate and more dynamic.
The four videos in this module explore some of the newer or more advanced features within Google Sheets to give you more control over how you present information in your Staff Booklet.
You will learn:
1 | How to colourise tabs. | |
2 | How to rotate text inside cells. | |
3 | How to change the style of cells based on what is entered into them. | |
4 | How to set up an internal navigation inside your Staff Booklet. | |
5 | What to learn next |
How to colourise tabs in your Google Sheet
This video (1 min 4 sec) shows you how to change the colour of the tabs in your Google Sheet, making it easier and quicker for people to find the information they need.
[accessally_missing_any_tag tag_id=’578′ comment=’Members – 30 day trial’]
How to rotate text inside cells
This video (2 min) will show you how to rotate text inside cells within your Google Sheet. This is a super handy and greatly requested feature!
[accessally_missing_any_tag tag_id=’578′ comment=’Members – 30 day trial’]
How to change the style of cells based on what is entered
This video (6 min 10 sec) is taken from the course ‘Google Sheets & Forms for the Office 1. It shows how to protect a range of cells in your Sheet. This is handy if you want to change the colour of cells in your Sheet based on what someone enters into a particular cell:
[accessally_missing_any_tag tag_id=’578′ comment=’Members – 30 day trial’]
Example use scenarios might include:
- Making a cell for mobile numbers change colour if a staff member hasn’t entered their number.
- Changing the background colour of a cell if the date (eg. for Teacher Registration) is due within (for example) 2 months time.
- Changing the colour of a column if the cost goes over a certain level, for example if you have a budget area that is exceeded.
[/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]
How to set up an internal navigation inside your Staff Booklet
[accessally_user_firstname], this final video (3 min 19 sec) will put the final touch into your Staff Booklet by giving you an internal navigation.
This trick uses a little-known feature that allows you to create a link from a cell to another part of your Google Sheet. This will greatly speed up your ability to navigate inside your Staff Booklet and staff will appreciate how much time it saves them navigating through your amazing Staff Booklet.
[accessally_missing_any_tag tag_id=’578′ comment=’Members – 30 day trial’]
Module Progress: