where is the Analysis Group in Excel?

First, thanks Gord for the assistance.

Second, the name of the add-in is Analysis ToolPak. I believed it was from
Microsoft. And it is covered in Help. But the section in Help refers to other
items, such as a Data Analysis Group, that are not in Help. Annoying but not
your problem. I have sent a nasty gram to Microsoft about it.

Third, one of my problems with Excel 2007 is that I have not found an icon
for Tools. It may be there somewhere, but I have not found it as yet. Nor
have I found how to activate it in Help. Quite annoying, but maybe it
represents my incompetence, something my wife stresses frequently.

Fourth, and most mysterious, NOW there is a Data Analysis Tab under the Data
Tab. Perhaps, I needed to reboot before it appeared because it was not there
yesterday.

Again thanks for the help.

PS The add-in is pretty slick.

Jeff

The Analysis Toolpak is installed with Excel.

It is not a download.

Load it through Tools>Add-ins and checkmark it.

For a list of where 2007 menu commands are located see Ron de Bruin's site.

http://www.rondebruin.nl/0307commands.htm


Gord

On Sun, 8 Jul 2007 08:46:02 -0700, JeffM <JeffM.RemoveThis@discussions.microsoft.com>
wrote:

>First, thanks Gord for the assistance.
>
>Second, the name of the add-in is Analysis ToolPak. I believed it was from
>Microsoft. And it is covered in Help. But the section in Help refers to other
>items, such as a Data Analysis Group, that are not in Help. Annoying but not
>your problem. I have sent a nasty gram to Microsoft about it.
>
>Third, one of my problems with Excel 2007 is that I have not found an icon
>for Tools. It may be there somewhere, but I have not found it as yet. Nor
>have I found how to activate it in Help. Quite annoying, but maybe it
>represents my incompetence, something my wife stresses frequently.
>
>Fourth, and most mysterious, NOW there is a Data Analysis Tab under the Data
>Tab. Perhaps, I needed to reboot before it appeared because it was not there
>yesterday.
>
>Again thanks for the help.
>
>PS The add-in is pretty slick.

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

Good hunting<g>

I have not yet upgraded to 2007.

The steady advancement towards septugenarianism makes everything a steep curve.


Gord

On Sun, 8 Jul 2007 16:04:02 -0700, JeffM <JeffM DeleteThis @discussions.microsoft.com>
wrote:

>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

Hi Jeff

Alt T starts the Tools dialogue, so Alt T O brings up Options, the same
as clicking the round Office Button>Excel 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 >Addins>at bottom of page, Manage Excel Addins>Go>tick Analysis
Toolpak.
--
Regards

Roger Govier


"JeffM" <JeffM.TakeThisOut@discussions.microsoft.com> wrote in message
news:163F4FC4-17FA-42A0-A8BA-A9B5BC15A07E@microsoft.com...
> 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

Roger

Thanks

While I was messing around on Saturday trying to get things to work, I
managed to find that page and do that. That must have been what got it going,
but by that time I was so exasperated that I must have missed the fact that
my problem was solved. So when I booted on Sunday ....

Anyway, you and Gord have taught me stuff that pure messing around was not
too likely to elucidate

Jeff

"Roger Govier" wrote:

> Hi Jeff
>
> Alt T starts the Tools dialogue, so Alt T O brings up Options, the same
> as clicking the round Office Button>Excel 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 >Addins>at bottom of page, Manage Excel Addins>Go>tick Analysis
> Toolpak.
> --
> Regards
>
> Roger Govier
>
>
> "JeffM" <JeffM.RemoveThis@discussions.microsoft.com> wrote in message
> news:163F4FC4-17FA-42A0-A8BA-A9B5BC15A07E@microsoft.com...
> > 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
>
>
>