Menu
75+ of the best add-ins, plugins and apps for Microsoft Excel, free or not 1. Power-user l Power-user is both an Excel and PowerPoint add-in. Tableau Desktop - $999 to $1,999 l Tableau is a data visualization add-in. F9 - On quotes only l F9 allows you to work on your accounting data.
I have been using a plug-in called MegaStat. It is a wonderful tool for statistical analysis, and I find it more powerful than the stat tools in the long missed DataAnalysis add-in. MegaStat is published my McGraw-Hill Higher Education. MegaStat did work on an early preview of Excel 2016. Sadly I cannot get it to work on Excel 15.11.2. Under TOOLS ADDINS, MegaStat appears and is checked. But, I do not have access to it.
Under 2011 and the preview, the add-in would create a drop-down menu called MegaStat. I checked the MHHE MegaStat website. There is no mention of Excel 2016 for the Mac. I was able to get MegaStat to work. Follow these steps: 1. Find the location where the MegaStat Add-in resides. Create a Short Cut of the Add-in 3.
Copy the Short Cut 4. Paste the Short Cut on your desktop 5. Right Click on the Short Cut on your Desktop and select 'Open With' 6. Select Excel 7. Excel will open, but with a warning about Macros. Select 'Enable Macros' 8. The Add-in tab should appear.
Compute away! You will have to start at #5 each time you want Excel to use the Add-in. If this doesn't work, let me know. There is another way as well.