how do I create what if analysis in excel 2000?

M

Mike Middleton

Tony -

In Excel 2007, the Data ribbon has a Data Tools section with a "What-If
Analysis" drop-down containing Scenario Manager, Goal Seek, and Data Table.

In Excel 2000 SP3, the Tools menu has the Scenario and Goal Seek items, and
the Data menu has the Table item.

Self-Promotion: My sensitivity analysis add-in, SensIt, available from
www.treeplan.com, is also useful for what if analysis.

- Mike
http://www.MikeMiddleton.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pre-loaded Excel 2007 missing "Analysis ToolPak" 2
Analysis ToolPak - why doesn't it work? 3
Analysis Toolpak Excel 2000 1
Data analysis 3
Analysis Toolpak 2
Excel and what if analysis 3
How do I create a cost analysis between two companies? 2
Analysis ToolPak 2

Top