The following article provides detailed instruction on how to connect to the EIS cubes.
Please note that these instructions are for Excel for Windows as Excel for Mac is currently not supported.
Office 365
1. Open Excel > Data tab > Get Data > From Database > From Analysis Services
...