Basic Instructions on Copying Data
- Run the desired report to view the data submitted
- Using your mouse, highlight the entire table that displays the data (starting in one of the corners of the table, click and drag your mouse over the entire table)
- Click on Edit in your browser menu bar and select Copy
- Open Microsoft Excel, and open a new workbook
- Click in the first cell (A1)
- Select Edit from the main navigation
- Select Paste
The data will now be available to be manipulated, re-arranged, saved and/or printed as an Excel file. Charts and graphs can also be built using Excel's Wizard function. Under Data in the main menu, there is an option for Pivot Table and Pivot Chart Report. This Wizard allows you to setup complex tables and charts that can display and analyze data.
Advanced Tools In Microsoft Excel
- Statistical Analysis Tools: Microsoft Excel provides a set of data analysis tools - called the Analysis ToolPak - that you can use for statistical analysis: descriptive statistics, regression, variance (anova), correlation, covariance, F-Test, t-Test, etc. You provide the data and parameters; the tool uses the appropriate statistical macro functions and then displays the results in an output table. Some tools generate charts in addition to output tables. To use these tools, you must be familiar with statistics and the analysis tools must have been installed on your computer. To see if the analysis tools are installed, open the Tools menu and look for Data Analysis on the menu. If the Data Analysis command is not on the Tools menu, you will need to install the Analysis ToolPak.
- Installing the Analysis ToolPak: If you are using your own computer for your analysis, you may install the Analysis ToolPak by clicking on the Tools menu and selecting Add-Ins. If the Analysis ToolPak is not listed in the Add-Ins dialog box, click Browse and locate the drive, folder name, and file name for the Analysis ToolPak add-in, Analys32.xll - this is usually located in the Microsoft Office\Office\Library\Analysis folder - or run the Setup program if it isn't installed (you will probably need your Microsoft Office CD-ROM for this).Select the Analysis ToolPak check box and click OK.
- Using the Analysis ToolPak: Arrange the data you want to analyze in columns or rows on your worksheet. This is your input range. On the Tools menu, click Data Analysis. In the Analysis Tools box, click the tool you want to use. Enter the input range and the output range, and then select the options you want.