Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Analysis Tab
I don't have the Analysis group in the Data tab. How do I get that?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Analysis Tab
It within the tools menu ToolsData Analysis
If this post helps click Yes --------------- Jacob Skaria "Tom" wrote: I don't have the Analysis group in the Data tab. How do I get that? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Analysis Tab
Missed to mention that this is part of Analysis toolPAK. On the Tools menu,
click Add-Ins. In the Add-Ins available box, select the check box next to Analysis Toolpak, and then click OK. Now check out the tools Tab the last command button would be 'Data Analaysis' If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: It within the tools menu ToolsData Analysis If this post helps click Yes --------------- Jacob Skaria "Tom" wrote: I don't have the Analysis group in the Data tab. How do I get that? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Analysis Tab
Thanks Jacob but I'm in Excel 2007. I don't have a tools tab.
"Jacob Skaria" wrote: Missed to mention that this is part of Analysis toolPAK. On the Tools menu, click Add-Ins. In the Add-Ins available box, select the check box next to Analysis Toolpak, and then click OK. Now check out the tools Tab the last command button would be 'Data Analaysis' If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: It within the tools menu ToolsData Analysis If this post helps click Yes --------------- Jacob Skaria "Tom" wrote: I don't have the Analysis group in the Data tab. How do I get that? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Analysis Tab
Please take a loo at the below link
http://office.microsoft.com/en-us/ex...215691033.aspx If this post helps click Yes --------------- Jacob Skaria "Tom" wrote: Thanks Jacob but I'm in Excel 2007. I don't have a tools tab. "Jacob Skaria" wrote: Missed to mention that this is part of Analysis toolPAK. On the Tools menu, click Add-Ins. In the Add-Ins available box, select the check box next to Analysis Toolpak, and then click OK. Now check out the tools Tab the last command button would be 'Data Analaysis' If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: It within the tools menu ToolsData Analysis If this post helps click Yes --------------- Jacob Skaria "Tom" wrote: I don't have the Analysis group in the Data tab. How do I get that? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Analysis Tab
I tried that before coming here and it didn't change anything. I don't have
the Analysis tab to begin with. "Jacob Skaria" wrote: Please take a loo at the below link http://office.microsoft.com/en-us/ex...215691033.aspx If this post helps click Yes --------------- Jacob Skaria "Tom" wrote: Thanks Jacob but I'm in Excel 2007. I don't have a tools tab. "Jacob Skaria" wrote: Missed to mention that this is part of Analysis toolPAK. On the Tools menu, click Add-Ins. In the Add-Ins available box, select the check box next to Analysis Toolpak, and then click OK. Now check out the tools Tab the last command button would be 'Data Analaysis' If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: It within the tools menu ToolsData Analysis If this post helps click Yes --------------- Jacob Skaria "Tom" wrote: I don't have the Analysis group in the Data tab. How do I get that? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Analysis Tab
--From excel OptionsAddIns bottom for 'Manage' make sure the selection is
'Excel Add-Ins' and click 'Go'. --Now from the list select Anallysis ToolPak. If Analysis ToolPak is not listed in the Add-Ins available box, click Browse to locate it (analys32.dll) --You will be prompted to installed on your computer, click Yes to install it. If this post helps click Yes --------------- Jacob Skaria "Tom" wrote: I tried that before coming here and it didn't change anything. I don't have the Analysis tab to begin with. "Jacob Skaria" wrote: Please take a loo at the below link http://office.microsoft.com/en-us/ex...215691033.aspx If this post helps click Yes --------------- Jacob Skaria "Tom" wrote: Thanks Jacob but I'm in Excel 2007. I don't have a tools tab. "Jacob Skaria" wrote: Missed to mention that this is part of Analysis toolPAK. On the Tools menu, click Add-Ins. In the Add-Ins available box, select the check box next to Analysis Toolpak, and then click OK. Now check out the tools Tab the last command button would be 'Data Analaysis' If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: It within the tools menu ToolsData Analysis If this post helps click Yes --------------- Jacob Skaria "Tom" wrote: I don't have the Analysis group in the Data tab. How do I get that? |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Analysis Tab
Thank you!
"Jacob Skaria" wrote: --From excel OptionsAddIns bottom for 'Manage' make sure the selection is 'Excel Add-Ins' and click 'Go'. --Now from the list select Anallysis ToolPak. If Analysis ToolPak is not listed in the Add-Ins available box, click Browse to locate it (analys32.dll) --You will be prompted to installed on your computer, click Yes to install it. If this post helps click Yes --------------- Jacob Skaria "Tom" wrote: I tried that before coming here and it didn't change anything. I don't have the Analysis tab to begin with. "Jacob Skaria" wrote: Please take a loo at the below link http://office.microsoft.com/en-us/ex...215691033.aspx If this post helps click Yes --------------- Jacob Skaria "Tom" wrote: Thanks Jacob but I'm in Excel 2007. I don't have a tools tab. "Jacob Skaria" wrote: Missed to mention that this is part of Analysis toolPAK. On the Tools menu, click Add-Ins. In the Add-Ins available box, select the check box next to Analysis Toolpak, and then click OK. Now check out the tools Tab the last command button would be 'Data Analaysis' If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: It within the tools menu ToolsData Analysis If this post helps click Yes --------------- Jacob Skaria "Tom" wrote: I don't have the Analysis group in the Data tab. How do I get that? |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Analysis Tab
Try the below and once you get it how to work combine it to a single formula
Col A Col B Col C Feet Inches In inches 2 3 =A2*12+B2 4 3 =A3*12+B3 =C2+C3 In cell C4 =c2+c3 =INT(C4/144) & " sq feet " & MOD(C4,144) & " inches" PS: Also take a look at CONVERT() Converts a number from one measurement system to another.. part of Analysis ToolPak add-in. If this post helps click Yes --------------- Jacob Skaria "Tom" wrote: I don't have the Analysis group in the Data tab. How do I get that? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 Analysis ToolPak Regression Analysis Help Requested | Excel Worksheet Functions | |||
Analysis Toolpak-Confidence Level and data analysis questions | Excel Worksheet Functions | |||
Data Analysis Plus | Charts and Charting in Excel | |||
Why " data analysis plus " override " data analysis " once instal. | Excel Worksheet Functions | |||
Analysis ToolPak installed but no Data Analysis option | Excel Discussion (Misc queries) |