Download Excel Analysis Toolpak Add-In: Click here: Excel Analysis Toolpak Add-In. Installation: Unzip the folder and copy the file contents into this directory; C: Program Files Microsoft Office OFFICE11 Library Analysis. If you don’t have Analysis folder in the Office11 Library, create one. Just know that the folder should look like the one. The Analysis Toolpak is an Excel add-in program that is available when you install Microsoft Office or Excel (See later for instructions for installing Analysis Toolpak on a Mac). To use the Toolpak in Excel, however, you need to first need to load it: 1. On the Tools menu, click Add-Ins. In the Add-Ins window, check the Analysis Toolpak box.
- Install Analysis Toolpak Excel 2016
- Analysis Toolpak Download Excel 2016
- Data Analysis Toolpak For Mac Free Download
This FREE suite of Excel add-ins contains a collection of analytic tools I developed over the years for instructional purposes. These add-ins are now bundled under a single menu in Excel Add-Ins tab. This version of the suite works with Office 2010 or newer. If you have Office 2007 or older, you can still install the older, independent Add-Ins. In this new suite you will find the following tools, which work with data of reasonable sizes for instructional purposes:
WordMap
And here's a tutorial on my WordMap, a word cloud that does more than simply show words in different font sizes
You can see my other tutorials here.
How to Install Kamakura's Analytic Tools for Excel
CLICK HERE to download the zip archive.
Unzip the archive into its own folder on your PC (call it anything you want, but remember it so you can unistall later!). IMPORTANT: Only delete or rename this folder after running the Uninstall file.
Read the Readme.pdf document to learn more about the tools and how to proceed with the installation, or even better, watch the Installation Video on YouTube. Follow the directions closely; Excel is pretty finicky about Add-In installations.
Double-click Install Kamakura Analytic Tools to install the suite
Try the examples included in the installation package
Make sure to use Uninstall Kamakura Analytic Tools to uninstall the suite, so you won't leave unattended trash behind.
Please let me know ([email protected]) if you have any trouble installing or using my tools; I will only know there is a problem if I hear from users (the tools work fine on my machines...)
Troubleshooting
If you don't see Kamakura Analytic Tools under the AddIns menu (or don't even see Addins), your Excel must be blocking macros from external sources. Then, you need to follow a couple of extra steps.
First, close Excel and find out where you stored the Kamakura Analytic Tooks 2010.xlam file (make sure you get the correct one!).
If you are using 32-bit Excel, it is in the Addins subfolder where you unzipped the archive.
If you are using 64-bit Excel, it is in the Addins64 subfolder.