How to Use Excel to Calculate Coefficient of Variation

1. Enter the data to be analyzed in one column of an Excel spreadsheet.
2. Use the Excel AVERAGE() function to calculate the mean of the data. In a blank cell on the spreadsheet, type '=AVERAGE(' (without quotes) and highlight all of the cells containing the data. Press 'Enter' to see the mean of the data.
3. Use the Excel STDEV() function to calculate the standard deviation of the data. In a second empty cell, type '=STDEV(' (without quotes) and highlight the data. Press 'Enter' to view the standard deviation of the data.
4. Divide the standard deviation by the mean: in a third empty cell, type '=' (without quotes) and click on the cell containing the standard deviation. Type '/' (without quotes) and click on the cell containing the mean. Press 'Enter' to view the coefficient of variation.

Read more ►

How to Convert Multiple Columns in Excel to a Single List in Word

1. Open the Excel 2010 file that you want to work with. Right-click on the 'A' above the first column and choose 'Insert.' This creates a blank first column that you will use to construct your list.
2. Press 'Alt' and 'F11' to launch the Excel VBA console. Right-click on any worksheet in your current workbook -- these are listed on the left side of the console -- move your mouse over 'Insert' and choose 'Module.' Double-click on the module which appears in the list.
3. Copy the following code and paste it into the white space on the right side of the VBA console:Sub Combine()Range('B1').SelectDo While ActiveCell > ''Range(ActiveCell, ActiveCell.End(xlDown)).Copy Destination:=Range('A10000').End(xlUp).Offset(1, 0)ActiveCell.Offset(0, 1).SelectLoopEnd SubThis code creates a macro, called 'Combine,' which combines all adjacent columns, starting with column 'B,' into one long list in column 'A.' If you think the total number of cells will be larger than 10,000, increase the number '10000' in the code so that it will be larger than the number of all your cells combined. The macro runs until it encounters a blank cell in the top row of a column.
4. Click the 'Play' button in the middle of the bar at the top of the VBA console. This creates your list in column 'A.' Click the 'X' in the top-right corner of the VBA console to close it.
5. Select the 'A' above the first column to select the entire column. Press 'Ctrl' and 'C' to copy the information to your clipboard.
6. Open the Microsoft Word 2010 file where you want to paste the list. Click the document to place your cursor wherever you want to insert the list.
7. Click the bottom of the 'Paste' button to open up a pop-up window. Choose the icon labeled with a large 'A' to insert the information as text.
8. Click the last item in the inserted items and hold the mouse button down. Drag the mouse up to the first item and release the mouse button, selecting the entire range of items. Click the 'Home' tab at the top of the screen and find the 'Paragraph' section. Click the 'Bullets' or 'Numbering' buttons to turn the information into a list.

Read more ►

How to Change Pivot Table Source Data

Microsoft Excel 2007
1. Open the Microsoft Excel 2007 application on your computer. Click on the “Microsoft Office” button from the top-right corner of the application.
2. Click on the “Open” option and then locate the Excel 2007 file that contains the pivot table for which you want to change the data source. Click on the “Open” button.
3. Click on the “Options” tab from the top toolbar menu and then click on the “Change Data Source” button from the “Data” group.
4. Click on the radio button next to the “Select a table or range” field. Click on the button in the “Table/Range” field.
5. Select the new range for your data within the pivot table and then click the “OK” button in the Change Pivot Table Data Source dialog box.
Microsoft Excel 2003
6. Open the Microsoft Excel 2003 application on your computer. Click on the “File” option from the top toolbar menu.
7. Click on the “Open” option and then find the Excel 2003 file that contain the pivot table for which you want to change the data source. Select the file and then click on the “Open” button.
8. Right-click on any cell in the pivot table and then click on the “Wizard” option. The PivotTable and PivotChart Wizard will appear on the screen.
9. Click on the “Back” button. Select the radio button next to the “Existing worksheet” field and then click inside of the text box.
10. Select the new range for your pivot table within the spreadsheet and then click on the “Finish” button from the dialog box.

Read more ►

How to Find Delete Multiple Instances in Excel

1. Click the Windows 'Start' button and select 'All Programs.' Click 'Microsoft Office' followed by 'Microsoft Excel' to open the spreadsheet software.
2. Click the 'File' ribbon tab, then click 'Open.' Double-click the Excel spreadsheet file that contains the duplicate values.
3. Highlight all the cells you want to check for duplicates. Click the 'Data' ribbon tab at the top of the window. Click 'Delete Duplicates' to start the wizard.
4. Check the box for each column you want to check from the selection. If you want to check all columns, click 'Select All.'
5. Click 'OK' to run the duplicate checker. The window displays the number of duplicates found. Click 'OK' to delete the duplicate instances.

Read more ►

How to Unlock an Excel Workbook Without Knowing the Password

1. Download and install Excel Password Remover 2010 from Straxx.com (see Resources). This is an Excel add-in file that will place two new options, 'Unlock sheet' and 'Unlock Workbook,' under the 'Tools' menu. This is an effective, free program.
2. Try Passware Kit Basic 10.1 (see Resources). This software can recover passwords for Microsoft Word, Excel, and Powerpoint files, as well as passwords for email accounts, network connections and local Administrators.
3. Download Excel Password Recovery Master (see Resources). This software offers near instant recovery of password. Length and complexity of passwords do not affect the speed at which they are recovered. Excel Password Recovery Master also supports Multilingual passwords.

Read more ►

How to Convert MS Excel Files to PDF

1. Open the MS Excel file that contains your document.
2. Ensure that the 'Print Area' has been properly defined. Go to 'Page Layout,' click 'Print Area' and finally, select 'Set Print Area' from the main menu. You will see a dotted line that represents the selected print area.
3. Select 'File' then 'Print' from the main menu. The 'Print and Printer' selection menu appears.
4. Select 'Adobe PDF' from the Printer drop-down selection.
5. Click 'Print'. The 'Save PDF File As' dialog window appears.
6. Navigate to the directory where you wish to save your PDF files and click the 'Save' button. The Adobe PDF progress bar appears and the PDF file is now created.

Read more ►

How to Change Ribbons in Excel 2007

1. Open Excel 2007.
2. Click on one of the following tabs: 'Insert,' 'Page Layout,' 'Formulas,' 'Data,' 'Review' or 'View.' If you previously placed a check in the Excel Options box labeled 'Show Developer tab in the Ribbon,' the rightmost tab you will see is the 'Developer' tab.
3. Click on 'Home' to return to the 'Home' Ribbon.

Read more ►

How to Use Freeze Frames in Excel

1. Open an Excel spreadsheet with some data.
2. Choose which rows and/or columns to freeze. To freeze rows only, select the row immediately beneath the row or rows you want to remain visible. To freeze columns only, select the column immediately to the right of the column or columns you want to remain visible. To select both rows and columns, select the cell immediately below and to the right of the row and column you want to remain visible.
3. Click the 'Window' menu in Excel 2003. Click the 'View' tab in Excel 2007/2010.
4. Click 'Freeze Panes' in Excel 2003 to complete the process. Click the 'Freeze Panes' option with the down arrow and continue to the next step in Excel 2007/2010.
5. Select 'Freeze Panes' from the drop-down menu in Excel 2007/2010 to complete the process.

Read more ►

How to Dock Windows in Excel Visual Basic Editor

1. Open Excel and then open VBA. The shortcut to opening VBA is 'ALT F11.'
2. Select the 'Tools' menu then select 'Options.'
3. In the dialog box, click on the 'Docking' tab. Make sure all the boxes are check on this tab, then click 'OK.'
4. The toolbar windows can be docked simply by moving them towards a side of the window pane. The code windows can be docked by double clicking on the header or clicking on the 'Maximize' button in the upper right corner. The code windows are undocked by selecting the greyed 'Restore Window' button in the upper right corner. Code windows can be alternated between by using 'CTRL Tab.'

Read more ►

How to Set the Number of Decimal Places to Appear in a Microsoft Access Table Field

1. Open your table in Design view.
2. Create a Number or Currency field, or click in a Number or Currency field that already exists.
3. Click on the General tab in the Field Properties box at the bottom of the screen.
4. Click in Decimal Places. A small arrow appears on the right side of the text box.
5. Click on the arrow to produce a menu of choices.
6. Select the number of digits to appear to the right of the decimal place.
7. Save your table.

Read more ►

How to Set Up a Spread Sheet for Profit Loss in a Small Business

1. Open Microsoft Excel and locate the template gallery.To find the template gallery in Excel 2003, select 'File' and 'New.' Using the right task pane, locate the templates search box. Type 'profit loss statement.' You will see all of the available templates. Download the profit loss statement.To find the template gallery in Excel 2007, select the 'Office' button and select 'New.' Using your search box, type 'profit loss statement.' You will see a list of matching templates. Download the profit loss statement.
2. Customize the Excel template to your business needs. Since this statement is a comparison of your business performance during different time periods, decide how often you want to generate this report.Open the template and enter the company name, time frame and date of the report.Adjust the sale revenue and cost of sales section by adding products or services that your company sells. This may require you to add or delete rows.To add products and services, type over the generic products and services included in the template. If you need additional rows for more products and services, right click on an existing product row number and select “Insert.” To delete a products and services row, right click on the existing product row and select “Delete.”
3. Adjust your operating expenses section. Add or remove any expenses that do not apply to your business. Clarify the taxes section to reflect the taxes you are responsible for.To adjust add additional expenses, type over the generic expenses. If you need additional expense rows, right click on the row number and select “Insert.” To remove an expense row, right click on the row number and select “Delete.”
4. Save your changes in Excel 2003 by selecting “File” and “Save As.” Type in a name for your template and change your Save As Type to “Template.”Save your changes in Excel 2007 by selecting the “Office” button. Select “Save As” and then select “Other Formats.” Type in a name for your template and change the Save As Type to “Template.'

Read more ►

How to Solve Probability Equations With Excel

1. Click the 'Fx' button just under the ribbon.
2. Select the down arrow to the right of 'Or select a category.'
3. Select the type of probability equation you want to solve from the 'Select a function' list. There are dozens of functions to choose from, including NORMSINV, which returns the inverse of the standard normal cumulative distribution and PERMUT, which returns the number of permutations possible from a given number of objects.
4. Follow the directions in the pop-up window to input the data necessary to solve the probability equations. Some functions, like the COMBIN function, ask you to type the data directly into the window. Other statistical functions may require you to input the data into the spreadsheet.

Read more ►

How to Make a Data Table in WordPad

1. Click the “Start” button or press the “Windows” button. The Start menu appears.
2. Type “WordPad” in the Search text box. Search results appear.
3. Click “WordPad.” A blank WordPad document screen appears.
4. Click the “Home” tab on the Ribbon.
5. Click on the document screen where you wish to set the table.
6. Click the “Insert Object” button in the Insert group. The Insert Object dialog box opens.
7. Click the “Create New” radio button.
8. Select the “Microsoft Excel Worksheet” program in the Object Type text box.
9. Click “OK.” The Insert Object dialog window closes. A Microsoft Excel worksheet appears.
10. Type the values in the Excel worksheet. Another option includes inserting an Excel table in the Excel worksheet. Click the “Insert” tab on the Excel Ribbon. Click and drag the cursor on the Excel worksheet to select and highlight the rows and columns for the data table. Click the “Table” button in the Tables group. A table appears in the Excel worksheet. Type the values in the table on the Excel worksheet.
11. Click the “X” or “Close” button of the Excel screen. Close the Excel worksheet to copy the data values to the WordPad document.
12. Save this WordPad document.

Read more ►

How to Add Two Cells in Excel 2003

1. Open Excel. You should be able to locate the program by using your 'Start' button. When you cannot find it there, use your 'Search' or 'Find' function.
2. Determine which cells you would like to add. Click on the cell where you want your total to appear.
3. Enter an equal sign, followed by the word SUM, begin parenthesis, the column and row of your first cell, comma, then the column and row of your second cell and end parenthesis. For example =SUM(A2,B6).
4. Appearing in the cell will be the sum of the two cells. Your equation will appear in the formula bar.
5. Delete the answer if you do not want it to show by highlighting the cell and pressing the 'Delete' button on your keyboard.

Read more ►

How to Convert Labels to Avery 5160

1. Open Word 2010 and select the 'Mailing' tab. Click the 'Start Mail Merge' wizard. Click 'Labels.' The label dialog box appears. Select 'Avery' in the vendor list and locate the 5160 labels. Click 'OK.'
2. Click the 'Select Recipients' button. Select 'Use Existing List.' Browse the computer and locate the Excel workbook containing the label information. Select the workbook and click the 'Open' button. The table dialog box appears. Select the worksheet that contains the label data. Click 'OK.'
3. Click the 'Insert Mail Merge' button. A drop-down list appears. Select a field from the list. Click the 'Preview Results' button to preview the label changes. Click 'Update Labels' to apply the new changes to all of the labels.
4. Click 'Finish Merge' to finalize the mail merge process. Select 'Edit Individual Documents.' Click 'All.'

Read more ►