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 'O...
Saturday, December 28, 2013
How to Calculate the P
Calculate Correlation1. 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...
How to Send a Microsoft Excel 2007 Worksheet As an Email
Sending an Excel File Via E-mail1. 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...
How to Insert a Row in Microsoft Excel 2003
How to Add a Single Row1. Open an Excel Worksheet or create a new one.2. Highlight the row header immediately below where the new row should appear.3. 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 Rows5. 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 selecti...
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...
How to Use Microsoft Excel to Draw Control Charts and Graphs
Excel 20071. 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....
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 necessa...
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....
How to Use the Paste Special Command in Excel
Switching Rows of Cells to Columns or Columns to Rows1. 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 Formats7. 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...
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 ran...
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....
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...
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...
How to Make Drop Down Fields in Microsoft Excel
1. Start Microsoft Excel. Open a new blank spreadsheet, or open the spreadsheet to which you want to add a drop down list.2. Select the cell or the range of cells in which you want to make a drop down list.3. 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.'4. Go to the 'Settings' tab. Click the drop down arrow under 'Allow' and select 'List.'5. Type each list item into the 'Source' box, placing a comma between each word in the list. Click 'OK'...
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...
Subscribe to:
Posts (Atom)