The QUERY function in #GoogleSheets is pretty much the most powerful function in the spreadsheet world.
It operates on your data and has the functionality of many other functions, like sorting, aggregation, filtering, etc.
It's like a pivot table in function form.
(1/4)
@benlcollins@max__makhrov actually the cmd + shift combo is my most common combo, particularly when using cmd + shift + up/down/left/right to jump highlight to the beginning/end of a row/column