Add me. before any field to query for or filter for the value for the user writing the query.
For example, this can be used to filter a data sheet down to "me" so that each person who views it only sees themselves.
Date of last title change.
You can use managers to get someone’s immediate manager, managers to get their grand-manager.
If you are trying to do top-down from CEO as they are doing, you can reverse the managers list, like managers.reversed will return CEO. By adding the next number you can use managers.reversed will return next level manager (i.e. the one that reports to the CEO).