ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Analysis Toolpak Add-In? (https://www.excelbanter.com/excel-worksheet-functions/70344-analysis-toolpak-add.html)

Sheacera

Analysis Toolpak Add-In?
 
Is the add-in for Analysis Toolpak not included in the Student/Teacher edition?

Gary L Brown

Analysis Toolpak Add-In?
 
I looked at Microsoft's on-line help but didn't see any exceptions for the
Analysis ToolPak.

Per Microsoft on-line help..

Add-in programs included with Excel Help
The add-in (add-in: A supplemental program that adds custom commands or
custom features to Microsoft Office.) programs listed in the following table
are installed by default in one of the following places:

The Library folder or the Addins folder, or one of their subfolders, in the
Microsoft Office\Office folder.

If the add-in program you want is not in the list under Add-Ins available in
the Add-Ins dialog box, you might be able to install the add-in from the
Microsoft Office Web site.

The administrator for your company network can designate other locations for
add-in programs. See your administrator for more information.

Add-in Description
Analysis ToolPak - Adds financial, statistical, and engineering analysis
tools and functions.
Analysis ToolPak VBA - Allows developers to publish financial, statistical,
and engineering analysis tools and functions using Analysis ToolPak syntax.
Conditional Sum Wizard - Creates a formula that sums data in a range if the
data matches criteria you specify.
Euro Currency Tools - Formats values as euros, and provides the EUROCONVERT
worksheet function to convert currencies.
Internet Assistant VBA - Allows developers to publish Excel data to the Web
by using Internet Assistant syntax.
Lookup Wizard - Creates a formula to look up data in a range by using
another known value in the range.
Solver Add-In - Calculates solutions to what-if scenarios (scenario: A named
set of input values that you can substitute in a worksheet model.) based on
adjustable cells and constraint cells.

HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"Sheacera" wrote:

Is the add-in for Analysis Toolpak not included in the Student/Teacher edition?


Mike Middleton

Analysis Toolpak Add-In?
 
Sheacera -

Is the add-in for Analysis Toolpak not included in the Student/Teacher
edition? <


It is included.

Choose Tools | Add-Ins and see if it's listed. If so, check the box, and
it'll appear on the Tools menu. If not, use the Office/Excel CD to install
it. (It may not have been transferred from CD to hard drive during a default
installation.)

- Mike
www.mikemiddleton.com




All times are GMT +1. The time now is 01:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com