Gooru Tip - Maximize the video player and adjust video quality for optimal viewing!
Named ranges, a recent update for Google Spreadsheets, allow you to use a range throughout different sheets, formulas etc. and then update that range from one location. It’s a very powerful feature that brings Google Spreadsheets closer to replacing Excel, in my opinion.
If you haven’t watched my video about Protected Ranges in Google Spreadsheets, definitely check that one out as well.