Adding Data Analysis

Adding Data Analysis - 3. Select Excel Options [located on...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Adding Data Analysis in Excel Excel 2003 1. Click on Tools  2. The dropdown menu should include Add Ins. 3. Click on Add Ins 4. From the dialog box select Analysis ToolPak and Analysis ToolPak VBA 5. Click OK [it may say that it is not installed, do you want to install….answer yes] 6. Go back and click Tools 7. You should see “Data Analysis” listed in the drop down menu Excel 2007 1. Open Excel 2. Click the Window logo in the upper left corner of the screen
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 3. Select Excel Options [located on the bottom right of the dropdown box] 4. You will then see Manage ADD INS at the bottom. Click GO 5. Select Analysis ToolPak and Analysis ToolPak VBA 6. If it asks you if you want to install this, you do! 7. You should find Data Analysis under the Data Tab in the menu bar on the far right side...
View Full Document

Ask a homework question - tutors are online