1 / 7

Data Analysis in Excel 2007

Data Analysis in Excel 2007. A Visual Guide By Nick Evangelopoulos May 2007. Going to Excel Options. Then press Excel Options. In Excel 2007, start by clicking on the Office button. 1. 2. Managing Add-Ins. Select Add-Ins. 3. 4. Select to Manage Add-ins and press Go.

wendy-ferguson
Download Presentation

Data Analysis in Excel 2007

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Data Analysis in Excel 2007 A Visual Guide By Nick Evangelopoulos May 2007

  2. Going to Excel Options Then press Excel Options In Excel 2007, start by clicking on the Office button 1 2

  3. Managing Add-Ins Select Add-Ins 3 4 Select to Manage Add-ins and press Go

  4. Adding Data Analysis Toolpack Check Analysis Toolpack and Analysis Toolpack – VBA, then click OK. The first time around, some configuration may be necessary 5

  5. Data Analysis is now available! The Data Analysis menu is available under Data 6 7 Select the desired Data Analysis method

  6. Opening a Macro file To enable macros, press Options In Excel 2007, when you open a macro file, the security warning appears here 1 2

  7. Opening a Macro file Select “Enable this content,” and then click OK. 3

More Related