Excel

Browse » Home » All posts

Tuesday, November 20, 2012

How to Create a Curve Graph in Excel or Word

1. Input your x-values into the first column, starting at cell A1.
2. Input your y-values into the second column, starting at cell B1.
3. Select 'Insert' from the toolbar and choose the 'Scatter' button. Choose 'Scatter With Smooth Lines' from the drop-down menu.
4. Select the chart by left clicking on it. Go up to the top toolbar and select 'Layout' underneath 'Chart Tools.' Select 'Primary Horizontal Axis' from the 'Axes' drop-down menu (press the down arrow beneath 'Axes' for the menu). Select 'More Options,' and change the minimum and maximum x-values by selecting the top two radio buttons. Enter a value that corresponds with your data. For example, if your spread of data is from -10 to 9.1, make your minimum x-value -10 and your maximum y-value 10.
5. Repeat Step 4 for the 'Primary Vertical Axis,' entering your y-values in place of the x-values.
6. Press close.
7. Select the graph by placing your cursor on it and left clicking on the mouse. Hit Ctrl C to copy the graph. Hit Ctrl P in Word to paste the graph into the document.

Sunday, November 18, 2012

How to Remove a Password on Excel

Office 2003
1. Launch Excel from the desktop icon or the “Start” menu of your computer. Go to the “File” menu and select “Open.” Navigate to the folder that contains the password-protected Excel workbook and double-click the file to open it.
2. Enter the password that you created for the Excel workbook, when prompted. Press “Enter” to open the workbook.
3. Go to the “File” menu in Excel and choose “Save As.” Open the “Tools” menu in the “Save As” dialog box and select “General Options.”
4. Highlight the asterisks in the “Password to open” box. Press the “Delete” key and click “OK” to close the password box.
5. Click the “Save” button. Confirm that you want to replace the existing Excel workbook, and the file is saved with the password removed.
Office 2007
6. Launch Excel. Click on the “Open” folder icon, navigate to the file on the hard drive and double-click the file name to open it.
7. Type in the password that you set for the workbook and press “Enter.” The workbook should open on the screen.
8. Click on the button with the Microsoft Office icon in the upper-left corner. Hover over “Prepare” and choose “Encrypt document” from the options that appear.
9. Highlight the asterisks in the “Encrypt document” box that pops up. Press “Delete” and click “OK.”
10. Press the “Save” button at the top of the screen to save the file. Confirm that you want to write over the original file, if prompted, and the file is saved without the password.

How to Use Excel Formula Functions

1. Launch Microsoft Excel. You can begin with a blank document or open an existing document for which you want to use formula functions. If you do not have MS Excel, use the link in Resources for a free trial.
2. Populate the spreadsheet with the data appropriate to one or more of the Excel functions that you want to use. Click once inside the cell in which you want to use a formula. Click once on the 'Insert Function' button, which is represented by the symbol 'fx' and is located immediately to the left of the 'Formula Bar.' This will launch a separate window in which you may choose the appropriate formula.
3. Use the 'Category' drop-down menu on the 'Insert Function' window to choose from a list of formula types. This will narrow the results of available formulas, but you can also choose the 'All' listing to display all available function formulas. If you are not certain which formula to use, you can type a description into the 'Search' field and click once on the 'Go' button. Click once on the function that you want to use and once on the 'OK' button. This will usually launch a separate window, if further detail is required for Excel to run the function.
4. Enter the appropriate information into any of the required fields on the 'Function Arguments' window. The names and ranges of selected criteria will display to the right of any required field, and will be red if using the entry will result in an error, or green if accurate. The anticipated result of any formula will appear to the bottom of the 'Function Arguments' window. Once the appropriate criteria have been met, click the 'OK' button once. The result will appear in the selected field.

How to Unprotect Specific Areas in Excel

1. Launch Microsoft Excel 2010 and open the spreadsheet that's protected.
2. Click the 'Review' tab on the toolbar and click 'Unprotect Sheet' from the 'Changes' group. Enter the password if prompted.
3. Highlight the cell or cells that are to become unprotected.
4. Hold 'CTRL' and 'Shift' and press the letter 'F' on the keyboard and then release all of the keys to bring up the 'Format Cells' dialog box.
5. Click the 'Protection' tab and clear the check from the 'Locked' check box. Click 'OK' to save the changes. Repeat for additional cells or ranges as necessary.
6. Click the 'Review' tab and click 'Protect Sheet' under the 'Changes' group to protect the sheet.

How to Create Percentages in Microsoft Excel 2003

1. Write out your fraction. The numerator, or top number, will be the amount you want to determine as a percent of the total. The denominator, or bottom number, will be the total amount. For example, if you have 18 marbles, five red and 13 green, and you want to determine the percent of green marbles, then 13 is the numerator and 18 the denominator.
2. Type the numerator in cell A1 of your Excel spreadsheet. Type the denominator in cell B1. Using our example, you would type 13 in cell A1 and 18 in cell B1.
3. Type the following equation in cell C1 to get a percentage from your equation:=(A1/B1)*100

How Do I Print Out Row Numbers for My Excel Spreadsheet?

Microsoft Office Excel 2007
1. Select the worksheet whose row numbers you want to print. If you want to have row numbers print on multiple worksheets, you must repeat the process for each worksheet.
2. Click 'Page Layout' from the options across the top of the screen.
3. Locate the 'Sheet Options' subgroup, which will be the fourth subgroup from the left.
4. Click the box next to 'Print' under 'Headings' to turn on the row and column titles for printing for the worksheet.
Microsoft Office Excel 2003
5. Select the worksheet whose row numbers you want to print. If you want to have row numbers print on multiple worksheets, you must repeat the process for each worksheet.
6. Click 'File' from the menus at the top.
7. Select 'Page Setup' from the drop-down menu, and then click 'Sheet Tab.'
8. Check the box next to 'Row and Column Headings,' and then click 'OK.'

How to Use the CORREL Function in Microsoft Excel

1. Start Microsoft Excel. You can do this by clicking on Start, highlighting Programs, and clicking Microsoft Excel, or double-clicking the Microsoft Excel icon on your computer's desktop.
2. Before we work with data, it's important to understand an important fact about the correlation coefficient, the value that represents the strength of the relationship between two random variables. The correlation coefficient ranges from -1 to 1, with -1 indicating a perfect negative correlation and 1 indicating a perfect positive correlation.
3. Enter the data. I'll use cells A1 to A25 and B1 to B25 for this purpose. The A column represents each student's homework average and the B column refers to each student's exam average.
4. Enter the following values, starting with cell A1 and ending with cell A25: 89, 92, 88, 76, 90, 68, 100, 87, 93, 77, 81, 80, 94, 90, 83, 79, 73, 83, 91, 84, 88, 90, 93, 80, 91.
5. Now enter the following values, starting with cell B1 and ending with cell B25: 76, 83, 80, 84, 81, 90, 92, 78, 70, 93, 82, 90, 98, 75, 67, 72, 90, 82, 77, 81, 87, 63, 92, 71, 82.
6. Now we can calculate the correlation coefficient. In cell A27, type =CORREL(A1:A25, B1:B25). A1 to A25 and B1 to B25 is where the data appears. Hit ENTER.
7. The result is -.07965, indicating a very slight weak relationship between the two variables.

How to Multiply Using Excel 2007

1. Determine the cell references that will be multiplied together. The cell reference refers to the labels on the columns and rows where the cell is located and will include a letter and a number.
2. Choose the cell where the multiplication results will be returned by clicking within that cell.
3. Click in the Formula Bar (denoted by 'Fx' at the top of the screen). Type = , then the cell reference of the first cell, * and finally the cell reference of the second cell. A correct formula will appear as: =G10*X10, according to Home Learn.
4. Press 'Enter' on the keyboard to multiply the cells together. The correct answer will now appear in the cell.

Saturday, November 17, 2012

How to Center Numbers in a Cell in Excel

1. Select the cell with the numbers you want to center.
2. Click the 'Home' tab.
3. Click the 'Center' button, located in the Alignment section.

How to Remove Duplicate Rows From an Excel Spreadsheet

1.
Click on the 'File' menu and then the 'Open' option to open the spreadsheet with the duplicate rows. The example highlights the duplicate rows for easier viewing.
2. Select the entire spreadsheet by clicking on the top left cell of the column header and then scrolling to the last row. Press the 'Shift' key and click on the lowest right cell with information. The rows are highlighted.
3.
Click on the 'Data' menu, 'Filter' and then 'Advanced Filter.' The Advanced Filter dialog box appears.
4. Choose 'Filter the List, In Place' and 'Unique Records Only.' Then click the 'OK' button. Excel hides the duplicated records.
5. With the filtered records still selected, press the 'Ctrl' and 'C' keys to copy the rows. The list is highlighted with bounding outlines.
6.
Click on the 'View' menu, 'Toolbars' and then 'Clipboard.' The Clipboard window appears with your copied data in the first icon.
7. Click on the 'Data' menu, 'Filter' and then 'Show All' to display the original list.
8. With the original list still selected, press the 'Delete' key. The list is deleted.
9.
Click the first icon in the 'Clipboard' window. The list appears with no duplicates. The example highlights the filtered rows for easy viewing.
10. Click the 'Save' button to save the spreadsheet.

How to Install Speech in Office Excel

1. Click the Windows 'Start' menu. Click 'Control Panel' and select 'Add or Remove Programs.' The 'Add or Remove Programs' screen will appear.
2. Click on 'Microsoft Office' and click the 'Change' button. Select 'Add or Remove Features' and click 'Next.' Double-click 'Office Shared Features.'
3. Double-click 'Alternative User Input' and select 'Speech.' Click the down arrow next to 'Speech' and select 'Run from my computer.' Elect to update Microsoft Office. The installation of speech recognition is complete after the update finishes.
4. Open Microsoft Excel. Click the 'Tools' menu button. Click 'Speech' to begin speech recognition.

Friday, November 16, 2012

How to Calculate the Percentage Change in Two Numbers in Excel

1. Find the beginning number and the ending number. For example, assume a business has income of $700 in 2009 and $1,300 in 2010.
2. Type the beginning number in cell A1 of your Microsoft Excel page. In the example, type '700' in cell A1.
3. Type the ending number in cell A2. In the example, type '1,300' in cell A2.
4. Type '=((A2-A1)/A1)' in cell A3. This calculates the percent change. In the example, your results should be 0.857. You can convert this to a percentage by formatting the number as a percentage using the tool bar.

How to Learn Descriptive Statistics Using MS Excel 2007

1. Define variability in data using the range, variance and standard deviation functions. In MS Excel 2007, use the Data Analysis Tool under the Data Tab in the top navigation bar. If the option is not available, install the Excel Analysis Toolpack using the MS Office Button. First select Excel Options, then Add-ins, then select Analysis Took Pac, click Go, then OK. Once installed, select the Data tab, then Data Analysis, then Descriptive Statistics; click on the input field and highlight the data. Then check the summary statistics checkbox and click OK.
2. Construct a histogram for analysis of frequency. Open a spreadsheet and enter a set of data values in a column. Select the charting function under the Insert tab and select histogram charts, then click the input field and highlight the data in your column using your mouse. Click OK.
3. Test kurtosis, skewness and distribution using the charting feature. Enter the data in rows or columns, then select Bar or Scatter Plots under the Insert Chart tab to reveal the graphical representation of data dispersion. For kurtosis, select the Formulas tab, then More Functions, then scroll down until you see KURT. Click the input field, highlight your data and select OK.
4. Utilize the stem-leaf and box-plot functions to perform projections (explanatory data analysis). The stem-leaf and box plots are available under charting using the histogram option.
5. Invest in other statistical analysis software to perform more advanced analysis. Several personal and commercial brands exist in the market. MINITAB is a popular personal tool that can be utilized with Excel for point analysis, and SPSS is available from IBM for a more comprehensive package of tools.

How to View the Contents of a Cell in Excel 2003

1. Double-click the Excel file that you want to work with to open it in Excel 2003.
2. Click on the cell that you want to see the contents of. If the cell is hidden behind a window, you can also navigate to it by clicking any cell and then using the arrow keys to move the selection to your desired cell. Finally, you can also click on the box just above the 'A' column and type in the column and row of the desired cell.
3. Look at the formula bar, which starts just above the 'C' column, to see the contents of the cell.

How to Make a Number Line in Excel

1. Open the Excel spreadsheet that needs to have a number line. Click the 'Insert' tab at the top of the window.
2. Click the 'Shapes' button inside the 'Illustrations' heading. Select the image of a line with an arrow at either end inside the 'Lines' heading.
3. Click the bottom line of the cell that needs to be the far left end of the number line. Drag across to the last cell that needs to the far right end of the number line. For example, click the bottom line of 'D6' and drag across to the end of the 'N6' cell to make a number line that spans from the 'D' column to the 'N' column of row 6.
4. Click the second cell in the range, such as 'E6.' Select the 'Home' tab and click the 'Borders' icon inside the 'Font' heading. Click the 'Left Border' button to add the first vertical line on the number line.
5. Repeat the process with each other cell in the range that needs to have a vertical line to designate an entry on the number line.
6. Click one of the cells below the horizontal number line that needs to have a number inserted. For example, click 'E7' if you want the first number to appear in row 7.
7. Navigate back to the 'Insert' tab and click the 'Text Box' button in the 'Text' heading. Click the cell again and drag until the text box is the size you want for the first number. Type the number in the box and then select the font size in the 'Font' drop-down menu.
8. Click the left edge of the text box and drag the number to a different location if it doesn't appear exactly where you want it on the number line. Repeat the process of creating text boxes for any other numbers that need to appear on the line.

Subscribe to: Comments (Atom)