All concerning Excel Online: - Ctrl+F3 to bring up the name manager (unless its already there somehow?) - the full functionality of Conditional formatting, f.e. not all formatting rules can be used

Both are requiring me to open files stored on Sharepoint via the desktop app frequently.