How to add Microsoft Query to Excel Data Connections?

Recent versions of Office 365 no longer have Microsoft Query as an option in Data Connections.

You can enable it by going into the Excel options File > Options > Data and enable it from the Legacy menu.