How to Convert the First Letter to an Uppercase in Excel

1. Decide if you want the first letter of every word to be capitalized ('Pete Is Great'), or just the first letter in the cell ('Pete is great'). In this example, assume that the original text ('pete is great' - note no capitals) is in cell A1, and you want the text capitalized in cell B1.
2. Enter the following Excel code into cell B1 if you want every word to be capitalized:=PROPER(A1)This will give the output 'Pete Is Great'.
3. Type the following Excel code into cell B1 if you only want the first letter of the cell capitalized:=UPPER(LEFT(A1,1))LOWER(RIGHT(A1,LEN(A1)-1))This will give the output 'Pete is great'.The 'UPPER(LEFT(A1,1))' part of the function tells Excel to return the left-most character in cell A1 in upper case. The 'LOWER(RIGHT(A1,LEN(A1)-1))' tells Excel to return all but the left-most character as lower case.

Read more ►

How to Build Drop

1. Scroll to the area of the spreadsheet where you want to create the drop-down list's contents. You build a drop-down list menu in Excel from data typed into any set of cells. If you want this to be inconspicuous to the Excel user, do not use the beginning of the spreadsheet. Instead, you can scroll to the right several columns or scroll down many rows to a less obvious part of the spreadsheet.
2. Type the list you want in your drop-down list menu. You can either type the list as a series of vertical cells, all in the same column, or as a horizontal list, all in the same row. For example, if you selected cell P100 as the starting point for your list, you can type each list item into P100, P101 and P102 (or into P100, Q100 and R100) and continue the list for as long as necessary.
3. Click in the cell or cells where you want your drop-down list menu to appear, based on the typed list elsewhere in the spreadsheet. If you want multiple cells to have the menu, drag your mouse over all of them so they are all selected.
4. Click on the 'Data' menu and the 'Data Tools' section. Then, click 'Data Validation' and select 'Data Validation.' In versions of Excel prior to 2007, click the 'Data' menu and select the 'Validation' option. A pop-up box will appear.
5. Click the drop-down menu on the 'Settings' tab of the pop-up window. Select the 'List' option.
6. Click in the 'Source' field.
7. Drag your mouse over the cells in your spreadsheet that contain the list of items that you typed earlier.
8. Type the 'OK' button to complete the drop-down menu setup.

Read more ►

How to Use Excel Charts

1. Launch Microsoft Excel 2010.
2. Open a file with some data already present in the cells or populate a blank sheet with some data that will be used for the chart. Include data labels for the rows and columns by typing descriptive names for the data in the next cell above the first entry in each column and in the next cell to the left of each row of entries.
3. Click in the cell above the first row label and to the left of the first column label and hold the mouse button down. Drag the mouse across the data diagonally until it is pointed at the lower right entry in the last row and last column and release the mouse button. This should highlight all the data that will be included in the chart.
4. Click the 'Insert' tab and click the small arrow at the bottom of any of the chart types listed in the 'Charts' group. Click the 'All Chart Types' button at the bottom of the list that appears.
5. Click on the desired chart type and click 'OK' to create a chart.
6. Click the 'Design,' 'Layout' or 'Format' tabs under the new 'Chart Tools' menu tab that appeared once the chart was created to access additional features and options.

Read more ►

How to Copy Vertically Paste Horizontally in Excel

1. Open the document in Microsoft Excel and highlight the cells you want to copy.
2. Click the 'Home' tab on the Microsoft Office ribbon and click 'Copy.'
3. Click on the cell where you want to paste the data.
4. Click the pull-down menu next to 'Paste' on the 'Home' tab to view a list of paste options, then click 'Transpose.' The copied data is pasted into the highlighted cell and its adjacent cells with the rows and columns reversed.

Read more ►

How to Calculate Descriptive Statistics Using Analysis ToolPak

1. Open Excel 2007 and add the numbers for which you want to calculate descriptive statistics in the first column. For example, add the numbers 210, 110, 50, 50, 70 and 80 in A2, A3, A4, A5, A6 and A7 cells of Excel.
2. Click on the 'A9' cell. This is the cell where you will calculate the descriptive statistics using Analysis ToolPak. Please note, you don't have to select 'A9' cell for the descriptive statistics calculation; any cell under your chosen values can be selected.
3. Click on the 'Data' tab and then 'Data Analysis' found on the top right-hand side of the Excel spreadsheet. A window titled 'Data Analysis' will pop open.
4. Click on the 'Descriptive Statistics.' A window titled 'Descriptive Statistics' will pop open. In the Input Range of window, select and drag from A2 to A7 cells. In the Output Range of Window, select A9 cell.
5. Click on the 'Summary Statistics' of the window. A check mark will appear next to Summary Statistics. Click 'OK.'
6. Thirteen descriptive statistics have been successfully calculated starting from 'A9' cells. In this example, the following will appear as your calculated values.Mean 96.66666667
Standard Error24.17528582
Median 75
Mode 50
Standard Deviation59.21711464
Sample Variance3506.666667
Kurtosis 3.549458572
Skewness 1.854360629
Range 160
Minimum 50
Maximum 210
Sum 580
Count 6

Read more ►

How to Make a Log with Microsoft Excel 2003

How to Make a Log with Microsoft Excel 2003
1. Choose the column headings you wish to use and determine the number of columns you will need. If your log requires the headings 'Date,' 'Time,' 'Comment' and 'Initials,' you will need 4 columns.
2. Open Microsoft Excel 2003 and type your column headers in the first row. For this example, type 'Date' in Cell A1, 'Time' in Cell B1, 'Comment' in Cell C1 and 'Initials' in Cell D1. Highlight those 4 cells and choose the format and font you wish to use for the text.
3. Highlight columns A through D and right click somewhere on the highlighted cells. Select 'Format Cells' from the menu that pops up and activate the 'Borders' tab. Click the 'Outline' and 'Inside' buttons under the 'Presets' subhead. Click 'OK.'
4. Adjust the row height to meet your needs by clicking 'Format' on the menu bar, than 'Row' and then 'Height...' The default height is '12.75' which yields approximately 50 lines per page. This may be too small for some people's handwriting, so adjust this number to meet your needs and click 'OK.' It may take some experimenting to get it just how you want it. You may use this same method to re-adjust later.
5. Change to the page break view by clicking 'View' on the menu bar and then 'Page Break Preview.' Once there, only the first 1 or 2 rows will be active and there will be a blue border around them. Click and drag the bottom blue border downward until a page divider appears and 'Page 2' appears in the highlighted area below the divider. You may have to release the border and drag again to get this to appear. Click and drag the bottom blue border upward until it aligns with the divider.
6. Adjust the column widths to meet your needs by clicking and dragging the dividers between the column headers. For example, you can change Column A's width by clicking the divider between 'A' and 'B' and dragging it in one direction or the other. Adjust the columns as wide as necessary, but do not exceed one page in width for the whole table. You will know if you have exceeded 1 page if a dotted page divider appears with 'Page 2' on the right side of it.
7. Save the file. Print as many copies as you need. When you run out of copies, you can simply open the file and print out more.

Read more ►

How to Calculate Probability Using Excel

1.
Go to Start>Programs>Microsoft Office>Microsoft Excel. If Excel has been used recently, simply go to Start>Microsoft Excel.
2.
Create two columns, one entitled 'Numeric grades' and the other 'Probability of getting each grade.'
3.
List the grades from 50, 60, 70, 80, 90 and 100 in cells A2 to A7.
4.
List the probabilities associated with each grade from cells B2 to B7. List the numbers as follows: 0.05, 0.1, 0.4, 0.3, 0.1 and 0.05.
5.
Enter '=Prob(A2:A7,B2:B7,70,100)'. This formula for probability isolates the numeric range of numbers (A2:A7), the probability of getting each grade (B2:B7), the lower range for which the probability is needed (70) and the upper range for which the probability is needed (100). In short, the formula answers the question: What are the chances of someone getting a grade between 70 and 100?
6.
Click on the '%' icon to convert the answer (0.85) to a percentage. The resulting answer is 85%. There is an 85% chance that the grade will be between 70 and 100.

Read more ►

How to Link an Excel Cell to a Word Document

1. Open the Excel document within Excel and right-click on the cell to be linked to the Word document.
2.
Select 'Hyperlink' from the cell menu and locate the Word document to link it to and then click 'OK.'
3.
Save the Excel spreadsheet and then click on the cell to open up the linked Word document.

Read more ►

How to Make a Parabola on Excel

1. Enter a series of x values into the cells in a column, entering multiple values on either side of the vertex. If you are unsure of the vertex, enter a wide range of x values.
2. Enter an equal sign followed by the formula being graphed into a cell next to the top x value, then click on the lower right corner of the cell and drag down to the cell next to the bottom x value to copy the formula automatically. Excel will not display the formula in the cells, it will show the results.
3. Highlight the values entered in both columns. If you were not sure of the vertex, find the point where the change in y reversed direction then choose cells on either side of that point. For example, if y was getting larger for five cells, then smaller for the remaining cells, the vertex is between the fifth and sixth values. The more cells chosen, the more accurate your graph will be.
4. Click 'Insert' from the menu, then select 'Chart' to launch the chart creation wizard.
5. Select 'XY Scatterplot' from the wizard.
6. Adjust the look of your graph to meet your desires by following through the wizard. You will be given the option to customize the labels, the colors and the grid lines of the graph, among other options.
7. Click finish to create the graph.
8. Click on a corner of the graph and move your mouse to adjust the size of the graph.

Read more ►

How to Convert a Mac Date System to Excel

1. Open the Excel file that contains the cells with incorrect dates.
2. Click on any empty cell. Type '1462' into this cell, as this signifies the number of days between the two date systems. Right-click the cell and choose 'Copy.'
3. Select the cells that contain the incorrect dates. To select multiple cells, click and hold on the top left cell in a range and then drag your mouse to the bottom right cell. Hold the 'Ctrl' button to select ranges that aren't adjacent to each other.
4. Right-click on any of the selected cells. Move your mouse over 'Paste Special' in the first pop-up menu that appears, and then click on 'Paste Special' that appears at the bottom of the second pop-up menu. This brings up the 'Paste Special' window.
5. Click the radio button next to 'Add' in the 'Operation' area of the window and click 'OK.' The selected dates will shift up by 4 years and a day.

Read more ►

How to Insert a PDF Into Excel

1. Open Excel 2007 and select the 'Insert' tab. Select 'Object' from the 'Text' group. The Object dialog box appears. Click the 'Create from File' tab. Select the 'Browse' button. Search your files to locate the PDF that you plan to insert. Click the file and select 'Insert.' Click 'OK.' Excel inserts the PDF into your document as an image.
2. Review the image of the PDF in your workbook. Open the PDF by right-clicking the image and select 'Adobe Document Object.' Select 'Open.' The PDF opens with Adobe in a separate Adobe window.
3. Save your changes by clicking the 'Save' icon the Quick Access Toolbar. The newly attached PDF is inserted as an attached image in your Excel workbook.

Read more ►

How to Subtract Cells in Excel

Create a Formula
1. Enter your data. For the purpose of this example, type the number 34 in cell A1 and the number 15 in B1.
2. Choose the cell where you want your results to appear. Use C1, for instance.
3. Place an equal sign (=) in C1. The equal sign always precedes formulas in Excel and goes into the cell where your results will be displayed.
4. Click on cell A1. Clicking on this cell automatically places 'A1' in cell C1.
5. Type a minus sign (-) in cell C1.
6. Click on cell B1. Clicking on this cell automatically places 'B1' in cell C1.
7. Press the 'Enter' key on your keyboard, or click on the check mark on the tool bar, to see the result of your calculation. Excel performs the calculation instantly and cell C1 displays the answer, 19. Notice that the formula appears in the formula bar when you click on cell C1.
Subtract Numbers using the SUM Function and the Autosum Button
8. Type a number into A1. For instance, type the number 10.
9. Type a number into B1, preceded by the minus sign. For instance, -8.
10. Click on the cell where you want the answer displayed, like C1.
11. Use the SUM function. Type =SUM(A1, B1) into cell C1. Click the check mark on the tool bar or press the 'Enter button' to display the answer in C1.
12. Use the 'Autosum' button, which automates the SUM function. Enter your data and then click cell C1. Click the 'Autosum' button on the toolbar to display the answer, 2, in cell C1.

Read more ►

How to Convert Excel 2007 to Excel 2002

Instructions
1. Complete your spreadsheet. Save as usual by clicking on the 'Office' button and selecting 'Save' from the drop-down menu. This will open a pop-up window. Type your file name in the 'File Name' box and click 'Save.' This will save your spreadsheet as an Excel 2007 file with the extension '.xlxs' and ensure that you have access to the original document.
2. Use the 'Save As' option to convert your Excel 2007 file to one that is compatible with earlier versions of Excel. Click on the 'Office' button again to reveal the drop-down menu.
3. Select 'Save As' from the drop-down menu. This will reveal a sidebar menu with several format options. From this menu, select 'Excel 97-2003 Workbook.' In the pop-up window that opens, type in your file's name and click 'Save.' This will convert your spreadsheet into an Excel file with the extension '.xls.'

Read more ►

How to Copy an Excel Worksheet

1. Open Microsoft Excel and the file you want to change.
2. Open the Edit menu and select Move or Copy Worksheet.
3. Click the Create a Copy option in the dialog box.
4. Select OK to create a copy.
5. Rename your newly copied worksheet by double-clicking its tab at the bottom of the Excel window.

Read more ►

How to Remove Characters in Excel 2007

1. Open your spreadsheet and select all cells from which you want to remove the character string.
2. Click the 'Home' tab and click 'Find Select' in the 'Editing' group. Click 'Replace' to open a Find and Replace dialog box.
3. Type the character or string of characters that you want to eliminate in the 'Find what' field.
4. Type the new characters that you want to insert in place of the removed characters in the 'Replace with' field. If you simply want to delete the characters, then don't type anything in this field.
5. Click the 'Find Next' button if you want to perform the search-and-replace function manually.
6. Click 'Replace All' to remove all instances of the specified characters in the selected cells.

Read more ►