So you have successfuly installed the Master Data Services Add-In for Microsoft Excel and now you want to connect to your Master Data Services on your Server.
Select the "Master Data" tab in Excel
Create a new connection
In the Add New Connection put in your Web URL from the Server.
If you get the following error:
The connection failed because the URL is not valid or the
Mast Data Manager web application version is not supported.
This is usually because you just need to remove the default.aspx from the Web URL
http://MSDServer:8081/Default.aspx (as seen in IE)
http://MSDServer:8081 (in MDS Excel Add-In)
Simple when you realise this!