How to Make a Log with Microsoft Excel 20031. 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....
Browse » Home » All posts
Friday, December 14, 2012
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...
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 docume...
Thursday, December 13, 2012
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...
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...
Wednesday, December 12, 2012
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...
How to Subtract Cells in Excel
Create a Formula1. 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...
How to Convert Excel 2007 to Excel 2002
Instructions1. 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....
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 wind...
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...
How to Get Started With Excel VBA
Record a Macro1. If you have ever recorded a macro, you are already using VBA. The Visual Basic editor translates your keystrokes into VBA commands. The resulting code is inefficient, but it can help you get familiar with VBA syntax and commands.2. In Excel, record a simple macro. In Office XP, select Macro, Record New Macro from the Tools menu. (In Excel 2007, commands are on the Developer tab.) Change the macro name or leave the default, and press OK.3. With the macro recorder running, type 'Hello World' in cell A1. Apply Bold, Italic, and Underline, and change the font color to red. Double-click...
Tuesday, December 11, 2012
How to Create Multiple Graphs in One Chart
1. Open your spreadsheet program and enter your two data sets into adjacent columns. Type a label for your data sets in the first row of each column. (Note: These instructions are based on Open Office Calc, a free spreadsheet program, but the process will be similar when using Microsoft Excel.)2. Click and drag to select all of the cells whose data you wish to include in your chart, including the 'label' cells at the top of each column.3. Click 'Insert' and then 'Chart.' Select 'Line' from the 'Choose a chart type' column. Select 'Lines and Points' from the icons on the right-hand side of...
How to Create a 4 Axis Chart in Excel
1. Create a new spreadsheet in Excel.2. Type the label names of your axes in each column, for example, Axis 01, Axis 02, Axis 03, and Axis 04 as headers in columns A, B, C, and D respectively.3. Type the corresponding data for each column and row. The row data will be the “Series” plotted against the actual axis of each column.4. Highlight the entire set of rows and columns by dragging the mouse cursor across the axis and data fields while holding the left mouse button down.5. Click “Insert,' 'Charts,' then 'Other Charts' and choose a 'Radar' option from the main me...
How to Print Odd Even Pages in Excel 2007
1. Click on the 'Developer' tab in Excel 2007.2. Click on 'Visual Basic' to open the Visual Basic Editor (VBE).3. Click 'Insert,' then 'Module' to open a blank module window.4. Copy and paste the following code into the module window:Sub PrintOddEven()Dim TotalPages As LongDim StartPage As LongDim Page As IntegerStartPage = InputBox('Enter starting page number')TotalPages = Application.ExecuteExcel4Macro('GET.DOCUMENT(50)')If StartPage > 0 And StartPage 5. Press 'F5' to run the macro. A pop-up window will appear and you will be returned to the Excel spreadsheet.6. Type the starting...
How to Make a 2 Column List in an Excel Spreadsheet
1. Open Microsoft Excel 2007 on your computer. As you can see, several columns and rows already come up in Excel.2. Place a title at the top of the spreadsheet. This is very important so that you know what is actually listed in the spreadsheet. Place the title at the very top of the page, starting in cell A1.3. Add titles to the two columns that will compose the list. Place the column titles a few lines down from the title of the spreadsheet. This will help you remember what information is in each column. Center the columns by highlighting both cells and click on the centering icon (showing...
Subscribe to:
Posts (Atom)