Session 1 - Google Sheets Ninja Training

Session 1 - Google sheets Ninja training

This was a great workshops to find out a few tips and trick for sheet.  Can’t wait to use some of this

on some documents I already have in place especially assessment data document that we use for

our team.  The pivot tables might come in handy to with taking on the role of Maths Lead teacher

within our school for this next term, as well as analysing data from surveys conducted with parents

relating to my MIT inquiry.

Sir links-a-lot a good app to use

TIPS AND TRICKS

• Drag the top left box down 1 and it will lock that top line into place - so it will always be at the top - will be great on assessment data files.
• Double click on the edge of the rows will make it the size of cell the right size.
• Use control keys to jump up and down… quickly
• Control A - select all. - if you do it once it will select data filled in… and if you press it again it selects the entire sheet.
• SHIFT, CTRL T - reopens a tab that has just been shut down. - GREAT FOR SNEAKY CHILDREN!!!
• Under paint bucket you can hit the ‘alternating colour’ which will colour every other row and make it easier to read. - again great for assessment data sheets - will save me having to do this manually and when adding a cell (when we get a new child) having to re-do it.
• Pivot tables are great too!