Here are five things about Excel that every data scientist should know. 1: Named ranges Named ranges are a quick way to create a makeshift database in Excel.