How to Create a Standard Deviation Graph in Excel

1. Open Excel. Open a data file or type the data into a series of columns with one value per column.
2. Click 'Insert' and select 'Scatter.'
3. Select the type of scatter graph you wish to insert.
4. A blank area should be inserted and you should see new tabs as options on the menu bar. Click the 'Design' tab and choose 'Select Data.' Hold 'Shift' while selecting the data and click 'OK' in the pop-up window.
5. Click on the 'Layout' tab and select 'Error Bars.' Select 'Error Bars with Standard Deviation' from the drop-down window.

Read more ►

How to Calculate Mean in Excel 2007

1. Enter your the data in column A. For example, if you have four numbers to enter, you would enter them in cells A1 through A4.
2. Determine the range for your data. For example, if you entered four data points, your range would be A1:A4.
3. Enter the formula '=AVERAGE(Range)' into cell B1 to have Excel automatically calculate the average of your data. In this example, since your range equals A1:A4, you would enter '=AVERAGE (A1:A4)' into cell B1 and the average will appear.

Read more ►

How to Embed a PDF File in Microsoft Excel 2003

1. Open the Excel document you're editing if it's not open already.
2. Select the location where you want to embed the PDF. When you insert the PDF, the top-left corner of the document will be flush against the top-left corner of whatever cell you have selected.
3. Click the 'Insert' menu at the top of the screen and select 'Object' to open the 'Object' window.
4. Select 'Adobe Acrobat Document' from the 'Object type' section and then click 'OK.' Excel will display an 'Open' window.
5. Navigate to and select the PDF that you want to embed into Excel.
6. Click 'Open.' Excel will embed the PDF into your document and open the PDF in Adobe Reader.

Read more ►

How to View Different Worksheets in the Same Workbook in Excel 2003

1. Open the workbook in Excel 2003.
2. Click 'Window,' then 'New Window.' Excel will now feature two windows for the document. You can select a different worksheet in the new window if you like. Repeat this until you have as many windows open as necessary.
3. Click 'Window,' then 'Arrange.' Choose whether to arrange the windows horizontally, vertically or one of the other ways. This will equally split the windows; you can drag their corners to resize them.

Read more ►

How to Add a Workbook to Microsoft Excel

Excel 2003
1. Log on to your computer and open Microsoft Excel. Open a new or existing spreadsheet.
2. Place your cursor to the right of where you want the new workbook to appear. Click on the 'Insert' menu.
3. Choose 'Workbook' from the menu and click 'OK.' You will now see a new tab at the bottom of the spreadsheet.
4. Click on the 'Format' menu and choose 'Sheet' from the menu. Choose 'Rename' and give the new workbook a descriptive name.
Excel 2007
5. Log on to your computer and open Microsoft Excel. Open a new or an existing spreadsheet.
6. Locate the bar at the bottom of the spreadsheet that lists the existing tabs. Click on the 'Insert' button to the right of the last tab. A new worksheet will be added to the right of the last existing one.
7. Select an existing tab to place a new workbook in front of that tab. Then click on the 'Home' tab in the 'Cells' group and choose 'Insert' from the list.

Read more ►

How to Open Excel Without Macros

Starting Excel from the Desktop or Start Menu
1. Press and hold the 'Shift' key on your computer's keyboard.
2. Click on the Excel icon on your computer's Desktop or click 'Start,' 'All Programs,' 'Excel.' Excel's splash screen will appear and the program will open.
3. Release the 'Shift' key once the default blank workbook appears on your computer's screen.
Starting Excel from the Office Shortcut Bar
4. Click on the Excel icon on the Office Shortcut bar on your computer's Desktop.
5. Press and hold the 'Shift' key on your computer's keyboard immediately. Excel's splash screen will appear and the program will open.
6. Release the 'Shift' key when a blank workbook appears on your computer's screen.

Read more ►

How to Print Continuing Row and Column Headings in Excel 2003

1. Open the Excel file that you want to work on. With Excel open, go to 'File > Open' and find your file.
2. Click on 'File > Page Setup.'
3. Click on the Sheet tab.
4. Click on the chart icon next to the box for 'Rows to Repeat at Top.' This will take you back to your Excel sheet. You can now click on the row that you would like to appear on subsequent pages. For example, if there is a row with headings you'd like to repeat, choose that one. After you click each row, your choice will appear in a box on the main screen. Hit 'Enter' to return to the dialog box.
5. Click on the chart icon next to the box for 'Columns to Repeat at Left.' Click on the column that you want to see repeated. In this case, choose the column that contains your headings. Hit 'Enter.'
6. Click 'OK' to save your settings.

Read more ►

How to Make Bold Letters in Excel

1. Open the Excel file in which you want to make bold letters. Enter text in a cell or multiple cells.
2. Click the cell or group of cells in which you want to add bold font. If you want an entire row or column to contain bold font, select the entire row or column by clicking the letter or number at the beginning of the cell or row.
3. Click the 'Home' tab.
4. Click the 'Bold' button. The Bold button is represented by a 'B' and is located in the Font group.

Read more ►

Step

1. Click the Windows 'Start' button, and select 'All Programs.' Click 'Microsoft Office,' then click 'Excel 2003.' The software opens on the computer to the main window. Excel automatically starts a new spreadsheet for you, if you want to create a new worksheet.
2. Click the 'File' menu item, then click 'Open.' The 'Open' dialog window lets you open an existing spreadsheet. Double-click an XLS file to load it in the Excel software, if you want to edit an existing spreadsheet.
3. Create the data in your spreadsheet. The type of data you enter into the spreadsheet is determined by what you intend to create. You can type text and numbers into the Excel cells. To create formulas, you must enter only numbers in a cell. For instance, if you want to make a spreadsheet of revenue, type 'Revenue' in the 'A1' cell. Excel marks each row with a number and columns with a letter, so 'A1' is the first cell on the spreadsheet.
4. Type your revenue data under the A1 cell. For instance, type '30' in A2 and '40' in A3. The following is what the spreadsheet should look like:Revenue3040
5. Create a formula to add the two revenue values. You can add two or several values in a formula. You prefix a formula with the equals sign. For instance, to add the two values typed in step four, type the following in A4:=sum(a2:a3)The formula above tells Excel to add cells A2 through A3. After you press 'Enter,' notice the value in the cell is the total sum of the two cells.
6. Highlight any cells you want to format. Click the 'Format' menu item, then click 'Cells.' A configuration window opens. The configuration window lets you set up the font, colors, background color, borders and alignment. Make you changes in the window and click 'OK' to see the changes.
7. Click the 'Save' toolbar button at the top of the window after you complete all of the spreadsheet changes. The file extension used for Excel 2003 is XLS. To open the file in the future, click 'File,' then view the files listed in the 'Recent' list. You can open the file using this method, if you forget the file name.

Read more ►

How to Use MS Excel to Make an Age

1. Create six column headers in row one, starting in column A. From left to right, the column headers should be “Male,” “Female,” “Total,” “Age Range,” “% Male” and “% Female.”
2. Input the age ranges that you have the information for under the “Age Range” column. If you are using a hyphen to denote the age range, like “11-14,” right-click the cells and choose “Change Format.” Then change the format to “Text.” Otherwise, Excel may automatically change your ranges to dates.
3. Place the population numbers for males and females that correspond to the age range in the row, under the “Male” and “Female” columns.
4. Input this formula: “=SUM(A2:B2)” into the first cell under the “Total” column. Move your mouse over the bottom right corner of the cell; it should turn into a plus sign. Click and drag the mouse down the column to the last row. Release the mouse button to copy the formula to every cell in the “Total” column. Select cell G1 and type in this formula: “=SUM(C:C)”. This will give you the total population for the entire graph.
5. Highlight all of the cells in columns E and F. Click on the “Home” table at the top of the screen and find the “Number” section. There will be a drop-down box that should read “General.” Change “General to “Percentage.”
6. Input the following formula into cell E2: “=0-(A2/$G$1)”. This will give you a percentage of the overall population that are males in that age group. It will be represented by a negative number for the sake of the graph you are making. Input this formula into cell F2: “=B2/$G$1”. This formula will give you the percentage for females, only as a positive number. Highlight both E2 and F2, then click on the bottom right corner and drag the formula down to fill every row in the table.
7. Highlight rows D, E and F. Click on the “Insert” tab and find the “Charts” area. Click on “Bar” and, under the “2D Bar” section of the drop-down menu, choose “Clustered Bar.” It should be the first choice on the left. A crude graph will now display on the screen.
8. Move your mouse over the age ranges listed in the middle of the graph. The words “Vertical (Category) Axis” will appear under the mouse when you are in the right place. Right-click and choose “Format Axis.” Click on the second radial button in the new window, labeled “Specify Interval Unit” but leave this set to “1.” Click on the drop-down menu next to “Axis Labels” further down the window and choose “Low.” This will move the age ranges to the left side of the graph.
9. Right-click on any of the colored graph lines and choose “Format Data Series.” Move the “Series Overlap” slider all the way to the right so it reads “100 %.” Move the “Gap Width” slider all the way to the left so it reads “0 %.” Now click 'Close' and your age-sex graph will be complete. You can modify the style of the graph, as far as headers and labels go, just like any other Excel graph.

Read more ►

How to Format Cells to Make Negative Numbers Appear Like 0000.00 in Excel

1. Open the Excel 2010 spreadsheet where you want to adjust the number format.
2. Click on the top-left cell in the area where you want to adjust the number format. Hold the mouse button down and drag your mouse pointer to the bottom-right cell, then release the button to select the entire area. Alternatively, you can select the column letter, or row number, to select an entire column or row.
3. Right-click your mouse while your pointer is located anywhere within your selection. Choose “Format Cells” from the small menu that appears and the Format Cells window will appear.
4. Click on “Custom” from the list on the left side of the window. Then place your cursor into the “Type” field on the right side of the window and use “Backspace” to erase whatever format is currently in there.
5. Enter the following code into the “Type” box:#,##0;'0000.00'The characters before the semicolon will control how positive numbers appear, while the characters after the semicolon will replace any negative number with “0000.00.” Click “OK” to close the window and complete your format change.

Read more ►

How to Graph a Line Graph in Excel 2007

1. Open the Microsoft Excel 2007 application on your computer and click on the 'Microsoft Office' button. Click on the 'Open' option.
2. Locate the Excel 2007 file on your computer that contains the data you want to turn into a line graph. Select the file and then click on the 'Open' button.
3. Click on the 'Insert' tab and then click on the 'Line' option from the 'Charts' group. Click on the 'Line with Markers' option.
4. Use your mouse to highlight the data within the spreadsheet that also contain labels for the rows and columns. The Chart Tools feature now becomes available.
5. Click on the 'Design' tab and the select a line graph style from the 'Chart Styles' group. Click on the 'Layout' tab and then click on the 'Chart Title' option. Click on the 'Above Chart' option.
6. Click in the chart title text box and enter a title for your chart. Right-click on the chart title and enter a size for the chart title that meets your preference in the 'Size' box.
7. Click on the 'Layout' tab and then select a legend style for your line graph from the 'Chart Elements' box. Click on the 'Legend' option from the 'Layout' tab and select the position for the legend, such as the 'Show Legend at Top' option.
8. Click on the 'Axis Titles' option from the 'Layout' tab and enter titles for the X axis and Y axis of your line graph. You make any other changes to the line graph, such as thickness or color of lines, by clicking on the 'Design' tab.

Read more ►

How to Lose the Zeroes in Excel

All Zero Values
1. Move your mouse pointer to the 'File' tab and left-click. Click 'Options.'
2. Find the 'Advanced' category at the top and click it. Locate 'Display options for this worksheet' and select your worksheet.
3. Remove the check beside 'Show a zero in cells that have zero value.' The cells with zero values now appear blank and contain no numbers.
Selected Cells
4. Move your mouse pointer to the cells with zero values that you want to lose. Hold down the left button and drag your mouse. This highlights the cell(s).
5. Locate the 'Cells' group in the 'Home' tab. Click 'Format.' followed by 'Format Cells.'
6. Find the 'Category' list. Click on 'Custom.'
7. Type '0;-0;;@', without the quotation marks, in the 'Type' box. This hides the zero values.

Read more ►

How to Do Addition in Excel

Using the Plus Sign
1. Open the Microsoft Excel 2010 spreadsheet that you want to work with.
2. Click on an empty cell on the spreadsheet, wherever you want the results of your addition to be listed.
3. Type '=' -- the 'equals' symbol -- which indicates the start of a formula, then type in the number or cell reference of the first thing you want to add. If entering a cell reference, place the column letter of the cell in front of the row number, so that the first cell on the spreadsheet is 'A1' and the one under that is 'A2.'
4. Enter a ' ' sign into your formula, then enter the second number or cell reference that you want to add. Continue alternating ' ' signs and numbers or cell references until you have entered all the information you want to add together. Press 'Enter' to complete your formula. The result of the addition appears in the cell.
Using the SUM Function
5. Open the Microsoft Excel 2010 spreadsheet that you want to work with. Click on any empty cell.
6. Type '=' -- the 'equals' symbol -- which signifies that you are starting a formula, then type the word 'sum' and place an open parenthesis at the end of the word. This tells Excel that you will be performing the 'SUM' function on the values in the parentheses.
7. Enter the first number that you want to add, or the first cell reference, followed by a comma, then enter the second value or reference, followed by another comma. Continue alternating values and references with commas until you have entered all the items you want to add together. Enter a close parenthesis and press 'Enter.' The result of your addition appears in the cell.

Read more ►

How to Make a Bar Graph in Excel 2010

1. Open a new Excel 2010 spreadsheet. Identify two or more variables you want to include in your bar graph. For example, to graph the number of lung cancer cases occurring over the past 100 years, use the variables 'Decade' and 'Lung Cancer Cases.'
2. Place the independent variable on the x-axis of a bar graph. Type the variable name, such as 'Decade,' into cell A1. Type the second variable name in cell B1. This variable goes on the y-axis of your bar graph. Add additional variables to the spreadsheet if necessary.
3. Type numerical data under each variable. Include as many cells as necessary to complete your entire data set.
4. Click the 'Insert' tab and select 'Column' in the 'Charts' section. Select the '2-D Column' chart. A blank box will appear in your Excel 2010 spreadsheet.
5. Click 'Select Data' in the 'Design' tab of the 'Chart Tools' area. Click the 'Add' button to select the data for the y-axis of the bar graph. Type the variable name in the 'Series Name' box. Select the range of data points in the 'Series Values' box. Click 'OK.' Add additional variables to the y-axis if applicable.
6. Click the 'Edit' button in the 'Horizontal (Category) Axis Labels' section. Click and drag your mouse to highlight the x-axis values from the spreadsheet. They will appear on the bottom of the bar graph.
7. Click the 'Layout' tab of the 'Chart Tools' area. Use the options in this tab to change the axis names, grid lines, legend or chart title. Click the 'Format' tab in the 'Chart Tools' section to modify the color, shape and appearance of the bar graph.

Read more ►