How to Construct a Histogram Using Excel 2007

1.
Capture the stock data. Go to Yahoo Finance and type 'SBUX' in the symbol box. Click on the link that says 'historical prices'. Go to the bottom of the page and click 'download to spreadsheet'. The info will download automatically and then open in an Excel spreadsheet.
2.
Get the Max and Min values of the 'Adj Close' column. Go to the editing option of the Home menu. In the drop-down box of mathematical functions select 'Max.' Type 'G2:G501' and press 'Enter.' Repeat the same with 'Min.' The Max value should be 28.29 and the Min value should be 7.17.
3.
Create the bin values. Round 28.29 to 30 and 7.17 down to 5. Start at 5 and add increments of 1 until you get to 30. Type those numbers in the column next to 'Adj Close' and call it 'Bin values.'
4.
Open the histogram dialog box. Under the 'Data' tab select 'Data Analysis'. In the dialog box select 'Histogram' and press 'OK.' The Histogram dialog box will then open.
5.
Input the histogram setting. In the 'Input Range' field type '$G$2:$G$501' and in the 'Bin Range' field type '$H$2:$H$25'. These are the cell ranges of the data and bin values respectively. In 'Output Options' select 'New Worksheet Ply' and name the worksheet 'Histogram.' Then select chart output and press 'OK.'
6.
Survey the Histogram. Observe the distributions of the lines. If they bundled in the middle the histogram is said to be 'evenly distributed' or 'bi modal.' This is usually the case with test or survey data. As is sometimes expected with erratic stock data the histogram in this article turned out to be 'saw-toothed.' This kind of distribution might indicate that the stock under inspection has been quite volatile over the past 500 days.

Read more ►

How to Make Sums in Excel 2010

1. Open the Microsoft Excel 2010 spreadsheet that contains the numbers you want to add together.
2. Click on an empty cell in the spreadsheet, where you want the summation to appear. Type the equals sign into the cell to start a formula.
3. Enter 'SUM(' if you want to add together a number of cells. Type in the column letter and row number of the first cell that you want to include. Place a colon after this cell reference if you are adding together a continuous range of cells, then type in the last cell in the range. Place a comma after the first reference if the selected cells are not continuous on the spreadsheet, and enter in the second cell reference. Continue adding commas and cell references until you have entered all of the cells you want to add together. Enter a close parenthesis and press 'Enter.' For example, if you want to add the cells from 'A1' to 'B10,' enter: '=SUM(A1:B10).' If you want to add just 'A1' and 'B10,' enter '=SUM(A1,B10).' If you want to add 'A1' through 'A10,' but include 'B10' as well, enter '=SUM(A1:A10,B10).'
4. Enter 'SUMIF(' if you only want to add together some of the cells, based on the values of adjacent cells. Type in the first cell in the range that you want to check for a given criteria, then place a colon followed by the last cell in the range of cells. Type in a comma, then enter the value that you want to check for in the range of cells. This can be a simple number, a piece of text enclosed in quotes, or a cell reference. Type in another comma, then type in the range of cells that you want to add together if the cells qualify given your condition. So if you entered '2001' as your criteria value, Excel will look through the first range of cells and whenever it finds '2001,' it would add together the corresponding cell in the second range of cells. Type in a close parenthesis and press 'Enter' to complete the formula. For example, if you want to check cells 'A1' through 'A10' for the value '23,' and then add together the corresponding cells in the range of 'B1' through 'B10,' enter: '=SUMIF(A1:A10,23,B1:B10).'
5. Type 'SUMIFS(' into the cell if you want to sum together a range of cells based on multiple criteria. SUMIFS is similar to SUMIF, except the arguments are arranged in a slightly different order. Type the range of cells that you want to sum together into the formula, then enter a comma. Type the range of cells to check for a criteria, followed by a comma and the criteria itself. Enter another comma and continue to add criteria ranges and criteria until you have entered all data. Place a close parenthesis at the end of the formula and press 'Enter.' To add together cells 'A1' through 'A10' whenever '23' appears in column 'B,' and '25' appears in column 'C,' enter: '=SUMIFS(A1:A10,B1:B10,23,C1:C10,25).'

Read more ►

How to Link Data in Other Excel 2007 Workbooks

1. Open the Excel 2007 workbook that contains the data for which you want to link to other workbooks.
2. Double-click in the cell on the Excel workbook the contents of which you want to link to other workbooks. This will select all the contents in that cell.
3. Right-click in the selected cell and then click 'Copy.'
4. Open the other Excel 2007 workbook to which you want to link the data you selected from the workbook that you opened in Step 1.
5. Right-click in an empty cell on the workbook, click the 'Home' tab, click the downward pointing arrow below 'Paste' and then click 'Paste Special.'
6. Click the 'Paste Link' button on the Paste Special dialog box that opens and then click 'OK.' Repeat steps 3 to 6 in other workbooks to which you want to link the selected data.

Read more ►

How to Use the Cursor to Highlight Rows in Excel 2003

1. Move the cursor to the row number on the left side of your spreadsheet and click the number to highlight the row.
2. Move the cursor to another row number, hold down the 'Shift' key, and click the row number to highlight all the rows between the first highlighted row and the new row. For example, highlight row 12, move the cursor to row 20 and shift-click the row number to highlight all rows between 12 and 20.
3. Move the cursor to another row, hold down the 'Ctrl' key and click the row number to highlight only individual rows. For example. highlight row 12, move the cursor to row 20 and ctrl-click the row number to highlight rows 12 and 20.

Read more ►

How to Create a Drop Down List in Microsoft Excel

1. Type the list items into cells in a column of the current worksheet or another worksheet. Name the list if you enter it into a different worksheet. Select the list and click inside the 'Name' box at the top left corner of the worksheet next to the 'Formula Bar.' Type a name for the list and press 'Enter.'
2. Click on the cell in which you want to create a drop-down list. To enter the list into several cells, press and hold the 'Ctrl' key and click on each cell in which you want to use the list.
3. Go to the 'Data' menu in Excel 2003. Click 'Validation' and go to the 'Settings' tab of the 'Data Validation' dialog box. Go to the 'Data' tab in Excel 2007. Click 'Data Validation' and select 'Data Validation' from the menu. Go to the 'Settings' tab of the 'Data Validation' dialog box.
4. Select 'List' in the 'Allow' box. Enter an equal sign followed by the cell range containing your list into the 'Source' box if the list is on the same worksheet. Enter an equal sign followed by the range name into the 'Source' box if you created the list on another sheet. For example, if the range name is 'Fruits,' type '=Fruits' into the 'Source' box.
5. Clear the 'Ignore Blank' check box if you want to require users to select a list item rather than leave the cell blank. Go to the 'Input Message' tab if you want to display a message when the cell is selected. Type your message into the 'Input Message' box. Click 'OK' to create the drop-down list in the selected cell or cells.

Read more ►

How to Count All Rows With a Blank Cell in Excel 2007

1. Type '=COUNTBLANK(' in an empty cell.
2. Highlight the column of data you want to calculate the number of empty cells.
3. Press 'Enter.'

Read more ►

How to Create a Report in Microsoft Excel 2007

1. Complete the data and calculations in your worksheet. Even if your data and calculations span multiple worksheets, you can pull the data together into one report.
2. Roughly lay out how you want the report to look, including what you want in headers and footers, what text you want to be emphasized and what kind of graphical elements you want to include.
3. From the Insert tab on the Office Fluent Ribbon, click 'Header Footer' in the Text group to design the headers and footers, which are the text that displays on every page of the report. This opens the Header Footer Tools ribbon, where you can add page numbers, variables, date and time stamp, and pictures.
4. From the Insert tab, add visual interest to your report by inserting your own pictures, Microsoft clip art or SmartArt. You can also insert shapes, freehand drawings and text boxes. Using these tools, which are similar to the drawing tools in other Microsoft applications, you can do things such as add a stylized title to your report, include a pertinent graphic or illustration, or represent some aspect of your worksheet in a way other than a traditional graph.
5. From the Home tab, format the text and cells of your worksheet using features such as cell shading, cell borders, text alignment and fonts.
6. From the Page Layout tab, adjust printing aspects of your report, including the size of page margins, which rows or columns to repeat on subsequent pages and where page breaks occur. If you have more data on a given worksheet than you want to print on the report, use the Print Area command to explicitly identify the area of the worksheet to print.
7. From the Microsoft Office Button (the round, muticolored button in the upper-left corner of the Excel window), select Print and then Print Preview.
8. Iterate through steps 3 through 6, adjusting graphics, layout and formatting until your report is printing appropriately.

Read more ►

How to Calculate Sample Variance Using Excel

1. Add the numbers in the first column of your Excel 2007 document. For example, add the numbers 100, 200, 300, 400, 500 and 600 in A2, A3, A4, A5, A6 and A7.
2. For this example, click on the 'A9' cell. This is the cell where you will calculate the variance. When you calculate another variance, choose any cell at the bottom of the list of numbers you are using.
3. Click on the 'Formulas' tab while you are in the 'A9' cell. Click on 'Statistical' on the drop-down menu.
4. Click 'Insert Function' on the top left-hand side of the Excel spreadsheet. The 'Insert Function' window will pop open.
5. Click on the drop-down menu of 'Or select a category.'
6. Scroll down the 'Select a function' window. Choose 'VAR,' which is the function of variance based on the sample.
7. Click 'OK.' The 'Functions Arguments' window will pop open. Ensure that on 'Number 1' cell, A2:A7 is populated. If A2:A7 is not populated, enter A2:A7 manually. Click 'OK.'
8. The variance has been successfully calculated. In this example, the calculated value of the variance is 35,000.

Read more ►

How to Add a Subtotal to a Pivot Table

1. Select your items, row, or column that you would like to subtotal in your pivot table report.
2. Click 'Field Settings' in the 'Active Field' group on the 'Options' tab.
3. Click 'Automatic' under 'Subtotals' to subtotal the outer row or column label.
4. Select 'Custom' under 'Subtotals' to choose a function for an inner row or column label.

Read more ►

How to Adjust Chart Fonts in Excel

1. Start Microsoft Excel 2007 and open a spreadsheet from your files that contains a chart in which you want to change the formatting of the font in that chart.
2. Right-click on the text in the chart that you want to change the font or other formatting feature. The 'Mini Toolbar' will appear over the shortcut menu that appears. The 'Mini Toolbar' contains everything you need to adjust the chart font.
3. Use the 'Font Type' drop-down list to choose a new font for the selected text. The 'Font Size' drop-down list allows you to change the size of the font that you have selected. The 'Increase Font' and 'Decrease Font' buttons allow you to quickly adjust the size.
4. Use the styles buttons to make the selected text bold or italic by choosing the 'B' button for bold or the 'I' button for italic.
5. Align the selected text by choosing the 'Right Align,' 'Center Align' or 'Left Align' buttons.
6. Change the color of the selected text by picking a color from the 'Text Color' drop-down box. Click 'More Colors' at the bottom of the drop-down box to display the Color Picker where you can create a custom color for the selected text.

Read more ►

How to Add a Counter in Microsoft Excel

1. Log on to your computer and open Microsoft Excel. Create a new spreadsheet.
2. Label the columns in your spreadsheet by giving them descriptive titles. For instance, you could create a 'Description' column, a 'Price' column, a 'Quantity' column and a 'Total Cost' column for a spreadsheet used to track orders.
3. Add a column and give it the title 'Count.' Go down to the bottom of the spreadsheet and type '=COUNT(firstrow:lastrow).' For instance, if the first cell in your spreadsheet that contains data is B2 and the last cell containing data is B50, your formula would read '=COUNT(B2:B50).'

Read more ►

How To Enable Excel Macros

1. Launch Microsoft Office Excel, click the 'File' tab and click 'Options' to open the Excel Options Window.
2. Click 'Trust Center' to open the Trust Center Window from the left pane of the Window.
3. Click 'Macro Settings' and choose the option that says 'Enable all macros (not recommended, potentially dangerous code can run).' Click 'OK' and click 'OK' again to close the Windows.
4. Exit Excel and restart it to enable all macros.

Read more ►

How to Select Multiple Non

1. Select the first range of cells by holding down the 'Ctrl' key, selecting the fist cell of interest with the left mouse button, and mousing over the range. When you have finished highlighting the range, release the mouse button but keep the 'Ctrl' key depressed.
2. Move the cursor to the next range of cells you would like to highlight.
3. Press the left mouse key to highlight the cell, then (keeping the left mouse button down) highlight the next area you would like to select. When finished highlighting, release the left mouse button.
4. Repeat Step 3 for as many ranges as you would like to select.

Read more ►

How to Convert XPS to Excel 2003

1. Download a preferred converter software. Websites such as Free Downloads Center or File Buzz have XPS-to-Excel 2003 converter software available for downloading. Simply click on the preferred software and select 'Run' when prompted. Install the software when the download is complete.
2. Open Excel 2003. Select 'File' and 'Open.' Browse through the files to find the XPS file. Select the file and click 'OK.' The software will convert the XPS file into a format that Excel 2003 can read.
3. Select 'File' and then 'Save As.' Create a preferred name and change the file extension of .xps to the Excel extension instead. Click 'Save.'
4. Close the file and reopen it to check that it saved properly. Close Excel 2003 when completed.

Read more ►

How to Un

1. Open the spreadsheet you wish to modify. Hold down the 'Ctrl' key, and tap the 'A' key twice. This should select all of the cells in the spreadsheet. Press 'Ctrl C' to copy the cells to the clipboard.
2. Click on the Microsoft Office logo at the top-left corner of the Excel screen and click 'New'. Click the cell labeled A1 to select it, then press 'Ctrl V' to copy the cells into the worksheet.
3. Press 'Ctrl S' to bring up the 'Save As' dialog box. Click the 'Tools' button, and select 'General Options'. Make sure the password box is empty. Delete the contents of the box if necessary. Click 'Ok' to close the options screen, then type in a new file name and click the 'Save' button.
4. Open the new spreadsheet file to confirm all of the data is present. Right-click on the old spreadsheet file and select 'Delete'.

Read more ►