Saturday, December 28, 2013

How to Set Excel 2003 as Your Default if You Have 2007 Installed

1. Close any open Excel windows.
2. Click 'Start' and then click 'Run' from Windows XP; click the 'Microsoft' button and then click 'Run' from Vista; or click the 'Microsoft' button, then type 'Run,' then click 'Run' from Windows 7.
3. Type 'excel.exe /unregserver' into the text box and then click 'OK.'
4. Type 'excel.exe /regserver' into the textbox and then click 'OK.'
Read more ►

How to Calculate the P

Calculate Correlation
1. Open the workbook that contains your data in Excel 2007.
2. Determine the cell addresses that contain the two ranges of data that you want to compare. For example, if your data is contained in the first 20 rows of columns 'A' and 'B,' then the two cell address ranges for your data are 'A1:A20' and 'B1:B20.'
3. Click a cell that you want to use to calculate the Pearson correlation coefficient 'r.'
4. Type '=PEARSON(A1:A20,B1:B20)' -- without the quotes -- in the cell. Substitute the addresses of your data ranges in place of these sample ranges.
5. Press 'Enter.' Excel calculates the Pearson correlation coefficient for your data range and displays it in the cell.
Calculate P-Value
6. Click a different cell that you want to use to calculate the p-value that is associated with your correlation.
7. Copy and paste the following formula into the cell:=TDIST((pearson_cell*sqrt(N-2)/sqrt(1-(pearson_cell*pearson_cell))), N, 2)The cell returns an error message; don't worry, you'll fix the formula to work with your data array in the next steps.
8. Click the formula bar to edit the formula that you just pasted. Type the address of the cell that contains your Pearson correlation formula in place of all three instances of 'pearson_cell' in the above example. For instance, if you calculated the Pearson correlation in cell 'A22,' then the formula looks like this:=TDIST((A22*sqrt(N-2)/sqrt(1-(A22*A22))), N, 2)
9. Type the number of observations that you have for each variable in place of each instance of 'N' in the formula. For instance, if you have 20 observations in each column, then the formula now looks like this:=TDIST((A22*sqrt(20-2)/sqrt(1-(A22*A22))), 20, 2)
10. Press 'Enter.' The cell calculates and displays the p-value that is associated with your correlation.
Read more ►

How to Send a Microsoft Excel 2007 Worksheet As an Email

Sending an Excel File Via E-mail
1. Power on your computer and open your e-mail server or log in to your online e-mail.
2. Click the button 'New' to create a new message. Enter the recipient's e-mail address in the 'To' field. Enter a subject line and any other text, if desired.
3. Click on the 'Attach' button or in some cases, the button that looks like a paper clip. A window appears with a button marked 'Browse.'
4. Click on the 'Browse' button and navigate to the folder where your Excel file is located. Once selected, the e-mail client will store it as part of the e-mail. Some e-mail clients require that you click an 'Attach' button after selecting the file.
5. Click on the 'Send' button to deliver the e-mail. Your recipient will receive the e-mail, and will be able to open or save the Excel file to his or her hard drive.
Read more ►

How to Insert a Row in Microsoft Excel 2003

How to Add a Single Row
1. Open an Excel Worksheet or create a new one.
Highlight the row header immediately below where the new row should appear.
Select 'Insert' on the menu bar.
4. Click 'Rows' from the drop down list. The new row is now found above your highlighted selection.
How to Add Multiple Rows
5. Open an Excel Worksheet or create a new one.
6. Highlight the number of row headers immediately below where the new rows should appear.
7. Select 'Insert' on the Menu Bar and click 'Rows' from the drop down list. The new rows will be inserted above your highlighted selection.
Read more ►

Friday, December 27, 2013

How to Use Correlation on Excel 2007

1. Open Microsoft Excel 2007. Click on the 'File' option, then select 'Open.'
2. Locate the Excel file that contains the different variables for which you want to calculate the correlation coefficient, then click 'Open.'
3. Select the data you want to compare by highlighting the data with your mouse. Click on the 'Data' tab, then click the 'Data Analysis' option from the 'Analysis' group.
4. Click the 'Correlation' option, and the Correlation dialog box will appear. Click on the button in the 'Input Range' field to make sure the correct fields are selected.
5. Select the 'Columns' or 'Rows' option from the 'Grouped By' field and then select the 'Labels in first row' option. Choose the output range from the 'Output options' fields, then click 'OK.'
Read more ►

How to Use Microsoft Excel to Draw Control Charts and Graphs

Excel 2007
1. Open a new file by clicking on the “Office” button and choosing “New.”
2. Type “control chart” into the ‘Search Microsoft Office Online for Templates’ box.
3. Click on the control chart that appears, then click the “Download” button. The file will download and automatically open. At this stage, you can tailor the control sheet to fit your needs, perhaps by changing the titles in the columns or by placing different totals in the boxes.
4. Graph the control chart. Highlight the text by left clicking at the top left corner of the data and then dragging the cursor to the bottom right. Choose “Insert->Chart” from the toolbar and choose your chart type. For example, click on “2D column graph.” Excel will insert your chart automatically.
Excel 2003
5. Go to the Microsoft Office Templates website and then type in 'Control Sheet' into the search box.
6. Click the 'Download' button. The template will download and install.
7. Click on 'File->Open' from Excel and locate the file you just downloaded. Press 'OK.' The control sheet template will open up. You can adjust the template to suit your needs (for example, different numbers in the rows).
8. Click on 'Insert->Chart' and follow the directions in the Chart Wizard to create a chart (for example, choose a column chart to display your data).
Read more ►

How to Insert a Watermarked Picture in Excel 2007

1. Open your Excel document. Select the 'Insert' tab.
2. Click the 'Picture' icon on the ribbons bar. Search for the file or picture on your computer. A new window will appear; select the file. Select 'Insert' and the picture will appear in the document.
3. Drag and click the picture into the position you would like.
4. Double-click on the photo for the picture toolbar to appear. On the toolbar, click 'Format Picture.'
5. Select 'Watermark' under the 'Image Control/Color' tab. Lighten or darkened your watermark as necessary.
Read more ►

Thursday, December 26, 2013

How to Get Microsoft Excel Cells to Shade Gray When Highlighted

1. Open the Microsoft Excel program on your computer. It is usually found in the 'Start' menu under 'Microsoft Office' in most computers.
2. Open a new spreadsheet or select an existing spreadsheet to edit. To open a new spreadsheet, click 'File' and 'New' at the top left-hand side of the program. To open an existing spreadsheet, click 'File' and 'Open.' You can then browse your hard drive for an existing spreadsheet.
3. Select the cell or cells you wish to fill. Click on the cell once to highlight it. If you wish to choose a group of cells, hold down the 'Shift' button while selecting cells.
4. Select your fill color. Either click the paintbucket icon in the top toolbar or right-click within the selected cells and select 'Format Cells.'
5. Select the 'Patterns' or 'Fill' tab. Several shades of gray are available to choose from. Pick your preferable shade from the existing options or click 'More Colors' to customize a shade of gray. Click 'OK' to choose your color.
Read more ►

How to Use the Paste Special Command in Excel

Switching Rows of Cells to Columns or Columns to Rows
1. Select the cells that you want to switch.
2. Open the Edit menu and select Copy.
3. Select the upper left cell of the paste area. The paste area must be outside the copy area.
4. Open the Edit menu and select Paste Special.
5. Select the Transpose check box.
6. Click OK.
Pasting Only Values, Formulas, Comments, or Cell Formats
7. Select the cell or range of cells you want to copy.
8. Open the Edit menu and select Copy.
9. Click the cell you want to paste the information into, or click the upper left boundary of the cell range you want to paste the information into.
10. Open the Edit menu and select Paste Special.
11. Select Formula to copy only the formula of the cell.
12. Highlight Values to copy only the outcome of the formula you copied into the cell and not the formula itself.
13. Select Format to copy just the format of the cell (font, alignment, and so on).
14. Choose Comments to copy only annotations for the cell.
15. Click OK to accept the option you selected.
Read more ►

How to Copy an Array to a Range in Excel 2007

1. Open Excel and load the worksheet with the data sets you want to use to feed an array formula.
2. Select a cell and enter the array formula. For example, if you wanted to have the formula multiply the number in B1 by the number in C1, you'd enter the formula =B1*C1. Hit 'Ctrl'-'Shift'-'Enter' to make sure it's entered as an array formula.
3. Select the cell with the newly entered array formula. Hit 'Ctrl'-'C' to copy it.
4. Select the other cells in the range you want in the array formula. Hit 'Ctrl'-'V' to copy the array formula throughout the range.
Read more ►

How to Create Named Ranges in Excel 2007

1. Launch the Microsoft Excel program by double-clicking the program's shortcut on the desktop or by selecting 'Microsoft Excel' from the 'Start', 'Programs' or 'All Programs' menu.
2. Click the 'Office Button' in the upper left corner of the program window and select 'Open.' Click the down arrow to the right of the 'Look in' text box to browse to the folder that contains the file you want to work with. Select the file, and click 'Open.' If you are creating a new spreadsheet, Click the 'Office Button' and select 'New.' Select 'Workbook' and click 'OK.' A blank spreadsheet should be displayed. Enter your data.
3. Select the cells you are interested in using in the named range. Click the 'Formulas' menu on the menu bar. Click the 'Define Name' button on the ribbon to open the 'New Name' dialog box. Click in the 'Name' text box and type a name of your choice. Click 'OK' to define the name and return to your spreadsheet. The name of your range should appear in the 'Name Box' in the upper left corner of the program window.
4. Click somewhere outside the named range to deselect it. Look at the 'Name Box.' The name you created has been replaced by the location of the cell you are in.
5. Click the down arrow to the right of the 'Name Box' and select the name you created. The name reappears in the 'Name Box,' and the name range becomes selected.
6. Click the 'Name Manager' button on the ribbon to view all of the names in your Workbook. Select a name to view the cells it references. Notice that the range of cells that the name refers to can be changed here. Click 'OK.'
7. Click the 'Office Button' and select 'Save' to save the spreadsheet. If you are prompted with the 'Save As' dialog box, navigate to the location you want to save the file in, enter a name for the file in the 'File Name' text box, and click 'Save.'
Read more ►

Wednesday, December 25, 2013

How to Make a Striped Line on a Bar Graph in Excel on a Mac

1. Double-click the Excel icon on the Dock or find the program in your Applications folder and double-click it. Open the Excel graph through the File menu. Alternatively, find the graph on your hard drive and double-click it.
2. Click on the a bar in your graph and click the 'Format' tab on your toolbar.
3. Click the down arrow on the 'Shape Fill' button. Click 'Texture' and then 'More Textures.' Click the circle by the label 'Picture or texture fill.' Click the 'ClipArt' button. In the search box type 'lines' (without quotes). Press 'Enter.' A selection of graphic lines will appear on your menu. Double-click one and hit the 'Close' button. Your bar graph will appear striped.
Read more ►

How to Print or Page Setup in Excel 2007

1. Click the Office Button at the top left-hand corner. Select 'Print' from the options available and then select 'Print Preview.' In the Print Preview view you will see how the printed copy will look, as well as view and adjust the margins and view page setup options.
2. Select 'Page Setup.' In the dialog box that appears you can set the spreadsheet to print in Landscape mode instead of Portrait. Click the 'Margins' tab to adjust the margins of your spreadsheet as well as vertical and horizontal alignment.
3. Click the 'Header/Footer' tab. Enter any information you want to appear in the header or footer. Click on the drop-down menus below to insert special fields, such as 'Page x of y.'
4. Click on the rightmost tab, labeled 'Sheet.' You can select whether to print gridlines and/or row and column headings here. Click 'OK' after making changes to the page setup.
5. Click the Office Button at the top left-hand corner, then click 'Print,' and 'Print' again. There are several Print options you can choose from.
6. Choose the printer you want to print to by clicking the arrow beside the printer name to view a drop-down list of printer options. Select the printer you want to use.
7. Select the number of copies you want to print. You can also choose whether to print all of your workbook or just part of it under 'Print what.' Define which pages you want to print under 'Print range.' For example, you can choose to print pages 2 to 7 by entering '2-7'. After you make any necessary changes to print options, click 'OK' and your workbook will begin printing.
Read more ►

How to Make Drop Down Fields in Microsoft Excel

Start Microsoft Excel. Open a new blank spreadsheet, or open the spreadsheet to which you want to add a drop down list.
Select the cell or the range of cells in which you want to make a drop down list.
Open the Data Validation dialog by going to the 'Data' menu in Excel 2003 and selecting 'Validation,' or by clicking the 'Data' tab of the ribbon in Excel 2007 and selecting 'Data Validation.'
Go to the 'Settings' tab. Click the drop down arrow under 'Allow' and select 'List.'
Type each list item into the 'Source' box, placing a comma between each word in the list. Click 'OK' to apply the list.
Read more ►

Tuesday, December 24, 2013

How to Find Duplicate Entries on Excel

1. Launch Microsoft Office Excel 2007 on your computer.
2. Select the rows or columns where you want to find the duplicate entries. Point your mouse in the first cell and continue to hold down the mouse while you drag over the cells you wish to search.
3. Click the 'Home' tab and then click 'Conditional Formatting' under 'Styles' in the top menu.
4. Select 'Highlight Cells Rules' from the drop-down menu. Click on 'Duplicate Values.'
5. Select 'Duplicate' under 'Format cells that contain:' in the Duplicate Values dialog box.
6. Select a highlighting style from the drop-down menu in the Duplicate Values dialog box. Styles include a variety of fill and text-color options.
7. Click 'OK.' All duplicate values will be highlighted in your Excel spreadsheet.
Read more ►

Blogger news