View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.newusers
Roger Govier Roger Govier is offline
external usenet poster
 
Posts: 2,886
Default where is the Analysis Group in Excel?

Hi Jeff

Alt T starts the Tools dialogue, so Alt T O brings up Options, the same
as clicking the round Office ButtonExcel options
Alt T M M will bring up Macros

But for some reason, Alt T D brings up Document management, rather than
Data Analysis, maybe this is because Data Analysis is now on the Data
tab as you have found.

In order for it to appear, you must have Analysis Toolpak ticked
Alt T O Addinsat bottom of page, Manage Excel AddinsGotick Analysis
Toolpak.
--
Regards

Roger Govier


"JeffM" wrote in message
...
Gord

Thanks again for the help. Analysis Toolpak seems to need to be
configured
or something in Excel 2007 before it is available. (Maybe because I
started
by downloading a trial version and then buying it.) Anyway, it is not
hard to
do.

I also checked out the page on the web site you recommended. Pretty
cool. It
basically tells you where to find commands in Excel 2007 that you may
have
used in earlier versions of Excel. Unfortunately, "Tools" no longer
seems to
exist as a Tab label in Excel 2007. I suspect this is going to take
some
getting used to.

I have Analysis Toolpak working fine now.

Jeff