Excel in Office 2008

T

Tom

Is the Excel version in Office 2008 for Home & Student the "full"
Excel? Or is it similar to MSWorks, that is not all formula's are
supported.

TIA
 
J

John

Tom said:
Is the Excel version in Office 2008 for Home & Student the "full"
Excel? Or is it similar to MSWorks, that is not all formula's are
supported.

TIA


It is now more like Works thanks to the removal of VBA and the Analysis
Toolpack.
 
J

JE McGimpsey

Tom said:
Is the Excel version in Office 2008 for Home & Student the "full"
Excel? Or is it similar to MSWorks, that is not all formula's are
supported.

The XL in H&S is identical to XL in the full version.

All functions (including those that used to be in the Analysis Toolpak
Add-in) are present.
 
J

JE McGimpsey

Or is it similar to MSWorks, that is not all formula's are
supported.

It is now more like Works thanks to the removal of VBA and the Analysis
Toolpack.[/QUOTE]

Not quite. All formulas/functions that used to be in the Analysis
Toolpak Add-in are now built-in functions in XL.

The only things missing that the ATP provided are wizards (and a very
poor Random Number Generator), which can be replicated using worksheet
functions. It's not as convenient, but no functional capability has been
lost, and in some cases, the built-in functions provide more accuracy
than the ATP did.

VBA on the other hand...
 
J

John

JE McGimpsey said:
The XL in H&S is identical to XL in the full version.

All functions (including those that used to be in the Analysis Toolpak
Add-in) are present.



Where are Anova? Where are Histogram? Where are the t functions. Only a
FEW have been moved over to regular functions in Excel. VERY FEW!!!
 
J

JE McGimpsey

John said:
Where are Anova? Where are Histogram? Where are the t functions. Only a
FEW have been moved over to regular functions in Excel. VERY FEW!!!

Those aren't functions (of which there are about three dozen in the ATP,
now built into XL08). You're referring to the ATP wizards, which, for
the most part, use built-in XL functions to calculate their results.

For methods to accomplish the same thing as the ATP wizards, see

http://www.coventry.ac.uk/ec/~nhunt/oatbran/
 

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

Top