Microsoft Power Query
Someone pointed Microsoft Power Query out to me. It is hailed as a way to pull external data into a system. To use it, simply go to the "Data" tab in Excel.
What PowerQuery seems to do is turn Excel into a relational database.


Reader Comments