Create a Data Source Name in iODBC with the CData ODBC Driver for SQL Analysis Services and work with SQL Analysis Services data in Microsoft Excel on Mac OS X.
It’s main focus in on pivot tables, but the course also covers sorting, filtering, graphing, and more. If you’re looking to work Excel on mac, here’s a course that goes over exactly that. Once enabled the Data Analysis ToolPak will. The Add-Ins window will open, add a checkmark to the check box next to Analysis ToolPak, click OK.
At the bottom of the window select Excel Add-ins from the drop-down to the right of Manage:, click Go to proceed. Ultimate Pivot Table Mastery For Excel 2016 on Mac Also at.