Enabling the Excel Data Analysis Toolpack for Mac and Windows will allow you to manipulate the data in Excel.
- Open Excel.
- Click on the File menu.
- At the bottom of the menu that pops up, click on Options.
- In the Excel Options box that opens up, click the Add-Ins tab.
- At the bottom of the window, click the Go... button.
- Check the box next to Analysis Toolpak. Click OK.
Some people prefer the Free XL Miner Analysis Toolpak from Frontline which is an Excel Add In.
